Re: [HACKERS] slow information schema with thausand users, seq.scan

Alvaro Herrera <alvherre@commandprompt.com>

From: Alvaro Herrera <alvherre@commandprompt.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, andrew@supernews.com, Peter Eisentraut <peter_e@gmx.net>, PostgreSQL-patches <pgsql-patches@postgresql.org>
Date: 2006-02-12T20:31:36Z
Lists: pgsql-hackers
Bruce Momjian wrote:
> 
> I have remove the LEFT part of the join to pg_roles in
> psql/description.c.  I assume this is too risky for 8.1.X.

Well, 8.1 already has per-role dependencies, so why not do it?


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support