Re: [GENERAL] Indexes in PostgreSQL

2005-04-19 Thread jackfitz
Yes. Thanks. I ran VACUUM ANALYZE and got the same results... -Jack ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] Indexes in PostgreSQL

2005-04-18 Thread jackfitz
I was wondering if anyone could explain how to get the Query Analyzer to use an Index that is defined for the table instead of doing a table scan? I have a table with some indexes on it that seem NOT to get used when I think they should. :-) Not that I KNOW more than the Query Analyzer - but a Tab