Re: SQL or table design optimation - Mailing list pgsql-novice

From Verena Ruff
Subject Re: SQL or table design optimation
Date
Msg-id 447C6A90.1070205@triosolutions.at
Whole thread Raw
In response to SQL or table design optimation  (Verena Ruff <lists@triosolutions.at>)
List pgsql-novice
Hi,

Sean Davis schrieb:
> You might also tell us what columns are indexed and be sure that you have
> done a vacuum analyze recently on the tables.
>
About indexed columns:

>>> There are indexes on
>>> person(pers_id), contact(id), contact(pers_id) and one on contact(kind,
>>> type).
>>>
Vacuum analyze was done quite before doing that testing. I'll send the
explain output later, thanks so long.

Regards,
Verena

pgsql-novice by date:

Previous
From: Donald Brady
Date:
Subject: trigger help
Next
From: Terry Lee Tucker
Date:
Subject: Re: trigger help