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 th
Moran
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]>
"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 r
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 q
"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 nothin
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 mi
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 a
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
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 th
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
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
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 configura
12 matches
Mail list logo
