Iain wrote:
sort_mem 4096 (=400MB RAM for 100 connections)
If I understand correctly, memory usage related to `sort_mem'
is per connection *and* per sort.
If every client runs a query with 3 sorts in its plan, you are
going to need (in theory) 100 connections * 4Mb * 3 sorts,
which is 1.2 Gb.
Pleas
Ho Cosimo,
I had read that before, so you are right. The amount of memory being used
could run much higher than I wrote.
In my case, I know that not all the connections are not busy all the time
(this isn't a web application with thousands of users connecting to a pool)
so not all active connec
From: "Amrit Angsusingh" <[EMAIL PROTECTED]>
To: "Iain" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, December 28, 2004 1:48 AM
Subject: Re: [PERFORM] Howto Increased performace ?
Hi,
These are some settings that I am planning to start with for a 4GB RAM
dual
optero
Hi,
These are the /etc/sysctl.conf settings that I am planning to use.
Coincidentally, these are the settings recommended by Oracle. If anything
they would be generous, I think.
file-max 65536 (for 2.2 and 2.4 kernels)
kernel.shmall 134217728 (=128MB)
kernel.shmmax 268435456
fs.file-max 65536
By
On Mon, 2004-12-27 at 22:31 +0700, Amrit Angsusingh wrote:
> [ [EMAIL PROTECTED] ]
> >
> > These are some settings that I am planning to start with for a 4GB RAM
> > dual
> > opteron system with a maximum of 100 connections:
> >
> >
> > shared_buffers 8192 (=67MB RAM)
> > sort_mem 4096 (=400MB RAM
D]>
To: "Iain" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, December 27, 2004 6:21 PM
Subject: Re: [PERFORM] Howto Increased performace ?
#sort_mem = 1024 # min 64, size in KB
sort_mem = 6
I think this might be too much. You are using 6KB _per connection_
here
= 10GB for you
Hi,
#sort_mem = 1024 # min 64, size in KB
sort_mem = 6
I think this might be too much. You are using 6KB _per connection_ here
= 10GB for your maximum of 180 connections.
By comparison, I am specifiying 4096 (subject to adjustment) for a machine
with a similar spec to yours.
regards
Iai
On Tue, 2004-12-21 at 16:31 +0700, Amrit Angsusingh wrote:
> I used postgresql 7.3.2-1 with RH 9 on a mechine of 2 Xeon 3.0 Ghz and ram
> of 4 Gb. Since 1 1/2 yr. when I started to use the database server after
> optimizing the postgresql.conf everything went fine until a couple of
> weeks ago , my