tag:blogger.com,1999:blog-7476449567742726187.post7269641469114588869..comments2023-12-18T12:25:52.296-08:00Comments on Database Soup: FOSS4G-NA 2012Josh Berkushttp://www.blogger.com/profile/09671139717468724246noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7476449567742726187.post-90038727142890192342012-04-19T11:10:15.383-07:002012-04-19T11:10:15.383-07:00Great to have you at FOSS4NA, Josh - hopefully thi...Great to have you at FOSS4NA, Josh - hopefully this will lead to even more synergy between the PostgreSQL and PostGIS communities. Spatial is a great place to find big gnarly edge cases...<br /><br />As for the BOF, don't forget that another interesting thing that came up is the need for a SAMPLE clause in PostgreSQL, and in particular having a spatially-aware one for PostGIS. The use case is displaying overviews of mult-milllion point tables in a way that indicates the actual spatial density.Dr JTShttps://www.blogger.com/profile/02383381220154739793noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-88994984663062618002012-04-13T13:29:38.176-07:002012-04-13T13:29:38.176-07:00As far as PostGIS and parallel query go, at FOSS4G...As far as PostGIS and parallel query go, at FOSS4G-NA I gave a talk about parallel querying with PostGIS- just use Stado (http://stado.us). I also brought up the point that you can use it on a single multi-core server and still get a big boost in query performance by creating multiple logical nodes.masonhttps://www.blogger.com/profile/09140762861582451023noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-33187270855094236012012-04-13T07:37:10.291-07:002012-04-13T07:37:10.291-07:00Hey, great report. I keep harping that our next c...Hey, great report. I keep harping that our next challenge is parallel query, so it is good to see that confirmed. Also good to see a market where we totally dominate, instead of being just a minority player!Bruce Momjianhttps://www.blogger.com/profile/07875088787463864011noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-50127292568412845332012-04-13T07:21:45.379-07:002012-04-13T07:21:45.379-07:00I would hardly call the BOF unsuccesful. Good ques...I would hardly call the BOF unsuccesful. Good questions with good discussion about options, current limitations, and future directions both regarding straight database techniques as well as specific approaches for spatial queries. Certainly a huge +1 to parallel query support, though!bitnerhttps://www.blogger.com/profile/12271153622597735232noreply@blogger.com