Re: [HACKERS] v6.1 buffers and performance - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] v6.1 buffers and performance
Date
Msg-id de789f1b743976158e14023e26a20468
Whole thread Raw
In response to [HACKERS] v6.1 buffers and performance  ("Thomas G. Lockhart" <Thomas.Lockhart@jpl.nasa.gov>)
List pgsql-hackers
I upgraded my Linux box to have 96MB of memory, up from 32MB ($250, who
would have believed _that_ a few years ago).

There is a significant difference in Postgres performance, with the
regression tests taking ~5:15 to complete vs. ~6:20 before the upgrade
for a 17% speed improvement. There is little or no evidence for gross
degradation of performance with repeated runs of the regression test, as
I had reported earlier. So, the conclusion is that more memory is better
(duh!) and that as the buffer gets filled or fragmented smaller memory
machines start swapping.

            - Tom

------------------------------

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: [HACKERS] TODO list
Next
From: Igor
Date:
Subject: Re: [HACKERS] v6.1 buffers and performance