Re: : Create table taking time

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: : Create table taking time
Дата
Msg-id CAOR=d=2tppAf+B48oiatOQZJimrFjO4QCjEtyEAXRR4_y6yt7w@mail.gmail.com
обсуждение исходный текст
Ответ на : Create table taking time  (Venkat Balaji <venkat.balaji@verse.in>)
Ответы Re: : Create table taking time  (Venkat Balaji <venkat.balaji@verse.in>)
Список pgsql-performance
On Wed, Sep 28, 2011 at 11:06 AM, Venkat Balaji <venkat.balaji@verse.in> wrote:
> 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.

Are your system tables heavily bloated?

В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: : Create table taking time
Следующее
От: Venkat Balaji
Дата:
Сообщение: Re: : Create table taking time