Re: slow DDL creation

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: slow DDL creation
Дата
Msg-id AANLkTi=bV1PD1n=OAwpmP0ce96WBnFumHW-FUo7MdyJ2@mail.gmail.com
обсуждение исходный текст
Ответ на slow DDL creation  (Kevin Kempter <cs_dba@consistentstate.com>)
Ответы Re: slow DDL creation  (Kevin Kempter <cs_dba@consistentstate.com>)
Список pgsql-performance
On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter
<cs_dba@consistentstate.com> wrote:
> Hi all ;
>
> we have an automated partition creation process that includes the creation of
> an FK constraint. we have a few other servers with similar scenarios and this
> is the only server that stinks per when we create the new partitions.
>
> Anyone have any thoughts on how to debug this?  were running postgres 8.4.4 on
> CentOS 5.5
>
> Thanks in advance

Is the referenced column indexed?

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

Предыдущее
От: David Boreham
Дата:
Сообщение: Re: GPU Accelerated Sorting
Следующее
От: David Fetter
Дата:
Сообщение: Re: slow DDL creation