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