From: Mark Kirkwood <markir@paradise.net.nz>
To: alemon@tiago.hazor.com.br
Cc: scott.marlowe <scott.marlowe@ihs.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: slow database
Date: Thu, 12 Feb 2004 14:27:44 +1300
Message-ID: <402AD690.9020106@paradise.net.nz> (raw)
In-Reply-To: <Pine.LNX.4.33.0402111140290.794-100000@css120.ihs.com>
References: <Pine.LNX.4.33.0402111140290.794-100000@css120.ihs.com>
If things are still slow after you have checked your keys as indicated,
then pick one query and post the output from EXPLAIN ANALYZE for the
list to examine.
oh - and ensure you are *not* still using your original postgresql.conf :-)
best wishes
Mark
scott.marlowe wrote:
>First thing I would check is to make sure all those foreign keys are the
>same type.
>
>Second, make sure you've got indexes to go with them. I.e. on a multi-key
>fk, have a multi-key index.
>
>
>
>
>
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-performance@postgresql.org
Cc: markir@paradise.net.nz, alemon@tiago.hazor.com.br, scott.marlowe@ihs.com, tgl@sss.pgh.pa.us
Subject: Re: slow database
In-Reply-To: <402AD690.9020106@paradise.net.nz>
* 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