From: Michael Riess <mlriess@gmx.de>
To: pgsql-performance@postgresql.org
Subject: Re: 15,000 tables - next step
Date: Sat, 03 Dec 2005 17:41:42 +0100
Message-ID: <dmshs4$2blb$1@news.hub.org> (raw)
In-Reply-To: <20051203162642.GA29022@surnet.cl>
References: <dmqjou$2a10$1@news.hub.org>
<4391BF0F.9000208@Yahoo.com>
<dmsgke$24so$1@news.hub.org>
<20051203162642.GA29022@surnet.cl>
Alvaro Herrera schrieb:
> Michael Riess wrote:
>
>> Shared memory ... I currently use 1500 buffers for 50 connections, and
>> performance really suffered when I used 3000 buffers. The problem is
>> that it is a 1GB machine, and Apache + Tomcat need about 400MB.
>
> Well, I'd think that's were your problem is. Not only you have a
> (relatively speaking) small server -- you also share it with other
> very-memory-hungry services! That's not a situation I'd like to be in.
> Try putting Apache and Tomcat elsewhere, and leave the bulk of the 1GB
> to Postgres.
No can do. I can try to switch to a 2GB machine, but I will not use
several machines. Not for a 5GB database. ;-)
> With 1500 shared buffers you are not really going
> anywhere -- you should have ten times that at the very least.
>
Like I said - I tried to double the buffers and the performance did not
improve in the least. And I also tried this on a 2GB machine, and
swapping was not a problem. If I used 10x more buffers, I would in
essence remove the OS buffers.
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: mlriess@gmx.de
Subject: Re: 15,000 tables - next step
In-Reply-To: <dmshs4$2blb$1@news.hub.org>
* 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