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

Re: Buffer Cache question....

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Buffer Cache question....
Date: 2003-04-30 20:47:05
Message-ID: 200304302047.h3UKl5j01004@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Medi Montaseri wrote:
> I am using PG 7.2 with fsync truned on but still need a more immediate 
> write thru.
> Does PG uses the fsync (or open_sync, etc) just for the WAL or for 
> tables as well ?

Just for WAL.

> I understand the consequence of limiting buffer cache but my application 
> cares more about
> integrity than performance. I'd like to be able to write the data to the 
> physical storage ASAP,
> or ideally 100% in sync mode.
> 
> I have found that by reducing the checkpoint parameters I can write the 
> data to disk sooner.
> For example
> 
> checkpoint_segments = 1
> checkpoint_timeout = 30
> 
> What else do I have to work with....?

PostgreSQL is already 100% reliable (pull plug and see) so I don't see
any value to changing those parameters.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073


In response to

Responses

pgsql-general by date

Next:From: Ron MayerDate: 2003-04-30 20:50:03
Subject: Re: dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline"
Previous:From: Erik RonströmDate: 2003-04-30 20:33:48
Subject: check_foreign_key

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