Re: R: I: Migrating a very large db

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: samuele(dot)brignoli(at)darpha(dot)com
Cc: "PostgreSQL General List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: R: I: Migrating a very large db
Date: 2002-04-16 13:06:36
Message-ID: 11381.1018962396@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Samuele Brignoli" <samuele(dot)brignoli(at)darpha(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Miia Leino 2002-04-16 13:08:35 ON DELETE CASCADE doesn't work
Previous Message Tino Wildenhain 2002-04-16 12:58:41 Re: Triggers and System Tables