On 16/01/2004, at 2:44 AM, Tom Lane wrote:
...
As noted elsewhere, it's highly likely that this has nothing to do with
the OS, and everything to do with write caching in the disks being
used.
I assume you are benchmarking small individual transactions (one insert
per xact). In such scenarios it'
Syd <[EMAIL PROTECTED]> writes:
> However, with postgres 7.4 on Mac OSX 10.2.3, we're getting an amazing
> 500 inserts per second.
> We can only put this down to the OS.
As noted elsewhere, it's highly likely that this has nothing to do with
the OS, and everything to do with write caching in the
> On a variety of hardware with Redhat, and versions of postgres, we're
> not getting much better than 50 inserts per second. This is prior to
> moving WAL to another disk, and fsync is on.
>
> However, with postgres 7.4 on Mac OSX 10.2.3, we're getting an amazing
> 500 inserts per second.
>
> We c
I've read most of the threads on insert speed in this list and wanted
to share some interesting observations and a question.
We've been benchmarking some dbs to implement Bayesian processing on an
email server. This involves frequent insert and updates to the
following table:
create table baye
