Overhead of tables. - Mailing list pgsql-general

From Soma Interesting
Subject Overhead of tables.
Date
Msg-id 5.0.0.25.0.20001205183005.00c0aea0@pop.telus.net
Whole thread Raw
In response to Re: Virus spread using pgsql mailling list :-?  (thomas wong <twong@aamsin.com>)
Responses Re: Overhead of tables.  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@telus.net


pgsql-general by date:

Previous
From: thomas wong
Date:
Subject: Re: Virus spread using pgsql mailling list :-?
Next
From: ashley
Date:
Subject: MacIntosh