| From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, Venkata Balaji N <nag1010(at)gmail(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Redesigning checkpoint_segments |
| Date: | 2015-02-05 14:53:24 |
| Message-ID: | 54D383E4.1070604@vmware.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 02/05/2015 04:47 PM, Andres Freund wrote:
> On 2015-02-05 09:42:37 -0500, Robert Haas wrote:
>> I previously proposed 100 segments, or 1.6GB. If that seems too
>> large, how about 64 segments, or 1.024GB? I think there will be few
>> people who can't tolerate a gigabyte of xlog under peak load, and an
>> awful lot who will benefit from it.
>
> It'd be quite easier to go there if we'd shrink back to the min_size
> after a while, after having peaked above it. IIUC the patch doesn't do
> that?
It doesn't actively go and remove files once they've already been
recycled, but if the system stays relatively idle for several
checkpoints, the WAL usage will shrink down again. That's the core idea
of the patch.
If the system stays completely or almost completely idle, that won't
happen though, because then it will never switch to a new segment so
none of the segments become old so that they could be removed.
- Heikki
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2015-02-05 14:57:34 | Re: GRANT USAGE on FOREIGN SERVER exposes passwords |
| Previous Message | Andres Freund | 2015-02-05 14:47:18 | Re: Redesigning checkpoint_segments |