| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Why not represent "never vacuumed" accurately wrt pg_class.relpages? |
| Date: | 2018-12-12 04:12:02 |
| Message-ID: | CA+Tgmob+wB_89foHmjg5d4AUb3W=isq+MUGXaL5RsSpJQuo87g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Dec 11, 2018 at 11:47 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Andres Freund <andres(at)anarazel(dot)de> writes:
> > I don't quite get why we don't instead just represent "never vacuumed"
> > by storing a more meaningful value in relpages?
>
> Mostly, not wanting to break clients that look at these fields.
> If catalog compatibility weren't a concern, I'd seriously consider
> replacing both of them with a float "average tuples per page" ratio.
I think we should do exactly that thing.
And I also agree that assuming 10 pages when pg_class says 0 and 1
page when pg_class says 1 is not particularly bright.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Steele | 2018-12-12 04:13:18 | Re: Add timeline to partial WAL segments |
| Previous Message | David Steele | 2018-12-12 04:09:19 | Re: Remove Deprecated Exclusive Backup Mode |