Postgres Pro
Downloads
Home   >   mailing lists

Re: : Create table taking time - Mailing list pgsql-performance

From Josh Berkus
Subject Re: : Create table taking time
Date
Msg-id 4E836DA6.8030200@agliodbs.com
Whole thread Raw
In response to : Create table taking time  (Venkat Balaji <venkat.balaji@verse.in>)
List pgsql-performance
Tree view 
> We have executed VACUUM FULL and yet to run ANALYZE. Can i expect the CREATE
> TABLE to be faster after ANALYZE finishes ?

The only way CREATE TABLE would be affected by VACUUM ANALYZE running is
if you're saturating either your CPU or your disk 100%.  Which you may
be, on a low-end system.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: : Looking for PG Books
Next
From: Scott Marlowe
Date:
Subject: Re: : Create table taking time