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
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 6: expla
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
"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
Moran
Sent: Thursday, April 12, 2007 4:14 PM
To: Sorin N. Ciolofan
Cc: 'Shoaib Mir'; [EMAIL PROTECTED]; pgsql-admin@postgresql.org;
'Dimitris Kotzinos'
Subject: Re: [GENERAL] [ADMIN] Increasing the shared memory
In response to "Sorin N. Ciolofan" <[EMAIL PROTECTED]>
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