| From: | Venkat Balaji <venkat(dot)balaji(at)verse(dot)in> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | PGSQL Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: : Create table taking time |
| Date: | 2011-09-29 08:02:29 |
| Message-ID: | CAFrxt0joAz8J2wYfj_Jsxmq=qjpLJckZU8bvskDzB+5hp2_nbg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
We had performed VACUUM FULL and ANALYZE on the whole database.
Yes, the CPU is ticking at 99-100% when i see the top command.
But, we have 8 CPUs with 6 cores each.
Thanks
VB
On Thu, Sep 29, 2011 at 12:44 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:
> On Wed, Sep 28, 2011 at 11:06 AM, 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 ?
> > Please share your thoughts.
>
> Are your system tables heavily bloated?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Numael Vacca Duran | 2011-09-29 12:43:37 | Select se bloquea |
| Previous Message | Scott Marlowe | 2011-09-28 19:14:51 | Re: : Create table taking time |