Re: Severe performance problems for simple query

From: Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
To: Dimi Paun <dimi(at)lattica(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Severe performance problems for simple query
Date: 2008-04-07 18:53:37
Message-ID: 87lk3plcni.fsf@mid.deneb.enyo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

* Dimi Paun:

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

You should use the ip4r type for that.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Stosberg 2008-04-07 19:50:19 per-review of PgBouncer / Slony design
Previous Message Oleg Bartunov 2008-04-07 18:47:58 Re: what worked: performance improvements for geo-spatial searching on FreeBSD