Re: [PERFORM] Drop table vs Delete record

2007-05-22 Thread Orhan Aglagul
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

[PERFORM] Drop table vs Delete record

2007-05-22 Thread Orhan Aglagul
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

FW: [PERFORM]

2007-05-08 Thread Orhan Aglagul
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

FW: [PERFORM]

2007-05-08 Thread Orhan Aglagul
-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

FW: [PERFORM]

2007-05-08 Thread Orhan Aglagul
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

Re: [PERFORM]

2007-05-08 Thread Orhan Aglagul
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

[PERFORM]

2007-05-08 Thread Orhan Aglagul
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