Re: SQL or table design optimation

From: Verena Ruff <verena(dot)ruff(at)triosolutions(dot)at>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL or table design optimation
Date: 2006-05-30 15:53:52
Message-ID: 447C6A90.1070205@triosolutions.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2006-05-30 16:25:30 Re: SQL or table design optimation
Previous Message Sean Davis 2006-05-30 15:35:53 Re: SQL or table design optimation