Re: Load distributed checkpoint

From: "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
To: "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, "ITAGAKI Takahiro" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Load distributed checkpoint
Date: 2006-12-21 14:04:13
Message-ID: E1539E0ED7043848906A8FF995BDA57901A34E50@m0143.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


> > You were running the test on the very memory-depend machine.
> >> shared_buffers = 4GB / The scaling factor is 50, 800MB of data.
> > Thet would be why the patch did not work. I tested it with DBT-2,
10GB of
> > data and 2GB of memory. Storage is always the main part of
performace here,
> > even not in checkpoints.
>
> Yes, I used half the size of RAM as the shared buffers, which is
> reasonable. And I cached all the data.

For pg, half RAM for shared_buffers is too much. The ratio is good for
other db software, that does not use the OS cache.

Andreas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2006-12-21 14:08:00 Re: Tuning single row operations
Previous Message D'Arcy J.M. Cain 2006-12-21 13:39:19 Re: New version of money type

Browse pgsql-patches by date

  From Date Subject
Next Message Zeugswetter Andreas ADI SD 2006-12-21 14:39:07 Re: column ordering, was Re: [PATCHES] Enums patch v2
Previous Message Takayuki Tsunakawa 2006-12-21 10:29:13 Re: Load distributed checkpoint