tag:blogger.com,1999:blog-9053536529694784563.post3574738409458238937..comments2020-05-07T00:33:57.272-07:00Comments on Database Explorer: Bollywood FeaturesSimon Riggshttp://www.blogger.com/profile/06017750505968534813noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-9053536529694784563.post-61755923288304887632010-05-18T13:48:21.917-07:002010-05-18T13:48:21.917-07:00MERGE is listed under high performance because if ...MERGE is listed under high performance because if you can do a single statement rather than 2 plus a subtransaction loop and specific code then it will be much faster with the right implementation.<br /><br />I'm aware of the project. I think it's irresponsible of people to have allowed an important and complex feature be done in this way. It's unreasonable to expect that the poor chap will get much done at all. We shouldn't be actively handing the hardest tasks we have to the least experienced, however talented and full of promise they may be (and I'm sure they are). It's not fair on them and it is likely to delay the eventual implementation by doing it, which risks slipping a release. That's exactly what happened with partitioning and its been delayed for years as a result. Parallel query etc.. Having said that Hot Standby came out of a student project and was an excellent piece of initial research, so we'll have to wait and see.Simon Riggshttps://www.blogger.com/profile/06017750505968534813noreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-27152473778842908962010-05-18T12:22:53.340-07:002010-05-18T12:22:53.340-07:00We have a GSoC student working on MERGE command:
...We have a GSoC student working on MERGE command:<br /><br />http://wiki.postgresql.org/wiki/Add_MERGE_command_GSoC_2010<br /><br />It's a tough feature, so he'll need help from the community to get the design right. I'm not sure why this was listed under high performance stuff, though. Maybe it helps with performance, but I believe most people are most interested in that to have a handy syntax for "update if exists, otherwise insert". And for general SQL compliance reasons, of course.Heikki Linnakangasnoreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-82066927222384582732010-05-17T14:13:48.384-07:002010-05-17T14:13:48.384-07:00Would LOVE to see merge and bitmap indexes.Would LOVE to see merge and bitmap indexes.Chris Spottshttps://www.blogger.com/profile/15071378159488654217noreply@blogger.com