Skip site navigation (1) Skip section navigation (2)

Re: WAL Optimisation - configuration and usage

From: Richard Huxton <dev(at)archonet(dot)com>
To: Rob Fielding <rob(at)dsvr(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: WAL Optimisation - configuration and usage
Date: 2004-02-28 19:37:26
Message-ID: 200402281937.26428.dev@archonet.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-pitrpgsql-performance
Rob

Sir - I have to congratulate you on having the most coherently summarised and 
yet complex list query I have ever seen. 

I fear that I will be learning from this problem rather than helping, but one 
thing did puzzle me - you've set your random_page_cost to 0.5? I'm not sure 
this is sensible - you may be compensating for some other parameter 
out-of-range.


-- 
  Richard Huxton

In response to

pgsql-performance by date

Next:From: Rod TaylorDate: 2004-02-29 00:52:52
Subject: Re: WAL Optimisation - configuration and usage
Previous:From: Rob FieldingDate: 2004-02-28 18:40:12
Subject: WAL Optimisation - configuration and usage

pgsql-hackers by date

Next:From: Richard HuxtonDate: 2004-02-28 19:39:04
Subject: Re: How to get Relation name from Oid ??
Previous:From: Ramanujam H S IyengarDate: 2004-02-28 18:47:27
Subject: How to get Relation name from Oid ??

pgsql-hackers-pitr by date

Next:From: Rod TaylorDate: 2004-02-29 00:52:52
Subject: Re: WAL Optimisation - configuration and usage
Previous:From: Rob FieldingDate: 2004-02-28 18:40:12
Subject: WAL Optimisation - configuration and usage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group