Hi List and Chris,
On 11/10/06, Chris Browne <cbbrowne@acm.org> wrote:
> The defaults for various interesting things were...
> max_connections = 100
> shared_buffers = 32MB
> max_fsm_pages = 204800
>
> The default work_mem was 1MB, which is arguably low, on a machine with
> 15GB of RAM :-).
>
> But frankly, I don't see any particular problem with the defaults.
> 32MB is *not* an over-tiny amount of shared memory; it's enough to be
> meaningful for more than merely a trivial workload.
"trivial", that's the point. there are people who are loading huge
tables into postgresql the same way they do into mysql. and then they
compare some queries. and then go back to mysql.
i think we need a make tune command which can configure at least up to
50% of the machine's physical hardware.
just my thoughts,
regards,
usleep