From: Mario Weilguni <mweilguni@sime.com>
To: pgsql-performance@postgresql.org
Cc: PostgreSQL <martin@portant.com>
Subject: Re: 8.1 iss
Date: Tue, 8 Nov 2005 11:34:19 +0100
Message-ID: <200511081134.19495.mweilguni@sime.com> (raw)
In-Reply-To: <dko2ge$2cnd$1@news.hub.org>
References: <dkko49$1v06$1@news.hub.org>
<dko2ge$2cnd$1@news.hub.org>
Am Montag, 7. November 2005 18:22 schrieb PostgreSQL:
> My most humble apologies to the pg development team (pg_lets?).
>
> I took Greg Stark's advice and set:
>
> shared_buffers = 10000 # was 50000
> work_mem = 1048576 # 1Gb - was 16384
>
> Also, I noticed that the EXPLAIN ANALYZE consistently thought reads would
> take longer than they actually did, so I decreased random_page_cost down to
> 1 (the server has a SATA Raid at level 10).
Don't do that, use 1.5 or 2, setting it to 1 will only work well if you have
small databases fitting completly in memory.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mweilguni@sime.com, martin@portant.com
Subject: Re: 8.1 iss
In-Reply-To: <200511081134.19495.mweilguni@sime.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox