Re: Overhead of tables. - Mailing list pgsql-general

From Tom Lane
Subject Re: Overhead of tables.
Date
Msg-id 5972.976078117@sss.pgh.pa.us
Whole thread Raw
In response to Overhead of tables.  (Soma Interesting <dfunct@telus.net>)
List pgsql-general
Soma Interesting <dfunct@telus.net> writes:
> I'd like to get an idea of the overhead introduced by large quantity of
> tables being hosted off a single PostgreSQL server. It is possible I'll be
> wanting to host upwards of 200-500 tables per server. Essentially, will I
> be surprised to find out that performance in PostgreSQL (or DBMS in
> general) is significantly hindered by sheer quantity of tables?

When you get to tens of thousands of tables per server, we might start
to worry a little... 500 is in the "what me worry?" class.

            regards, tom lane

pgsql-general by date:

Previous
From: ashley
Date:
Subject: Clarification
Next
From: Tom Lane
Date:
Subject: Re: Many postmasters...