Adding TEXT columns tanks performance?

Поиск
Список
Период
Сортировка
От Arturo Perez
Тема Adding TEXT columns tanks performance?
Дата
Msg-id 258CC18D-1B4F-4131-B93C-976B06778B5D@hayesinc.com
обсуждение исходный текст
Ответы Re: Adding TEXT columns tanks performance?  (Ron Johnson <ron.l.johnson@cox.net>)
Re: Adding TEXT columns tanks performance?  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-general
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;

tia,
arturo


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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Move data between two databases SQL-ASCII to UTF8
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Adding TEXT columns tanks performance?