Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 30 May 2006 17:53:52 +0200
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:
Vacuum analyze was done quite before doing that testing. I'll send the explain output later, thanks so long.There are indexes on person(pers_id), contact(id), contact(pers_id) and one on contact(kind, type).
Regards, Verena
- Prev by Date: Re: SQL or table design optimation
- Next by Date: Re: SQL or table design optimation
- Previous by thread: Re: SQL or table design optimation
- Next by thread: Some Slony questions
- Indexes: