On 06/07/12 16:15, Sylvain CAILLET wrote:
Hi to all,
I run Postgresql 8.3.9 on a dedicated server running with Debian 5.0.4,
a strong bi quad-proc with RAM 16Go. My biggest db contains at least 100
000 tables.
That is a *lot* of tables and it's probably going to be slow whatever
you do.
Last time, I started a Java process I use to make some
change on it, it created 170 new tables and it took one full minute.
What are you using all these tables for? I'm assuming most of them have
identical structure.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
