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.
>
>
>
>
>
