From: Jonathan Gardner <jgardner@jonathangardner.net>
To: Stef <svb@ucs.co.za>
To: Postgres SQL List <pgsql-sql@postgresql.org>
Subject: Re: Analyze makes queries slow...
Date: Fri, 8 Aug 2003 09:24:48 -0700
Message-ID: <200308080924.50218.jgardner@jonathangardner.net> (raw)
In-Reply-To: <20030806171855.6c9ebf4d.svb@ucs.co.za>
References: <20030806171855.6c9ebf4d.svb@ucs.co.za>
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jgardner@jonathangardner.net, svb@ucs.co.za
Subject: Re: Analyze makes queries slow...
In-Reply-To: <200308080924.50218.jgardner@jonathangardner.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox