Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Stephan SzaboDate: 2006-05-30 16:25:30
Subject: Re: SQL or table design optimation
Previous:From: Sean DavisDate: 2006-05-30 15:35:53
Subject: Re: SQL or table design optimation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group