Re: How to speeed up the query performance

Поиск
Список
Период
Сортировка
От Jonathan Gardner
Тема Re: How to speeed up the query performance
Дата
Msg-id 200308130750.42570.jgardner@jonathangardner.net
обсуждение исходный текст
Ответ на How to speeed up the query performance  (Abdul Wahab Dahalan <wahab@mimos.my>)
Список 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 по дате отправления:

Предыдущее
От: Christoph Haller
Дата:
Сообщение: Re: How to speeed up the query performance
Следующее
От: Jonathan Gardner
Дата:
Сообщение: Re: Order of triggers - totally lost