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
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
No, it is one transaction per insert.
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 08, 2007 5:38 PM
To: Orhan Aglagul
Subject: RE: [PERFORM]
On Tue, 2007-05-08 at 19:36, Orhan Aglagul wrote:
> But 10,000 records in 65 sec comes to ~153 reco
-Original Message-
From: Orhan Aglagul
Sent: Tuesday, May 08, 2007 5:37 PM
To: 'Scott Marlowe'
Subject: RE: [PERFORM]
But 10,000 records in 65 sec comes to ~153 records per second. On a dual
3.06 Xeon
What range is acceptable?
-Original Message-
From: Scott Marlo
To: Orhan Aglagul
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM]
On Tue, 2007-05-08 at 17:59, Orhan Aglagul wrote:
> Hi Everybody,
>
> I was trying to see how many inserts per seconds my application could
> handle on various machines.
>
> Those are the machines I
Forgot to reply to the mailing list. Sorry (new here)
Here are responses to previous questions
-Original Message-
From: Orhan Aglagul
Sent: Tuesday, May 08, 2007 5:30 PM
To: 'Joshua D. Drake'
Subject: RE: [PERFORM]
I am using a prepared statement and inserting in a l
Hi Everybody,
I was trying to see how many inserts per seconds my application could
handle on various machines.
Those are the machines I used to run my app:
1) Pentium M 1.7Ghz
2) Pentium 4 2.4 Ghz
3) DMP Xeon 3Ghz
Sure, I was expecting the dual Zeon to outperform the