Re: [PERFORM] Query is not using index when it should

2004-12-12 Thread Josh Berkus
Tomas, > I tried to subscribe to pgsql-performance, but there seems to be > something wrong with the majordomo, so I'm sending to general too, > where I'm already subscribed. Well, I got your e-mail, so obviously you're subscribed to Performance. > But when doing a search with objectid, class an

[PERFORM] Query is not using index when it should

2004-12-12 Thread Tomas Skäre
I tried to subscribe to pgsql-performance, but there seems to be something wrong with the majordomo, so I'm sending to general too, where I'm already subscribed. My problem is this, using PostgreSQL 7.4.6: I have a table that looks like this: Table "public.cjm_object" Column |