Home > mailing lists

: Create table taking time - Mailing list pgsql-performance

From	Venkat Balaji
Subject	: Create table taking time
Date	September 28, 2011 17:07:05
Msg-id	CAFrxt0gvidds6171=yrFgxrX0n4XP81cSZk9KuSPeA2f9=AKKA@mail.gmail.com Whole thread Raw
Responses	Re: : Create table taking time Re: : Create table taking time Re: : Create table taking time
List	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

From: "Tomas Vondra"
Date: 28 September 2011, 12:21:48
Subject: Re: PostgreSQL-9.0 Monitoring System to improve performance

From: Venkat Balaji
Date: 28 September 2011, 17:17:52
Subject: : Looking for PG Books