Re: Analyze makes queries slow...

Поиск
Список
Период
Сортировка
От Jonathan Gardner
Тема Re: Analyze makes queries slow...
Дата
Msg-id 200308080924.50218.jgardner@jonathangardner.net
обсуждение исходный текст
Ответ на Analyze makes queries slow...  (Stef <svb@ucs.co.za>)
Ответы Re: Analyze makes queries slow...
Список pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 06 August 2003 08:18, Stef wrote:
>
> Can anybody help, or give some links to good
> help resources?
>

Try the performance list.

Attach the create statements used to create the tables, the query you are
running, and the different explain plans that were generated. If you know
what it is, you may also want to attach the relevant statistics from the
pg_stats table. They will be most helpful.

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

iD8DBQE/M87QWgwF3QvpWNwRAgMfAJ9c6O9EyVbJYiguv/b2wtf/NsLZfACgq3lW
YjpMSEMZ4gfyGaGoJcOjpSo=
=4/hA
-----END PGP SIGNATURE-----


В списке pgsql-sql по дате отправления:

Предыдущее
От: Jonathan Gardner
Дата:
Сообщение: Re: converting interval to timestamp
Следующее
От: Jonathan Gardner
Дата:
Сообщение: Re: RI_ConstraintTrigger_11264756