Hi,
with that setup you should vacuum aggressivley.
I'd send a vacuum statement in a third thread every 15 minutes or so.
The table renaming trick doesn't sound very handy or even
necessary...
Bye,
Chris.
> Date: Tue, 22 May 2007 14:38:40 -0400
> From: "Orhan Aglagul" <[EMAIL PROTECTED]>
> T
Checking out right now
Thanks for the fast response.
-Original Message-
From: Andreas Kostyrka [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 22, 2007 11:49 AM
To: Orhan Aglagul
Cc:
Subject: AW: [PERFORM] Drop table vs Delete record
Consider table partitioning (it's described i
Consider table partitioning (it's described in the manual).
Andreas
-- Ursprüngl. Mitteil. --
Betreff:[PERFORM] Drop table vs Delete record
Von:"Orhan Aglagul" <[EMAIL PROTECTED]>
Datum: 22.05.2007 18:42
My application has two threads, one inserts thou
My application has two threads, one inserts thousands of records per second
into a table (t1) and the other thread periodically deletes expired records
(also in thousands) from the same table (expired ones). So, we have one thread
adding a row while the other thread is trying to delete a ro
