| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Venkat Balaji" <venkat(dot)balaji(at)verse(dot)in> |
| Cc: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, "PGSQL Performance" <pgsql-performance(at)postgresql(dot)org>, <Josh Berkus <josh(at)postgresql(dot)org> |
| Subject: | Re: : Create table taking time |
| Date: | 2011-09-29 13:48:56 |
| Message-ID: | 4E8430F802000025000418A6@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Venkat Balaji <venkat(dot)balaji(at)verse(dot)in> wrote:
> We had performed VACUUM FULL and ANALYZE on the whole database.
Since you don't mention REINDEX, it seems likely that you've bloated
your indexes (potentially including the indexes on system tables).
That could lead to the symptoms you describe.
> Yes, the CPU is ticking at 99-100% when i see the top command.
>
> But, we have 8 CPUs with 6 cores each.
If you've pegged 48 CPUs, it might be interesting to get a profile
of where the time is being spent. Are you able to run oprofile or
something similar?
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jian Shi | 2011-09-29 14:14:35 | the number of child tables --table partitioning |
| Previous Message | Numael Vacca Duran | 2011-09-29 12:43:37 | Select se bloquea |