Re: [HACKERS] REPLICA IDENTITY FULL
От | Peter Eisentraut |
---|---|
Тема | Re: [HACKERS] REPLICA IDENTITY FULL |
Дата | |
Msg-id | 6c7dfbb8-506a-e8f2-196e-3912db2a6307@2ndquadrant.com обсуждение исходный текст |
Ответ на | Re: [HACKERS] REPLICA IDENTITY FULL (Alvaro Herrera <alvherre@2ndquadrant.com>) |
Ответы |
Re: [HACKERS] REPLICA IDENTITY FULL
Re: REPLICA IDENTITY FULL |
Список | pgsql-hackers |
On 6/23/17 13:14, Alvaro Herrera wrote: > Andres Freund wrote: >> On 2017-06-23 13:05:21 -0400, Alvaro Herrera wrote: >>> Tom Lane wrote: >>>> Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes: >>>>> Any thoughts about keeping datumAsEqual() as a first check? I did some >>>>> light performance tests, but it was inconclusive. >>>> >>>> Seems like it would tend to be a win if, in fact, the values are >>>> usually equal. If they're usually not, then it's a loser. Do >>>> we have any feeling for which case is more common? >> >> Seems like a premature optimization to me - if you care about >> performance and do this frequently, you're not going to end up using >> FULL. If we want to performance optimize, it'd probably better to >> lookup candidate keys and use those if available. > > I can get behind that argument. Thanks for the feedback. I have committed it after removing the datumIsEqual() call. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: