| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Hans-Jürgen Schönig <postgres(at)cybertec(dot)at> |
| Cc: | Koichi Suzuki <koichi(at)intellilink(dot)co(dot)jp>, pgsql-patches(at)postgresql(dot)org, Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>, ikubo(at)intellilink(dot)co(dot)jp, yasunaga <yasunaga(dot)hisato(at)soft(dot)fujitsu(dot)com>, Bruce Momjian <root(at)candle(dot)pha(dot)pa(dot)us>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, sakata(dot)tetsuo(at)lab(dot)ntt(dot)co(dot)jp, "T(dot)Honishi" <honishi(dot)takashi(at)lab(dot)ntt(dot)co(dot)jp> |
| Subject: | Re: A couple of patches for PostgreSQL 64bit support |
| Date: | 2005-07-07 16:35:36 |
| Message-ID: | 16399.1120754136@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres(at)cybertec(dot)at> writes:
> There is some practical evidence. Recently the number of large boxes in
> the field is almost growing exponentially. Today I have heard somebody
> say "this box has 'just 4 gig of ram' ".
> On large installations we have already seen problems with too small
> caches (= 2gb).
> Surprisingly this has turned out to be a quite important issue in the
> field. Tests have shown that the cache provided by the OS is a lot worse
> for the database.
*What* tests? This is all handwaving :-(
What I would find credible is a set of, say, OSDL test runs, showing a
continuing increase of performance with shared_buffers right up to the
2Gb limit. Everything done to date says that you hit the point of
diminishing returns well before that.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2005-07-07 16:40:51 | Must be owner to truncate? |
| Previous Message | Hans-Jürgen Schönig | 2005-07-07 16:23:40 | Re: A couple of patches for PostgreSQL 64bit support |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-07-07 16:43:26 | Re: Dependencies on shared objects |
| Previous Message | Hans-Jürgen Schönig | 2005-07-07 16:23:40 | Re: A couple of patches for PostgreSQL 64bit support |