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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
