Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

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 2f4958ff0901182353v1e6c8325s7dfa31666d6288@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  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: left join with smaller table or index on (XXX is not null) to avoid upsert
List pgsql-general
2009/1/19 Scott Marlowe <scott.marlowe@gmail.com>:
> Submit a patch. :)
>
> But seriously, it's doing what you told it to do. There might be
> corner cases where you need a trigger to fire for a row on change, and
> short-circuiting could cause things to fail in unexpected ways.

as far as my little knowledge about pg goes, that would be just
another addition to planner. <daydreaming> Say - when there's more
than X % of value Y, and we do set column X to Y, it could add that
'where'. But what if we have more WHERE statements, and they are quite
contradictory, etc, etc. It could actually do more damage than good.
(yes, I do have quite few more 'against' than for)</daydreaming>

I wrote that previous email, while waiting for breakfast, so I guess
it wasn't the best idea in the world ;)

--
GJ

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: left join with smaller table or index on (XXX is not null) to avoid upsert
Next
From: "Scott Marlowe"
Date:
Subject: Re: left join with smaller table or index on (XXX is not null) to avoid upsert