: Create table taking time

From: Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>
To: PGSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: : Create table taking time
Date: 2011-09-28 17:06:55
Message-ID: CAFrxt0gvidds6171=yrFgxrX0n4XP81cSZk9KuSPeA2f9=AKKA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Thanks
VB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Venkat Balaji 2011-09-28 17:17:44 : Looking for PG Books
Previous Message Tomas Vondra 2011-09-28 12:14:17 Re: PostgreSQL-9.0 Monitoring System to improve performance