Re: PostgreSQL Reliability when fsync = false on - Mailing list pgsql-performance

From Hannu Krosing
Subject Re: PostgreSQL Reliability when fsync = false on
Date
Msg-id 1062658526.6270.5.camel@fuji.krosing.net
Whole thread Raw
In response to Re: PostgreSQL Reliability when fsync = false on Linux-XFS  (Rod Taylor <rbt@rbt.ca>)
List pgsql-performance
Rod Taylor kirjutas N, 04.09.2003 kell 06:36:
> Another alternative is
> to buy a small 15krpm disk dedicated for WAL. In theory you can achieve
> one commit per rotation.

One commit per rotation would still be only 15000/60. = 250 tps, but
fortunately you can get better results if you use multiple concurrent
backends, then in the best case you can get one commit per backend per
rotation.

-----------------
Hannu


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: SELECT's take a long time compared to other DBMS
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: PostgreSQL Reliability when fsync = false on Linux-XFS