Reviewed: max. no of relations in a database

From: Ralph Graulich <maillist(at)shauny(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Reviewed: max. no of relations in a database
Date: 2002-08-02 23:52:07
Message-ID: Pine.LNX.4.21.0208030148210.1995-100000@shauny.shauny.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi again,

a couple of days ago we had the dicussion about my problem concerning the
maximum number of relations in a database and the naming problems of
relations disappearing. I wanted to provide a testcase, but to no
avail.

The problem only occures with loads of data (just inserting dummy data to
the tables didn't show the problem!). Second, the problem only occures if
there are lots of long relation names. As I changed all the relation names
to shorter and less descriptive ones, the problem magically disappeared.

However, I will keep an eye on that kind of problem and maybe I have a
testcase in the future, if the problem reoccures.

Thanks for all the helpful hints, not to forget!

Kind regards
... Ralph ...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Johnson, Shaunn 2002-08-02 23:59:36 saving a view with pg_dump
Previous Message Tom Lane 2002-08-02 23:40:41 Re: b1 OR b2 <-> ( CASE WHEN b1 THE true ELSE b2 END ): performance bottleneck on logical OR