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