Re: Tablespace patch review

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Tablespace patch review
Дата
Msg-id 200406200055.i5K0tv718934@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Tablespace patch review  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список pgsql-patches
Andreas Pflug wrote:
> Bruce Momjian wrote:
>
> >
> >
> >I don't see why an admin tool can't connect to each database and get a
> >listing of what is in each tablespace.  I don't think connecting to 100
> >databases to get that information will be slow.
> >
> >
> >
> Well, whatever you call slow or not slow.
> I checked it; connecting 10 databases, retrieving tablespace
> dependencies (pg_class union pg_schema) and closing takes about one
> second over an ssl connection, 0.2 seconds with non-ssl. This was a
> trusted connection, can't check what will happen with md5, krb or so.

Well, we could use something like dbsize to report how much disk space
is used by each database in the tablespace (it does an 'ls' in the
directory as a server-side function), and connect to the database to get
actual table names.

I can't think of any clean system that would allow access to the table
names in other databases without connecting to them.

--
  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

В списке pgsql-patches по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Tablespace patch review
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: eventlog fix