Re: How to speeed up the query performance - Mailing list pgsql-sql

From Jonathan Gardner
Subject Re: How to speeed up the query performance
Date
Msg-id 200308130750.42570.jgardner@jonathangardner.net
Whole thread Raw
In response to How to speeed up the query performance  (Abdul Wahab Dahalan <wahab@mimos.my>)
List pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tuesday 12 August 2003 20:20, Abdul Wahab Dahalan wrote:
> How do I speed up the quey performance if I've a query like this :
> Does 'not in' command will affected the performance?.
>

Yes. Severely. See the responses to the "How to optimize this query ?"
thread.

If you want more details, check the pgsql-performance archives.

- --
Jonathan Gardner <jgardner@jonathangardner.net>
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/OlBBWgwF3QvpWNwRAuzJAJ99iMmMbU/tiJhi077+8WCmAId76ACffL+5
biOZSLPbuhWZBL6MNlZE3V0=
=Sg0n
-----END PGP SIGNATURE-----


pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: How to speeed up the query performance
Next
From: Jonathan Gardner
Date:
Subject: Re: Order of triggers - totally lost