| From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | alemon(at)tiago(dot)hazor(dot)com(dot)br |
| Cc: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: slow database |
| Date: | 2004-02-12 01:27:44 |
| Message-ID: | 402AD690.9020106@paradise.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
>
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2004-02-12 02:01:49 | Re: select count(*) from anIntColumn where int_value = |
| Previous Message | Tom Lane | 2004-02-11 23:24:41 | Re: coercing int to bigint for indexing purposes |