Changing the buffer size
I want to change the buffer size of pgsql server, other than default size.
How can I do that.
#############################################
# Monu Agrawal #
# Indian Institute of Science #
# Bangalore #
# E-25 #
# 91-80-2932432 #
#############################################
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.
HTH
Bye
Shridhar
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
Show quoted text
HTH
Bye
Shridhar---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
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@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073