Re: [PERFORM] Slow Bulk Delete

On 05/08/2010 06:39 AM, thilo wrote: Hi all! We moved from MySQL to Postgresql for some of our projects. So far we're very impressed with the performance (especially INSERTs and UPDATEs), except for a strange problem with the following bulk delete query: DELETE FROM table1 WHERE table2_id = ?

[PERFORM] Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this?

I have a message posted in pgsql-general that outlines what I thought was an indexing problem - it's not, so I'm bringing it here. I dumped the table from our production system and stuffed it into a test machine, then started refining and playing with the query until I was able to get it to the "d

Re: [PERFORM] Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this?

Overal comment.. Try reading hrough these old threads most of your problem is the same issue: http://article.gmane.org/gmane.comp.db.postgresql.performance/22395/match=gin http://thread.gmane.org/gmane.comp.db.postgresql.performance/22331/focus=22434 Tabl