I haven't tested with the new 7.2 betas, but here are some results from
We have a developement computer, IBM x series 250, with 4 processors
(PIII Xeon 750Mhz), 1 Gb memory and 2SCSI disks (u160).
The software is writing new rows to a table, and after this it reads the
id from that row. There are currently about 50 connections doing the
When I run this test with the Redhat 7.1 SMP kernel, I noticed, that the
processors are more than 90% idle. Disks utilisation is not the
bottleneck either, since there is very low disk usage. Some data is
written to disks every 4-5 seconds. Fsync is turned of. In transactions,
this means about 200 inserted rows per second. The software that is used
to give the feed, is capable of several thousand rows per second.
Okey, so I tried this also with the same computer, but using the not SMP
supported kernel. So only with one processor. The result was about 600
rows per second. The configuration file was unchanged. Now, the
processor is about 100% utilized.
I didn't find any parameters that should help in this, but if you have a
version of 7.2 that you would like to get information about, let me
know, so I'll test.
pgsql-hackers by date
|Next:||From: Lincoln Yeoh||Date: 2001-12-18 11:02:02|
|Subject: Re: Connection Pooling, a year later|
|Previous:||From: Jayaraj Oorath||Date: 2001-12-18 10:38:15|
|Subject: Scheduling Jobs in Postgres|