Horton
Menu

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

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Alvaro Herrera <alvherre@commandprompt.com>
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-12T21:13:33Z
Lists: pgsql-hackers 
Alvaro Herrera wrote:
> 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?

True, but if I messed up the SQL somehow, no one is testing it.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073