Reviewed: max. no of relations in a database - Mailing list pgsql-general

From Ralph Graulich
Subject Reviewed: max. no of relations in a database
Date
Msg-id Pine.LNX.4.21.0208030148210.1995-100000@shauny.shauny.de
Whole thread Raw
Responses Re: Reviewed: max. no of relations in a database  (Richard Huxton <dev@archonet.com>)
List 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 ...



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: b1 OR b2 <-> ( CASE WHEN b1 THE true ELSE b2 END ): performance bottleneck on logical OR
Next
From: "Johnson, Shaunn"
Date:
Subject: saving a view with pg_dump