Re: Improve Postgres Query Speed

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: carter ck <carterck32(at)hotmail(dot)com>
Cc: chad(dot)wagner(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Improve Postgres Query Speed
Date: 2007-01-16 01:19:10
Message-ID: 20070116011910.GH24671@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jorge Godoy 2007-01-16 01:19:13 Re: Improve Postgres Query Speed
Previous Message Jorge Godoy 2007-01-16 01:15:41 Re: Transaction callback