Thread: Adding a lot of tables

Dear All,

When I am adding (just commands CREATE TABLE and CREATE TRIGER) a bunch of tables (3000) to my db first everything goes
fastbut after some minutes the new tables are added at the speed of a snail. 
Does anybody know what could be the reason?

All the best,

Jan Musial

On 06/03/2012 16:58, jan.musial@giub.unibe.ch wrote:
> Dear All,
>
> When I am adding (just commands CREATE TABLE and CREATE TRIGER) a
> bunch of tables (3000) to my db first everything goes fast but after
> some minutes the new tables are added at the speed of a snail. Does
> anybody know what could be the reason?

Slow disk access? - only a guess, mind. You'll need to provide LOTS more
information before people can help. Platform, hardware, PG version, etc
etc etc.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie