Re: No toast table for pg_shseclabel but for pg_seclabel

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp>, PgHacker <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: No toast table for pg_shseclabel but for pg_seclabel
Date: 2015-03-22 02:15:07
Message-ID: 20150322021507.GG10795@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 19, 2015 at 11:50:36AM -0400, Bruce Momjian wrote:
> > Then there's the other discussion about using the security labels
> > structure for more than just security labels, which could end up with a
> > lot of other use-cases where the "label" is even larger.
>
> OK, the attached patch adds a TOAST table to the shared table
> pg_shseclabel for use with long labels. The new query output shows the
> shared and non-shared seclabel tables now both have TOAST tables:
>
> test=> SELECT oid::regclass, reltoastrelid FROM pg_class WHERE relname IN ('pg_seclabel', 'pg_shseclabel');
> oid | reltoastrelid
> ---------------+---------------
> pg_seclabel | 3598
> pg_shseclabel | 4060
> (2 rows)
>
> Previously pg_shseclabel was zero.

Patch applied.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2015-03-22 02:21:34 Re: Lets delete src/test/performance
Previous Message Bruce Momjian 2015-03-22 02:06:39 Re: [PATCH] PostgreSQL 9.4 mmap(2) performance regression on FreeBSD...