Re: left join with smaller table or index on (XXX is not null) to avoid upsert - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: left join with smaller table or index on (XXX is not null) to avoid upsert
Date
Msg-id 2f4958ff0901200740o623ba9c3pc8f42b108f951aaf@mail.gmail.com
Whole thread Raw
In response to Re: left join with smaller table or index on (XXX is not null) to avoid upsert  (Alex Hunsaker <badalex@gmail.com>)
List pgsql-general
the only difference here is, that the trigger will memcmp (compare)
all data. Say, if we have two columns, int and bytea, and just want to
compare fist one - it will use a lot of cpu in vain.
I have to say, it is a shame sometimes - that trigger isn't aware of
what fields we do update exactly

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: import sql dump with psql - language creation throws error
Next
From: David Fetter
Date:
Subject: Re: Database schema & data synchronizer software for PostgreSQL?