| From: | Jonathan Gardner <jgardner(at)jonathangardner(dot)net> |
|---|---|
| To: | Abdul Wahab Dahalan <wahab(at)mimos(dot)my>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: How to speeed up the query performance |
| Date: | 2003-08-13 14:50:41 |
| Message-ID: | 200308130750.42570.jgardner@jonathangardner.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)jonathangardner(dot)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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Gardner | 2003-08-13 14:54:30 | Re: Order of triggers - totally lost |
| Previous Message | Christoph Haller | 2003-08-13 14:50:03 | Re: How to speeed up the query performance |