Re: [HACKERS] When did we get to be so fast?

2003-08-14 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I was just testing the threaded ecpg, and ran some performance tests. Without using threads, I am seeing 100,000 inserts of a single word into a simple table take 12 seconds: CREATE TABLE test_thread(message TEXT); giving me

Re: [HACKERS] When did we get to be so fast?

2003-08-14 Thread Shridhar Daithankar
On 7 Aug 2003 at 19:54, Bruce Momjian wrote: Man, I can't do anything right; should be: one INSERT per transaction, fsync true 934 one INSERT per transaction, fsync false 1818 INSERTs all in one transaction, fsync true 4166 Just curiousity, what will

Re: [HACKERS] When did we get to be so fast?

2003-08-14 Thread Bruce Momjian
The Hermit Hacker wrote: On Thu, 7 Aug 2003, Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I was just testing the threaded ecpg, and ran some performance tests. Without using threads, I am seeing 100,000 inserts of a single word into a simple

Re: [HACKERS] When did we get to be so fast?

2003-08-14 Thread The Hermit Hacker
On Thu, 7 Aug 2003, Bruce Momjian wrote: Man, I can't do anything right; should be: one INSERT per transaction, fsync true 934 one INSERT per transaction, fsync false 1818 INSERTs all in one transaction, fsync true 4166 Brain thinking one thing,

Re: [HACKERS] When did we get to be so fast?

2003-08-08 Thread The Hermit Hacker
On Thu, 7 Aug 2003, Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I was just testing the threaded ecpg, and ran some performance tests. Without using threads, I am seeing 100,000 inserts of a single word into a simple table take 12 seconds: CREATE

[HACKERS] When did we get to be so fast?

2003-08-07 Thread Bruce Momjian
I was just testing the threaded ecpg, and ran some performance tests. Without using threads, I am seeing 100,000 inserts of a single word into a simple table take 12 seconds: CREATE TABLE test_thread(message TEXT); giving me 8333 inserts per second. That seems very high. I remember

Re: [HACKERS] When did we get to be so fast?

2003-08-07 Thread P.J. \Josh\ Rovero
Bruce Momjian wrote: I was just testing the threaded ecpg, and ran some performance tests. Without using threads, I am seeing 100,000 inserts of a single word into a simple table take 12 seconds: CREATE TABLE test_thread(message TEXT); giving me 8333 inserts per second. That seems very high.

Re: [HACKERS] When did we get to be so fast?

2003-08-07 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: I was just testing the threaded ecpg, and ran some performance tests. Without using threads, I am seeing 100,000 inserts of a single word into a simple table take 12 seconds: CREATE TABLE test_thread(message TEXT); giving me 8333 inserts per