From: | Venkat Balaji <venkat(dot)balaji(at)verse(dot)in> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | PGSQL Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: : Create table taking time |
Date: | 2011-09-30 05:22:30 |
Message-ID: | CAFrxt0ityGmYABf4LxeD+WJ5ZYFidrFo3NgrCj0MC31iAeKuWw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
I did not calculate the IO behavior of the server.
What i noticed for the logs is that, the checkpoints are occurring too
frequently each checkpoint is taking up to minimum 80 - 200+ seconds to
complete write and checkpoint sync is taking 80 - 200+ seconds to sync,
which is i believe IO intensive.
Thanks
VB
On Thu, Sep 29, 2011 at 10:22 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Venkat Balaji | 2011-09-30 10:30:25 | Re: PostgreSQL-9.0 Monitoring System to improve performance |
Previous Message | bricklen | 2011-09-30 03:27:44 | Re: array_except -- Find elements that are not common to both arrays |