Re: SQL or table design optimation
This is a discussion on Re: SQL or table design optimation within the pgsql Novice forums, part of the PostgreSQL category; --> Hi, Sean Davis schrieb: > You might also tell us what columns are indexed and be sure that you ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 10:54 PM
| ||||
| ||||
 Re: SQL or table design optimation 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend      |
Linear Mode
