Spatial search = Postgres. SELECT count(*) FROM archive_data; count ——— 3063044 EXPLAIN ANALYZE SELECT …
Comment: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 30, 2010 By 16 Comments
Vadim, I was suggest testing Postgres because I imagine it would have very little increased difficulty over testing Greenplum. I do not think that you are incorrect in that performance would probably be lacking, I just thought that it would be another interesting baseline.
Comment: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 29, 2010 By 16 Comments
…, TYPO3) or an e-commerce solution (Opencart, Magento, …). Adding vanilla Postgres would still be interesting just to see how it compares…
Comment: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 29, 2010 By 16 Comments
Rob, GreenPlum allows column-oriented tables + can utilize all CPUs executing single query. Postgres can’t do afaik.
Comment: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 29, 2010 By 16 Comments
If you are benching Greenplum which is a proprietary fork of Postgres, why not also bench Pg for comparison sake?
Comment: When should you store serialized objects in the database?
January 26, 2010 By 47 Comments
This is completely OT and not meant to be trolling, but one of the things I’ve always thought Postgres could improve is make their data files less architecture-dependent.
Comment: When should you store serialized objects in the database?
January 24, 2010 By 47 Comments
Josh – what is the cost of a null column in Postgres? Do possibly null columns require a bit in the row header?
Comment: When should you store serialized objects in the database?
January 24, 2010 By 47 Comments
… null columns is not a reason to use E-Blob. Postgres is also very good at storing blobs, and compresses them…
Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 8, 2010 By 48 Comments
… flexibility and features that support their BI implementation. re: MyISAM/Postgres. I agree with Vadim, it would simply take too many…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… rather than your site which exists in single installation – Wordpress, vBulletin etc. With such software, if you’re not upgrading to…
