Forum OpenACS Development: Re: Postgres and index usage

Collapse
3: Re: Postgres and index usage (response to 2)
Posted by Malte Sussdorff on 10/15/03 05:08 PM
Well, I dropped the index that i created and issued the same explain command again, and suddenly it didn't say "seq scan on parties" anymore. Really strange. Well, apparently the fault was on my side, so sorry for posting this. Though I still don't get it....
Collapse
4: Re: Postgres and index usage (response to 3)
Posted by Claudio Pasolini on 10/15/03 09:24 PM
I have two (almost) identical servers running the same query: the first uses the index while the second scans sequentially one of the (big) joined tables.

I dropped and recreated the second db from a pg_dump of the first getting the same results.

Fortunately the first is the production server and so, after some unsuccesfull investigation, I decided to forget the problem.