Re: WAL Optimisation - configuration and usage - Mailing list pgsql-performance

From Rod Taylor
Subject Re: WAL Optimisation - configuration and usage
Date
Msg-id 1078015971.24316.9.camel@jester
Whole thread Raw
In response to WAL Optimisation - configuration and usage  (Rob Fielding <rob@dsvr.net>)
Responses Re: WAL Optimisation - configuration and usage  (Rob Fielding <rob@dsvr.net>)
List pgsql-performance
> random_page_cost = 0.5

Not likely. The lowest this value should ever be is 1, and thats if
you're using something like a ram drive.

If you're drives are doing a ton of extra random IO due to the above
(rather than sequential reads) it would lower the throughput quite a
bit.

Try a value of 2 for a while.



pgsql-performance by date:

Previous
From: Mark Gibson
Date:
Subject: Re: [HACKERS] Materialized View Summary
Next
From: Rob Fielding
Date:
Subject: Re: WAL Optimisation - configuration and usage