Search Postgresql Archives

Re: Improve Postgres Query Speed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: carter ck <carterck32@xxxxxxxxxxx>
Subject: Re: Improve Postgres Query Speed
From: Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>
Date: Mon, 15 Jan 2007 22:19:10 -0300
Cc: chad.wagner@xxxxxxxxx, pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <BAY101-F24AC888471255FA46BF547D5B40@xxxxxxx>
Mail-followup-to: carter ck <carterck32@xxxxxxxxxxx>, chad.wagner@xxxxxxxxx, pgsql-general@xxxxxxxxxxxxxx
References: <81961ff50701151654s2eed1548wfbd8097dbf01a424@xxxxxxxxxxxxxx> <BAY101-F24AC888471255FA46BF547D5B40@xxxxxxx>
User-agent: Mutt/1.5.13 (2006-08-11)

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Re: Improve Postgres Query Speed
  - From: Chad Wagner
- Re: Improve Postgres Query Speed
  - From: carter ck

Prev by Date: Re: Transaction callback
Next by Date: Re: Improve Postgres Query Speed
Previous by thread: Re: Improve Postgres Query Speed
Next by thread: Re: Improve Postgres Query Speed
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux