large object thx & vacuuming question

Поиск
Список
Период
Сортировка
От Risko Peter
Тема large object thx & vacuuming question
Дата
Msg-id Pine.LNX.4.21.0204270200370.906-100000@pepehost.ike
обсуждение исходный текст
Список pgsql-general
Hello,

  Thank you Tom for the fast answer about lo ids!

  *  *  *

  On an other server we use Postgres7.1. Everything is fine (:-), but I
have a question:
  We have a dozen tables, and ~40000 los (300MegBytes) in a db. When I
run vacuum verbose in this db, I experience that when vacuum reaches the
pg_largeobjects table, it starts eating up disk space, and never
(can't wait?) finishes. Is it sensible vacuuming pg_largeobjects? All
our other tables can be vacuumed in a few seconds time.
  Sorry for my terrible english, I hope you can understand it...

  thanks: Peter RISKO




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

Предыдущее
От: "Yuri A. Kabaenkov"
Дата:
Сообщение: boolean and count
Следующее
От: Fran Fabrizio
Дата:
Сообщение: Re: What popular, large commercial websites run PostgreSQL?