Re: Analyze makes queries slow... - Mailing list pgsql-sql

From Jonathan Gardner
Subject Re: Analyze makes queries slow...
Date
Msg-id 200308080924.50218.jgardner@jonathangardner.net
Whole thread Raw
In response to Analyze makes queries slow...  (Stef <svb@ucs.co.za>)
Responses Re: Analyze makes queries slow...  (Stef <svb@ucs.co.za>)
List 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 by date:

Previous
From: Jonathan Gardner
Date:
Subject: Re: converting interval to timestamp
Next
From: Jonathan Gardner
Date:
Subject: Re: RI_ConstraintTrigger_11264756