Postgres Pro
Downloads
Home   >   mailing lists

Re: Improve Postgres Query Speed - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Improve Postgres Query Speed
Date
Msg-id 20070116011910.GH24671@alvh.no-ip.org
Whole thread Raw
In response to Re: Improve Postgres Query Speed  ("carter ck" <carterck32@hotmail.com>)
List pgsql-general
Tree view 
carter ck wrote:
>
> Hi,
>
> Thanks for reminding me. And the actual number of records is 100,000.
>
> The table is as following:

And the query?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: Transaction callback
Next
From: Jorge Godoy
Date:
Subject: Re: Improve Postgres Query Speed