Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains
Дата
Msg-id 2527a6fd-6c9b-713e-3eda-8f9250bfe906@hogranch.com
обсуждение исходный текст
Ответ на Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains  (John R Pierce <pierce@hogranch.com>)
Ответы Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains  (Chris Withers <chris@simplistix.co.uk>)
Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains  (Chris Withers <chris@withers.org>)
Список pgsql-general
Дерево обсуждения 
On 9/16/2016 2:23 AM, John R Pierce wrote:
>
> wait, what is a tsrange?   the standard textsearch data types in
> postgres are tsvector and tsquery,

never mind,  I should have known, its a timestamp range.   ...


when you do updates, are you changing any of the indexed fields, or just
"value" ?

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Unable to create oracle_fdw (foreign data wrapper) extension