Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: psql show dbsize?

  • From: Andrew Dunstan <andrew(at)dunslane(dot)net>
  • To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • Cc: andy <andy(at)squeakycode(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
  • Subject: Re: psql show dbsize?
  • Date: Wed, 31 Oct 2007 19:07:56 -0400
  • Message-id: <47290ACC.4020704@dunslane.net> <text/plain>


Tom Lane wrote:

andy <andy(at)squeakycode(dot)net> writes:

I know its way too late in the game, sorry, but it's a very small patch...


(1) What's the performance impact?  I should think that this makes \l orders
of magnitude slower.

(2) Doesn't this render \l entirely nonfunctional for users who don't
have CONNECT privilege to all DBs in the installation?
Perhaps both these considerations dictate providing another command or a special flavor of \l instead of just modifying it? 

cheers

andrew
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group