A reload should be enough. Are you facing any problems?

--Farhan

----- Original Message ----
From: Tena Sakai <tsakai@gallo.ucsf.edu>
To: pgsql-admin@postgresql.org
Sent: Tuesday, 21 August, 2007 5:00:21 AM
Subject: [ADMIN] After adjusting checkpoint related entries in postgresql.conf...

After adjusting checkpoint related entries in postgresql.conf...








Hi everybody,



After adjustingcheckpoint related entries in postgresql.conf

file, is it sufficient to issue:

pg_ctl reload

Or am I supposed to do more than that?



Thank you in advance.



Tena Sakai

tsakai@gallo.ucsf.edu









__________________________________________________ _________
Want ideas for reducing your carbon footprint? Visit Yahoo! For Good http://uk.promotions.yahoo.com/forgood/environment.html

Hi Farhan,

> Are you facing any problems?

Yes, the files in data/pg_xlog directory hasn't been
updated. Here's the setting as far as checkpint
entries are concerned:

checkpoint_segments = 3
checkpoint_timeout = 5min
checkpoint_warning = 30s

Does checkpoint not happen if there is no activity?
The last entry I see in the serverlog file is:

2007-08-20 16:47:51.152 PDT] < >LOG: received SIGHUP, reloading configuration files

Thank you.

Tena

-----Original Message-----
From: Farhan Mughal [mailto:farhanhafeezmughal@yahoo.co.uk]
Sent: Mon 8/20/2007 5:16 PM
To: Tena Sakai; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] After adjusting checkpoint related entries in postgresql.conf...


A reload should be enough. Are you facing any problems?

--Farhan

----- Original Message ----
From: Tena Sakai <tsakai@gallo.ucsf.edu>
To: pgsql-admin@postgresql.org
Sent: Tuesday, 21 August, 2007 5:00:21 AM
Subject: [ADMIN] After adjusting checkpoint related entries in postgresql.conf...

After adjusting checkpoint related entries in postgresql.conf...








Hi everybody,



After adjusting checkpoint related entries in postgresql.conf

file, is it sufficient to issue:

pg_ctl reload

Or am I supposed to do more than that?



Thank you in advance.



Tena Sakai

tsakai@gallo.ucsf.edu









__________________________________________________ _________
Want ideas for reducing your carbon footprint? Visit Yahoo! For Good http://uk.promotions.yahoo.com/forgood/environment.html

"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> Does checkpoint not happen if there is no activity?

That's correct.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Many thanks, Tom.

Tena
tsakai@gallo.ucsf.edu


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Mon 8/20/2007 9:12 PM
To: Tena Sakai
Cc: Farhan Mughal; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] After adjusting checkpoint related entries in postgresql.conf...

"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> Does checkpoint not happen if there is no activity?

That's correct.

regards, tom lane