Re: : Create table taking time

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>
Cc: PGSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: : Create table taking time
Date: 2011-09-29 16:52:46
Message-ID: CAHyXU0wVchi6J84Qw5Yv=2ir=Us8+VG25xbDPNyXRiLUVptbvg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Sep 28, 2011 at 12:06 PM, Venkat Balaji <venkat(dot)balaji(at)verse(dot)in> wrote:
> Hello Everyone,
> I am back with an issue (likely).
> I am trying to create a table in our production database, and is taking 5
> seconds.
> We have executed VACUUM FULL and yet to run ANALYZE. Can i expect the CREATE
> TABLE to be faster after ANALYZE finishes ?
> Or is there anything serious ?

just ruling out something obvious -- this is vanilla create table, not
CREATE TABLE AS SELECT...?

also, what's i/o wait -- are you sure your not i/o bound and waiting
on transaction commit?

merlin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ondrej Ivanič 2011-09-29 21:12:41 Re: the number of child tables --table partitioning
Previous Message Kevin Grittner 2011-09-29 15:08:53 Re: the number of child tables --table partitioning