Re: [PERFORM] Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

complaining that they´ve lost all their data. Even the firmware upgrade didn´t completely resolved the issues. Regards Thilo -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] Slow Bulk Delete

(very odd behavior). Thanks anyway for your help! Kind regards Thilo > I am going to guess the slow part is sending 1M different queries back and > forth from client to server.  You could try batching them together: > > DELETE FROM table1 WHERE table2_id in (11242939, 1,2,3,4,5, 4

[PERFORM] Slow Bulk Delete

solve the problem. It drives me crazy ;-) If you need more details please feel free to ask! Thanks in advance for your help! Kind regards Thilo -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mail