[GENERAL] Trying to get postgres to use an index

Hi, I'm using PostgreSQL 8. I have two tables that I am doing a join on, and the join executes very slowly. The table called Notification has a text field called NotificationID, which is its primary key. The Notification table also has an int4 field called ItemID, and it has an index on the It

Re: [GENERAL] Trying to get postgres to use an index

I have some more info on my indexing situation, and a new question. In my previous email, I told about 2 tables: Notification and Item, which join on a field called ItemID. The joining query didn't execute as quickly as I thought it should. I now notice that I have another table, Folder, which jo

[GENERAL] help with correlated delete and outer join

I'm using postgresl 7.3.2 and have a query that executes very slowly. There are 2 tables: Item and LogEvent. ItemID (an int4) is the primary key of Item, and is also a field in LogEvent. Some ItemIDs in LogEvent do not correspond to ItemIDs in Item, and periodically we need to purge the non-mat