Re: [idea] a copied relkind in pg_attribute

From: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
To: "KaiGai Kohei" <kaigai(at)kaigai(dot)gr(dot)jp>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [idea] a copied relkind in pg_attribute
Date: 2008-12-24 16:12:33
Message-ID: 3073cc9b0812240812ta5e44fu9d62ee5b4fb835ac@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Dec 24, 2008 at 6:50 AM, KaiGai Kohei <kaigai(at)kaigai(dot)gr(dot)jp> wrote:
>
> The current implementation need to lookup RELOID system cache to
> identify the relkind of the relation, because pg_attribtue does
> not have any information about "relkind". However, I also think
> it is not an ideal implementation, even if its frequency is enough
> small.
>

but you still can do it, right?
there are any other advantages, like something you can't do now?
if not, i think you need to probe that there will be any benefit in
speed and that is significant otherwise this seems like premature
optimization and that AFAIR is the root of all evil :)

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-12-24 16:16:33 Re: generic reloptions improvement
Previous Message Simon Riggs 2008-12-24 15:45:52 Re: Hot standby and b-tree killed items