| From: | Himanshu Baweja <himanshubaweja(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: how to calculate checkpoint_segments |
| Date: | 2005-05-12 13:29:07 |
| Message-ID: | 20050512132907.39554.qmail@web51002.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
i think there is a bug in the checkpoint warning system.....
i had set =>
checkpoint_timeout = 2000
checkpoint_warning = 2100
checkpoint_segments = 256 (for 1st run) and 64 (for 2nd run)
now i ran my test application.... my Wal-logs in PGDATA/pg_xlog increased by around 1.9 GB while in my log file there were only two warnings.... so i re-run the test application this time turned the archive on... the archive logs generated were also of around 2 GB..... but this time i had just one warning in my log file.....
now theoritically it should give me a warning each-time a checkpoint occurs.... but i am getting just one....
am i missing something or there is a problem....
....... and is there any other way by which i can check how frequently my database is checkpointing....
Regards
Himanshu
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Himanshu Baweja | 2005-05-12 14:16:54 | Re: how to calculate checkpoint_segments |
| Previous Message | Peter Schmelzer | 2005-05-12 11:13:56 | Re: Tsearch2 lexeme position |