Sent: Thursday, April 12, 2007 4:14 PM
To: Sorin N. Ciolofan
Cc: 'Shoaib Mir'; pgsql-general@postgresql.org; [EMAIL PROTECTED];
'Dimitris Kotzinos'
Subject: Re: [GENERAL] [ADMIN] Increasing the shared memory
In response to Sorin N. Ciolofan [EMAIL PROTECTED]:
I've tried first
In response to Sorin N. Ciolofan [EMAIL PROTECTED]:
Dear all,
Thanks for your advices. I'd like to ask you where can I download the
pg_buffercache add-on and also where can I find some documentation about how
can I install it?
It's part of the contrib directory that ships with the source
I will simplify the things in order to describe when the error occurred:
The input of the application is some data which is read from files on disk,
processed and then inserted in the database in one transaction. This total
quantity of data represents an integer number of data files, n*q, where
Sorin N. Ciolofan [EMAIL PROTECTED] writes:
I will simplify the things in order to describe when the error occurred:
The input of the application is some data which is read from files on disk,
processed and then inserted in the database in one transaction. This total
quantity of data
Hello!
I've tried first to increase the number of shared buffers, I
doubled it, from 1000 to 2000 (16Mb)
Unfortunately this had no effect.
Then I increased the number of max_locks_per_transaction
from 64 to 128 (these shoul
In response to Sorin N. Ciolofan [EMAIL PROTECTED]:
I've tried first to increase the number of shared buffers, I
doubled it, from 1000 to 2000 (16Mb)
Unfortunately this had no effect.
The difference between 8M and and 16M of shared buffers is pretty minor.
Sorin N. Ciolofan [EMAIL PROTECTED] writes:
This had also no effect. Because I can't see any difference
between the maximum input accepted for our application with the old
configuration and the maximum input accepted now, with the new
configuration. It looks like nothing
I guess shared_buffers (in postgresql.conf file) will help you here if you
have properly setup your kernel.SHMMAX value.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 4/2/07, Sorin N. Ciolofan [EMAIL PROTECTED] wrote:
Hello!
I'd like to ask you if there is any Postgre
Thanks,
I've a value of 1000 set for shared_buffers, does this means
that I use 8kbX1000=8Mb of Shared Mem?
The definition from the manual is quite confusing:
shared_buffers (integer)
Sets the amount of memory the database server uses for shared
An extract from -- http://www.powerpostgresql.com/PerfList/ might help
you
shared_buffers:
As a reminder: This figure is NOT the total memory PostgreSQL has to work
with. It is the block of dedicated memory PostgreSQL uses for active
operations, and should be a minority of your total RAM on
In response to Sorin N. Ciolofan [EMAIL PROTECTED]:
I've a value of 1000 set for shared_buffers, does this means
that I use 8kbX1000=8Mb of Shared Mem?
The definition from the manual is quite confusing:
shared_buffers (integer)
Sets the amount of
There is also a add on in contrib (pg_buffercache) that can be used to
give an indication of the number of buffers in use, this can be used to
help find a 'good' shared mem size for your configuration.
David.
---(end of broadcast)---
TIP 4: Have
12 matches
Mail list logo