Re: Create tables performance
Jeff Janes <jeff.janes@gmail.com>
From: Jeff Janes <jeff.janes@gmail.com>
To: Sylvain CAILLET <scaillet@alaloop.com>
Cc: pgsql-performance@postgresql.org
Date: 2012-07-09T17:02:50Z
Lists: pgsql-performance
On Sun, Jul 8, 2012 at 11:49 PM, Sylvain CAILLET <scaillet@alaloop.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