News for hackers. Stuff that matters.

A comment on How Postgres chooses which index to use for a query. Parent comment

Re:How Postgres chooses which index to use for a query by petergeoghegan on Friday April 22, 2022 @02:56PM (#31126422)
> as of 2017 at least the plan was to implement merge using the underlying insert on conflict mechanism

That was something that was discussed at length at the time, but ultimately rejected. And so the implementation of MERGE in Postgres has essentially the same limitations as every other MERGE implementation that I'm familiar with.

Postgres clearly stresses the trade-off that MERGE makes in the docs, though. Which probably sets it apart.

[ Parent | on HN ]
Re:How Postgres chooses which index to use for a query by gfody on Friday April 22, 2022 @03:59PM (#31127292)
afaik postgres still doesn't have a merge command (just tested on 14.2)?
[ Parent | on HN ]
Re:How Postgres chooses which index to use for a query by petergeoghegan on Friday April 22, 2022 @04:15PM (#31127463)
It will be in Postgres 15, which will be out later in the year
[ Parent | on HN ]