Re: HELP speed up my Postgres

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

To: jerome@xxxxxxxxx
Subject: Re: HELP speed up my Postgres
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Thu, 25 Nov 2004 01:55:25 -0500
Cc: "Vishal Kashyap @ [SaiHertz]" <vishalonlist@xxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx, pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to JM <jerome@xxxxxxxxx> message dated "Thu, 25 Nov 2004 14:29:48 +0800"
In-reply-to: <200411251429.48440.jerome@xxxxxxxxx>
References: <200411251400.32752.jerome@xxxxxxxxx> <77b69d2104112422126218b407@xxxxxxxxxxxxxx> <200411251429.48440.jerome@xxxxxxxxx>

JM <jerome@xxxxxxxxx> writes:
> PG Version 7.3.4

Avoid the "IN (subselect)" construct then.  7.4 is the first release
that can optimize that in any real sense.

			regards, tom lane

References:
- HELP speed up my Postgres
  - From: JM
- Re: HELP speed up my Postgres
  - From: Vishal Kashyap @ [SaiHertz]
- Re: HELP speed up my Postgres
  - From: JM

Prev by Date: Re: HELP speed up my Postgres
Next by Date: Re: HELP speed up my Postgres
Previous by thread: Re: HELP speed up my Postgres
Next by thread: Re: HELP speed up my Postgres
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux