Re: Overhead of tables.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Soma Interesting <dfunct(at)telus(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Overhead of tables.
Date: 2000-12-06 04:48:37
Message-ID: 5972.976078117@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Soma Interesting <dfunct(at)telus(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-12-06 05:04:09 Re: Many postmasters...
Previous Message Mikheev, Vadim 2000-12-06 04:24:50 RE: How to reset WAL enveironment