Home > mailing lists

Re: Severe performance problems for simple query - Mailing list pgsql-performance

From	Florian Weimer
Subject	Re: Severe performance problems for simple query
Date	April 7, 2008 19:38:56
Msg-id	87lk3plcni.fsf@mid.deneb.enyo.de Whole thread Raw
In response to	Severe performance problems for simple query (Dimi Paun <dimi@lattica.com>)
List	pgsql-performance

* Dimi Paun:

>   * 4.9 million records in a table (IP address info)

You should use the ip4r type for that.

From: Oleg Bartunov
Date: 07 April 2008, 18:48:08
Subject: Re: what worked: performance improvements for geo-spatial searching on FreeBSD

From: Mark Stosberg
Date: 07 April 2008, 19:50:37
Subject: per-review of PgBouncer / Slony design