From: | Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com> |
---|---|
To: | depesz(at)depesz(dot)com |
Cc: | Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Why so many xlogs? |
Date: | 2010-11-01 19:18:24 |
Message-ID: | AANLkTi=2GeHD8nAVzwBR-UiWb7re8v+-pqDga0BGzjwS@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2010/11/1 hubert depesz lubaczewski <depesz(at)depesz(dot)com>:
> On Mon, Nov 01, 2010 at 07:18:22PM +0100, Filip Rembiałkowski wrote:
>> 2010/11/1 hubert depesz lubaczewski <depesz(at)depesz(dot)com>:
>>
>> > as I understand, max number of xlog files in pg_xlog should be ( 1 + 2 *
>> > checkpoint_segments ).
>>
>> why?
>>
>> for a server overloaded with R/W transactions, it's possible to go beyond this.
>> checkpoints just do not keep up.
>> right now I have an 8.3 with checkpoint_segments=3, constantly running
>> pgbench and I see 8 WAL segments.
>
> you will notice in the logs that the system doesn't look like very
> loaded.
> i mean - there is fair amount of work, but nothing even resembling
> "overloaded".
There exists some checkpoint which occur more frequently than perhaps
expected. (less than 15 minutes)...
The logline about checkpoint might be usefull. Still I wonder what
your question is exactly ?
>
> Best regards,
>
> depesz
>
> --
> Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
> jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Cédric Villemain 2ndQuadrant
http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2010-11-01 19:19:15 | Re: 8.4 Data Not Compatible with 9.0.1 Upgrade? |
Previous Message | Cédric Villemain | 2010-11-01 19:13:49 | Re: Why so many xlogs? |