pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.
>
>
>
>  
>




view thread (16+ messages)

Message-ID: <402AD690.9020106@paradise.net.nz>
Permalink:  ../402AD690.9020106@paradise.net.nz/
Also on:    postgresql.org/message-id/402AD690.9020106@paradise.net.nz

 · 

reply

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