| From: | Tomas Vondra <tomas(at)vondra(dot)me> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com>, Melanie Plageman <melanieplageman(at)gmail(dot)com> |
| Cc: | Peter Geoghegan <pg(at)bowt(dot)ie>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Maybe we should reduce SKIP_PAGES_THRESHOLD a bit? |
| Date: | 2024-12-17 18:50:54 |
| Message-ID: | 984d7c68-a664-435d-add4-8b45495e2dcd@vondra.me |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 12/17/24 18:52, Robert Haas wrote:
> On Tue, Dec 17, 2024 at 12:06 PM Melanie Plageman
> <melanieplageman(at)gmail(dot)com> wrote:
>> I think your tests show SKIP_PAGES_THRESHOLD has dubious if any
>> benefit related to readahead. But the question is if we care about it
>> for advancing relfrozenxid for small tables.
Yeah, although I'm a bit hesitant to draw such clear conclusion from one
set of benchmarks on one machine (or two, but both with flash). I would
not be surprised if the results were less clear on other types of
storage (say, something like EBS).
>
> It seems like relfrozenxid advancement is really only a problem for
> big tables. If the table is small, the eventual aggressive vacuum
> doesn't cost that much.
>
Yeah, I agree with this.
regards
--
Tomas Vondra
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2024-12-17 18:59:14 | Re: Adding NetBSD and OpenBSD to Postgres CI |
| Previous Message | Tomas Vondra | 2024-12-17 18:46:39 | Re: Maybe we should reduce SKIP_PAGES_THRESHOLD a bit? |