tag:blogger.com,1999:blog-20038672.post145498093279585567..comments2024-03-28T00:58:29.187-04:00Comments on Robert Haas: PostgreSQL 9.1: Big PatchesRobert Haashttp://www.blogger.com/profile/08393677427643988650noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-20038672.post-74768780692349357022011-01-09T12:04:14.374-05:002011-01-09T12:04:14.374-05:00What do you mean?What do you mean?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20038672.post-62373708420220295412011-01-05T13:45:19.409-05:002011-01-05T13:45:19.409-05:00Sync rep will be useful for some people, but it...Sync rep will be useful for some people, but it's likely to come with a pretty high performance cost, as it does in other products, so I'm not sure how many people will want to pay that cost.<br /><br />With respect to inheritance being fully implemented, I'm not sure what this is referring to.Robert Haashttps://www.blogger.com/profile/08393677427643988650noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-49010776147552451972011-01-05T13:43:42.184-05:002011-01-05T13:43:42.184-05:00Hi,
any info on when inheritance will be fully im...Hi,<br /><br />any info on when inheritance will be fully implemented?<br /><br />And thanks for a great DBMS!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20038672.post-80369062439579606232011-01-05T12:49:11.275-05:002011-01-05T12:49:11.275-05:00Yay for unlogged tables. That and sync rep are the...Yay for unlogged tables. That and sync rep are the big ones for me. <br /><br />For sync rep, I think this is going to be so hot that everyone and their mother is going to have an opinion. <br /><br />I hope they can just start with the one (as it looks like they are planning) and we can go from there. <br /><br />The only parameter I care about is the configurable durability on the standby (ie, just ack on received or all the way to disk etc). <br /><br />Good luck!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20038672.post-39616052940019068902011-01-05T10:38:05.767-05:002011-01-05T10:38:05.767-05:00Without parallel query, much of the benefit of par...Without parallel query, much of the benefit of partitions are not seen. <br /><br />You can get most of the performance boost you are looking for with partial indexes. It does not partition the data, but it does effectively partition the index.Grant Johnsonhttps://www.blogger.com/profile/06772023212277928936noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-10108969049302042522011-01-05T09:00:14.094-05:002011-01-05T09:00:14.094-05:00Itagaki Takahiro was working on the partitioning s...Itagaki Takahiro was working on the partitioning syntax back in July, but hasn't to my knowledge revised it recently. I think there is general agreement on what the syntax should look like; it was primarily the system catalog representation that was under discussion.Robert Haashttps://www.blogger.com/profile/08393677427643988650noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-39439830140148131162011-01-05T06:33:12.542-05:002011-01-05T06:33:12.542-05:00I think postgresql develoeprs in general didn'...I think postgresql develoeprs in general didn't liked any presented solutions to the partitioning problem so far. Nor they are keen on actually writing their own. Really weird for what is supposedly enterprise grade database.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20038672.post-18660613172887621602011-01-05T04:52:18.900-05:002011-01-05T04:52:18.900-05:00any news on new syntax for partitioning?any news on new syntax for partitioning?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20038672.post-48350410082662128272011-01-04T20:46:15.373-05:002011-01-04T20:46:15.373-05:00I think that's basically not going to happen f...I think that's basically not going to happen for 9.1. I may work on it for 9.2.Robert Haashttps://www.blogger.com/profile/08393677427643988650noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-51184112904769728452011-01-04T20:30:23.008-05:002011-01-04T20:30:23.008-05:00any word on index-only scan patch?any word on index-only scan patch?Slavahttps://www.blogger.com/profile/09546623022761909519noreply@blogger.com