Re: [PERFORM] HELP speed up my Postgres

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jerome(at)gmanmi(dot)tv
Cc: "Vishal Kashyap (at) [SaiHertz]" <vishalonlist(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [PERFORM] HELP speed up my Postgres
Date: 2004-11-25 06:55:25
Message-ID: 25493.1101365725@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

JM <jerome(at)gmanmi(dot)tv> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-11-25 07:06:27 Re: [PERFORM] HELP speed up my Postgres
Previous Message ElayaRaja S 2004-11-25 06:41:08 Help!

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-11-25 07:06:27 Re: [PERFORM] HELP speed up my Postgres
Previous Message Iain 2004-11-25 06:40:57 Re: [PERFORM] HELP speed up my Postgres