Hi,
I have already done so ;-)
Also looking over the postgresql.conf file, I have changed the
checkpoint_segments to 128. From what i understood of the of the PerfList
page, this should not effect performance (only use up HD space), and the
write performance of the database is OK with this setti
Then you should set it to 100 or so. It helps to keep the number of
connections down to something reasonable.
On Wed, May 21, 2008 at 12:06 AM, Andy Dale <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I currently have max_connections set to 300, however if i think about it we
> will never have that many co
Hi,
I currently have max_connections set to 300, however if i think about it we
will never have that many connections (more like 50 - 100 at most).
Cheers,
Andy
2008/5/20 Scott Marlowe <[EMAIL PROTECTED]>:
> On Tue, May 20, 2008 at 8:14 AM, Andy Dale <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> >
On Tue, May 20, 2008 at 8:14 AM, Andy Dale <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am currently trying to tweak Postgresql 8.1, to improve the overall
> performance of the database. I have read over the following page/artical
> http://www.powerpostgresql.com/PerfList/, however at the moment (not fo
Hi,
I am currently trying to tweak Postgresql 8.1, to improve the overall
performance of the database. I have read over the following page/artical
http://www.powerpostgresql.com/PerfList/, however at the moment (not for
much longer hopefully) my hands aree tied when it comes to altering the
kerne
