Re: Remove size limitations of vacuums dead_tuples array - Mailing list pgsql-hackers

From Ants Aasma
Subject Re: Remove size limitations of vacuums dead_tuples array
Date
Msg-id CANwKhkMK9YxZJo_NKBLyXgPcoB_5Fqmf3M=ev8jU19=UEHhtVw@mail.gmail.com
Whole thread Raw
In response to Re: Remove size limitations of vacuums dead_tuples array  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: Remove size limitations of vacuums dead_tuples array
List pgsql-hackers
On Thu, 10 Oct 2019 at 17:05, Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote:
There already was a attempt to make this improvement, see [1]. There was
a fairly long discussion about how to best do that (using other data
structure, not just a simple array). It kinda died about a year ago, but
I suppose there's a lot of relevant info in that thread.

[1] https://www.postgresql.org/message-id/CAGTBQpbDCaR6vv9%3DscXzuT8fSbckf%3Da3NgZdWFWZbdVugVht6Q%40mail.gmail.com

Thanks for the pointer, wow that's a long thread. For some reason it did not consider lifting the INT_MAX tuples/12GB limitation. I'll see if I can pick up where that thread left off and push it along.

Regards,
Ants Aasma


pgsql-hackers by date:

Previous
From: Dave Cramer
Date:
Subject: Re: let's make the list of reportable GUCs configurable (was Re: Add%r substitution for psql prompts to show recovery status)
Next
From: Konstantin Knizhnik
Date:
Subject: Re: [Proposal] Global temporary tables