R: [PERFORM] R: DELETE queries slow down

EMAIL PROTECTED] Inviato: martedì 18 settembre 2007 18.19 A: Galantucci Giovanni Cc: pgsql-performance@postgresql.org Oggetto: Re: [PERFORM] R: DELETE queries slow down In response to "Galantucci Giovanni" <[EMAIL PROTECTED]>: > I perform simple INSERT and simple where-

[PERFORM] R: DELETE queries slow down

for our help Gianluca Galantucci -Messaggio originale- Da: Gregory Stark [mailto:[EMAIL PROTECTED] Inviato: lunedì 17 settembre 2007 12.22 A: Heikki Linnakangas Cc: Galantucci Giovanni; pgsql-performance@postgresql.org Oggetto: Re: DELETE queries slow down "Heikki Linnakangas&quo

[PERFORM] DELETE queries slow down

Hi all, I have a problem with DELETE performance with postgres 7.4. I have a database with 2 great tables (about 150,000 rows) continuously updated, with 1000 - 1200 INSERT per second and 2 or 3 huge DELETE per minute, in which we delete almost all the rows inserted in the 2 tables during the pre