Обсуждение: After adjusting checkpoint related entries in postgresql.conf...

Поиск
Список
Период
Сортировка

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

От
"Tena Sakai"
Дата:

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

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

От
Farhan Mughal
Дата:

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...

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



Yahoo! Answers - Get better answers from someone who knows. Try it now.

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

От
"Tena Sakai"
Дата:

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

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

От
Tom Lane
Дата:
"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> Does checkpoint not happen if there is no activity?

That's correct.

            regards, tom lane

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

От
"Tena Sakai"
Дата:

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