Re: Adding a lot of tables - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Adding a lot of tables
Date
Msg-id 4F56569E.7040804@iol.ie
Whole thread Raw
In response to Adding a lot of tables  (<jan.musial@giub.unibe.ch>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unhelpful initdb error message
Next
From: dennis jenkins
Date:
Subject: Re: Unhelpful initdb error message