| 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
| 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 |
| 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 |