Re: Adding a lot of tables

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: jan(dot)musial(at)giub(dot)unibe(dot)ch
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Adding a lot of tables
Date: 2012-03-06 18:25:34
Message-ID: 4F56569E.7040804@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/03/2012 16:58, jan(dot)musial(at)giub(dot)unibe(dot)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(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2012-03-06 18:51:31 Re: Unhelpful initdb error message
Previous Message Tom Lane 2012-03-06 18:20:39 Re: Unhelpful initdb error message