Re: An idle thought - Mailing list pgsql-hackers

From Tom Lane
Subject Re: An idle thought
Date
Msg-id 26222.1268860800@sss.pgh.pa.us
Whole thread Raw
In response to Re: An idle thought  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: An idle thought
Re: An idle thought
List pgsql-hackers
Jeff Davis <pgsql@j-davis.com> writes:
> There are all kinds of challenges there, but it might be worth thinking
> about. Visibility information is highly compressible, and requires
> constant maintenance (updates, deletes, freezing, etc.). It also might
> make it possible to move to 64-bit xids, if we wanted to.

If you want it to be cheaply updatable (or even cheaply readable),
compression is not what you're going to do.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Order of pg_stat_activity timestamp columns
Next
From: Bruce Momjian
Date:
Subject: Re: Order of pg_stat_activity timestamp columns