tag:blogger.com,1999:blog-9053536529694784563.post5275162561323254222..comments2020-05-07T00:33:57.272-07:00Comments on Database Explorer: Parallel Query (1)Simon Riggshttp://www.blogger.com/profile/06017750505968534813noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-9053536529694784563.post-87597442613747429802010-02-09T13:31:29.132-08:002010-02-09T13:31:29.132-08:00"Index Ordered Tables" that is the same ..."Index Ordered Tables" that is the same as a automatically maintained custered index?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-83067607249487526952010-02-07T00:35:11.930-08:002010-02-07T00:35:11.930-08:00"more helpful" needs to have a defined c..."more helpful" needs to have a defined context so we understand the use case. Most often discussions like this end up with people with different use cases needlessly disagreeing. We also need to be clear about use case so that we can identify sponsors for this work.<br /><br />Index Ordered Tables have been studied for a while now and proposed in the form of Grouped Item Indexes. That patch was never finished by Heikki, but its worth revisiting.<br /><br />Column based storage was discussed on a previous blog, so I won't re-visit that here.Simon Riggshttps://www.blogger.com/profile/06017750505968534813noreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-31345018090412914432010-02-06T05:43:24.974-08:002010-02-06T05:43:24.974-08:00Two things that I think would be more helpful than...Two things that I think would be more helpful than on-disk bitmap indexes would be Index Ordered Tables (using the mssql term) and Column Based Storage. The latter is probably a multi-release sized project, but I think step 1 would be to fully separate out logical from physical storage; some smaller projects along that path would be to implement self optimizing column storage (ie. pack fixed length columns at row start automagically), and to allow column re-order operations via alter table. Both highly desired features, and probably doable in a single release.Robert Treathttp://www.xzilla.net/noreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-88820807227893488042010-02-05T08:42:02.188-08:002010-02-05T08:42:02.188-08:00If you use summary tables or materialized views, y...If you use summary tables or materialized views, yes. But that presumes you know in advance the questions that will be asked. If you do then you also need the developer resources to set that up for you and sufficient additional performance to maintain them. The cross over comes when that burden becomes unmanageable and you need to switch to a database capable of addressing ad-hoc queries quickly. Automating materialized view maintenance will help with that, but Postgres don't have that yet.Simon Riggshttps://www.blogger.com/profile/06017750505968534813noreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-33987993456380568512010-02-05T08:28:26.521-08:002010-02-05T08:28:26.521-08:00Very interesting test results. We are exploring th...Very interesting test results. We are exploring the possibility of using PostgreSQL for OLAP workloads. Is it possible to bring PostgreSQL to the same performance level? That would be great.mikehttp://www.postgresql.orgnoreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-97630046582987892010-02-04T13:24:08.446-08:002010-02-04T13:24:08.446-08:00I vote for parallel query execution tooI vote for parallel query execution tooHugohttp://www.postgresql.orgnoreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-62537141062094774922010-02-04T11:29:05.482-08:002010-02-04T11:29:05.482-08:00I vote for parallel query execution. :DI vote for parallel query execution. :DMark Wonghttp://pugs.postgresql.org/blog/92noreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-45514658936769647182010-02-04T09:35:57.832-08:002010-02-04T09:35:57.832-08:00Greenplum contributed their code to the PostgreSQL...Greenplum contributed their code to the PostgreSQL community some time ago. There's been some showstoppers in that code that have prevented its acceptance to Postgres core, meaning a couple of developers have wrestled with it to little success. That was nothing to do with Greenplum, since they were keen to make the contribution to the community. I think I probably need to put both feet in and take sole responsibility for getting it in, since it needs some heavy lifting and also a committer interested in review-and-commit. In 9.1 though now!Simon Riggshttps://www.blogger.com/profile/06017750505968534813noreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-1630899640050573012010-02-04T09:12:37.942-08:002010-02-04T09:12:37.942-08:00Will on-disk bitmap indexes be contributed by Gree...Will on-disk bitmap indexes be contributed by Greenplum, or?Devrim Gündüzhttps://www.blogger.com/profile/06310074761027270876noreply@blogger.com