: Create table taking time

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: PGSQL Performance <pgsql-performance@xxxxxxxxxxxxxx>
Subject: : Create table taking time
From: Venkat Balaji <venkat.balaji@xxxxxxxx>
Date: Wed, 28 Sep 2011 22:36:55 +0530

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

Follow-Ups:
- Re: : Create table taking time
  - From: Merlin Moncure
- Re: : Create table taking time
  - From: Scott Marlowe
- Re: : Create table taking time
  - From: Josh Berkus

Prev by Date: Re: PostgreSQL-9.0 Monitoring System to improve performance
Next by Date: : Looking for PG Books
Previous by thread: PostgreSQL-9.0 Monitoring System to improve performance
Next by thread: Re: : Create table taking time
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux