Re: Are there performance advantages in storing bulky field in separate table?

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: Are there performance advantages in storing bulky field in separate table?
Дата
Msg-id 2f4958ff0904090454v4ab93a06k46fdb2aada4cf16f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Are there performance advantages in storing bulky field in separate table?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
If I may, I got an instance once, where table with bytea field was
pretty slow. Turned out, that queries modified everything apart from
bytea bit.
moving it to separate table actually helped performance.

But that only will happen providing that you have the
bytea/text/whatever that won't change, once inserted.

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Are there performance advantages in storing bulky field in separate table?
Следующее
От: Sam Mason
Дата:
Сообщение: Re: Postgres: Starting Server in background mode