"Heikki Linnakangas" <[EMAIL PROTECTED]> writes:
> Galantucci Giovanni wrote:
>
>> For 1 or 2 hours we update only one table, and everything goes ok, where
>> DELETE last at most 6 or 7 seconds.
>>
>> Then for a minute we do INSERT on both table, and everything continue
>> going ok, with DELETE t
Galantucci Giovanni wrote:
> I have a problem with DELETE performance with postgres 7.4.
You should consider upgrading. While I don't recall any particular
enhancements that would directly help with this problem, 8.2 is
generally faster.
> I have a database with 2 great tables (about 150,000 rows
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
