Re: left join with smaller table or index on (XXX is not null) to avoid upsert

Поиск
Список
Период
Сортировка
От Alex Hunsaker
Тема Re: left join with smaller table or index on (XXX is not null) to avoid upsert
Дата
Msg-id 34d269d40901190917g7a3a5db4t7f8c6ee53805a09@mail.gmail.com
обсуждение исходный текст
Ответ на Re: left join with smaller table or index on (XXX is not null) to avoid upsert  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Ответы Re: left join with smaller table or index on (XXX is not null) to avoid upsert
Список pgsql-general
On Mon, Jan 19, 2009 at 09:48, Grzegorz Jaśkiewicz <gryzman@gmail.com> wrote:
> On Mon, Jan 19, 2009 at 4:43 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> But having said that: 8.4 will provide a standard trigger that
>> short-circuits vacuous updates, which you can apply to tables in which
>> you think vacuous updates are likely.  It's your responsibility to place
>> the trigger so that it doesn't interfere with any other trigger
>> processing you may have.
>
> Tom, Can you point us to
> http://developer.postgresql.org/pgdocs/postgres/ where it is described
> in more detail ?

I assume he is talking about suppress_redundant_updates_trigger, see
http://developer.postgresql.org/pgdocs/postgres/functions-trigger.html

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

Предыдущее
От: Rubén F.
Дата:
Сообщение: number of connections
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: number of connections