pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAfter adjusting checkpoint related entries in postgresql.conf...
5+ messages / 3 participants
[nested] [flat]
* After adjusting checkpoint related entries in postgresql.conf...
@ 2007-08-21 00:00 Tena Sakai <tsakai@gallo.ucsf.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Tena Sakai @ 2007-08-21 00:00 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: After adjusting checkpoint related entries in postgresql.conf...
@ 2007-08-21 00:16 Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>
0 siblings, 1 reply; 5+ messages in thread
From: Farhan Mughal @ 2007-08-21 00:16 UTC (permalink / raw)
To: Tena Sakai <tsakai@gallo.ucsf.edu>; pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: After adjusting checkpoint related entries in postgresql.conf...
@ 2007-08-21 03:14 Tena Sakai <tsakai@gallo.ucsf.edu>
parent: Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>
0 siblings, 1 reply; 5+ messages in thread
From: Tena Sakai @ 2007-08-21 03:14 UTC (permalink / raw)
To: Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>; pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: After adjusting checkpoint related entries in postgresql.conf...
@ 2007-08-21 04:12 Tom Lane <tgl@sss.pgh.pa.us>
parent: Tena Sakai <tsakai@gallo.ucsf.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2007-08-21 04:12 UTC (permalink / raw)
To: Tena Sakai <tsakai@gallo.ucsf.edu>; +Cc: Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>; pgsql-admin
"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> Does checkpoint not happen if there is no activity?
That's correct.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: After adjusting checkpoint related entries in postgresql.conf...
@ 2007-08-21 15:48 Tena Sakai <tsakai@gallo.ucsf.edu>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Tena Sakai @ 2007-08-21 15:48 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>; pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-08-21 15:48 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-21 00:00 After adjusting checkpoint related entries in postgresql.conf... Tena Sakai <tsakai@gallo.ucsf.edu>
2007-08-21 00:16 Re: After adjusting checkpoint related entries in postgresql.conf... Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>
2007-08-21 03:14 ` Tena Sakai <tsakai@gallo.ucsf.edu>
2007-08-21 04:12 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-08-21 15:48 ` Tena Sakai <tsakai@gallo.ucsf.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox