Re: Changing the buffer size

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Thierry Missimilly <THIERRY(dot)MISSIMILLY(at)BULL(dot)NET>
Cc: Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>, monu agrawal <monu_india(at)rediffmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Changing the buffer size
Date: 2003-11-07 15:18:28
Message-ID: 200311071518.hA7FISf03061@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thierry Missimilly wrote:
>
>
> Shridhar Daithankar wrote:
>
> > monu agrawal wrote:
> >
> > > I want to change the buffer size of pgsql server, other than default size.
> > > How can I do that.
> >
> > You need to edit postgresql.conf in the data directory.
>
> And restart Postgres after modification by : pg_ctl reload

He needs pg_ctl restart, rather than reload because reload doesn't
restart the server and that param is only honored on postmaster startup.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-11-07 15:22:42 Re: int8 primary keys still not using index without manual
Previous Message Tino Wildenhain 2003-11-07 15:11:33 Re: int8 primary keys still not using index without manual