Re: Adding TEXT columns tanks performance?

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Adding TEXT columns tanks performance?
Дата
Msg-id b42b73150702090843m5932faa7pb8ec7feafb9e450b@mail.gmail.com
обсуждение исходный текст
Ответ на Adding TEXT columns tanks performance?  (Arturo Perez <aperez@hayesinc.com>)
Ответы Re: Adding TEXT columns tanks performance?  (Arturo Perez <aperez@hayesinc.com>)
Список pgsql-general
On 2/8/07, Arturo Perez <aperez@hayesinc.com> wrote:
> Hi all,
>
> Saturday I changed a table to add a varchar(24) and a TEXT column.
> It's used for some reporting purposes (small potatoe stuff really)
> and the TEXT column remains mostly empty.  However, this week
> performance has gotten terrible.  Queries joining against the
> aforementioned table have gone from 40s to 1500s.  The schema change
> is the only explanation I have for the 30x slower queries.  The
> queries have definitely gotten disk-bound (I can see the connection
> process sitting in the D state for several minutes).
>
> This is pg8.1.4 on Linux RedHat. Would adding a TEXT column impact
> things that much?  The change to the schema was
>
> alter table foo add column title text;

explain analyze please.

no reason for adding text column to do that.  especially since you
didn't default the column which would effectively update the entire
table.

merlin

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

Предыдущее
От: Marc Branchaud
Дата:
Сообщение: Modifying a foreign key constraint?
Следующее
От: Madison Kelly
Дата:
Сообщение: Re: Possibly odd question; diff results?