Re: [COMMITTERS] pgsql: Update autovacuum to use reloptions instead of a system catalog, - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [COMMITTERS] pgsql: Update autovacuum to use reloptions instead of a system catalog,
Date
Msg-id 20090210184618.GJ3708@alvh.no-ip.org
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Update autovacuum to use reloptions instead of a system catalog,  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: Re: [COMMITTERS] pgsql: Update autovacuum to use reloptions instead of a system catalog,
List pgsql-hackers
ITAGAKI Takahiro wrote:

> 2. psql's \d+ doesn't show toast storage parameters.
>
> Neither \d+ for base tables nor toast relations show toast.* parameters
> though there are some values in pg_class.reloptions.
> I think we should show toast.* parameters in \d+ for base tables
> because it has consistency; we set them at ALTER TABLE for base tables.

This patch seems to fix this problem.

Note that it introduces a LEFT JOIN on pg_class to itself that's always
present, even for server versions that do not support reloptions.  I'm
not sure that this is a problem; I can't measure any difference on \d
with and without the patch on a test database with 1000 tables.

Attachment

pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: advance local xmin more aggressively
Next
From: Dimitri Fontaine
Date:
Subject: Re: Optimization rules for semi and anti joins