On 09/02/2013 02:26 PM, Andres Freund wrote:
On 2013-09-02 14:20:57 -0400, Andrew Dunstan wrote:
On 09/02/2013 01:30 PM, Tom Lane wrote:
Andrew Dunstan writes:
Yes, possibly, but we can't do that now, but I would like to fix the
docs now.
If you want this in 9.3.0 it needs to be committed i
On 2013-09-02 14:20:57 -0400, Andrew Dunstan wrote:
>
> On 09/02/2013 01:30 PM, Tom Lane wrote:
> >Andrew Dunstan writes:
> >>Yes, possibly, but we can't do that now, but I would like to fix the
> >>docs now.
> >If you want this in 9.3.0 it needs to be committed in the next couple of
> >hours.
>
On 09/02/2013 01:30 PM, Tom Lane wrote:
Andrew Dunstan writes:
Yes, possibly, but we can't do that now, but I would like to fix the
docs now.
If you want this in 9.3.0 it needs to be committed in the next couple of
hours.
FWIW, the idea seemed generally sane to me, but I'd suggest not depend
Andrew Dunstan writes:
> Yes, possibly, but we can't do that now, but I would like to fix the
> docs now.
If you want this in 9.3.0 it needs to be committed in the next couple of
hours.
FWIW, the idea seemed generally sane to me, but I'd suggest not depending
on reltoastrelid being zero when an
On 09/01/2013 10:33 PM, Josh Berkus wrote:
Maybe for bonus points we'd print out the schema (e.g. by selectting
c.oid::regclass instead of c.relname), and also include materialized
views which are omitted from the query altogether.
Given the importance of this, maybe we need to have it as part
> Maybe for bonus points we'd print out the schema (e.g. by selectting
> c.oid::regclass instead of c.relname), and also include materialized
> views which are omitted from the query altogether.
Given the importance of this, maybe we need to have it as part of
pg_stat_user_tables?
--
Josh Berk
The other day I followed the docs and ran this query:
SELECT relname, age(relfrozenxid) FROM pg_class WHERE relkind = 'r';
Then after identifying some tables that were close to triggering an
automatic vacuum, we vacuumed them only to find that the age of the
database's datfrozenxid hadn't
