Overhead of tables.

From: Soma Interesting <dfunct(at)telus(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Overhead of tables.
Date: 2000-12-06 02:39:06
Message-ID: 5.0.0.25.0.20001205183005.00c0aea0@pop.telus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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? The tables
are small, with few rows and few columns. The queries are simple selects,
updates, inserts and deletes.

Appreciate any feedback on this, thanks.

- - - - - - -
- - - - -
WARNING: Some experts believe that use of any keyboard may cause serious
injury.
Consult Users Guide.
dfunct(at)telus(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sandeep Joshi 2000-12-06 03:13:11 PostgreSql and XA
Previous Message ashley 2000-12-06 02:12:33 MacIntosh