| From: | Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Too frequent checkpoints ? |
| Date: | 2013-02-09 05:28:09 |
| Message-ID: | 3D2DE5E4-3CBB-4AFD-9114-2D04F57C8A25@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>
>
>> Also, the log says "checkpoints are occurring too frequently (0
>> seconds apart)". But that looks wrong too. Checkpoints are really
>> happening at 30 seconds apart and not 0 as the log message claims.
>
> I noticed that as well, and I think it might be a regression. I'll
> run a bisection on it if I get a chance.
>
Looking further into it, seems there are two checkpoints happening almost immediately. The first happens because of timeout and the second happens immediately because of checkpoint segments (set to 1 in this case)
Given that no one has bothered to fix these issues, may be they are non issues after all.
Thanks,
Pavan
> Cheers,
>
> Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Farina | 2013-02-09 06:55:40 | Re: Considering Gerrit for CFs |
| Previous Message | Peter Eisentraut | 2013-02-09 05:24:00 | pgsql: psql: Improve expanded print output in tuples-only mode |