Re: R: I: Migrating a very large db

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: R: I: Migrating a very large db
Дата
Msg-id 11381.1018962396@sss.pgh.pa.us
обсуждение исходный текст
Ответ на R: I: Migrating a very large db  ("Samuele Brignoli" <samuele.brignoli@darpha.com>)
Ответы explain and explain analyze with functions  (elein <elein@nextbus.com>)
Список pgsql-general
"Samuele Brignoli" <samuele.brignoli@darpha.com> writes:
> Anyway my db is, I think, very large. I have 700 tables, and someone of
> those are larger than 10000 records.

Hmm.  The number of records per table is not relevant here.  The number
of tables doesn't seem that large either.  We've heard one or two
reports of this error message from people who were trying to dump
databases containing thousands of "large objects", back in the days when
each large object was a separate table and so had its own lock.  But I'm
surprised to hear of it at 700 tables.  Would you be willing to send me
a schema dump (pg_dump -s, no data) of your database for testing?

            regards, tom lane

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

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: Triggers and System Tables
Следующее
От: Moritz Sinn
Дата:
Сообщение: Re: function for creating random id