Re: Create tables performance

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Sylvain CAILLET <scaillet(at)alaloop(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Create tables performance
Date: 2012-07-09 17:02:50
Message-ID: CAMkU=1ybZ-xrfWqWTJVw7LNgALzWbT+aLo6-LgxTBidqdHuUQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sun, Jul 8, 2012 at 11:49 PM, Sylvain CAILLET <scaillet(at)alaloop(dot)com> wrote:
> Hi,
>
> Thank you all for your help.
>
> @Jeff : my daemon creates these tables at start time so it doesn't do
> anything else at the same time. The CPU is loaded between 20% and 25%.

How does it decide which tables to create? Is it querying the
existing tables to figure out what new ones to make? Is the rest of
the time going to IO wait?

Cheers,

Jeff

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message jamonb 2012-07-09 17:16:01 Re: SSDs again, LSI Warpdrive 2 anyone?
Previous Message Greg Spiegelberg 2012-07-09 14:33:36 Re: Paged Query