Really Big Elephants Data Warehousing with PostgreSQL
Thursday, January 10th, 2013Presentation by Josh Berkus (PostgeSQL developer)
at MySQL User Conference 2011
Archive for the 'postgresql' Category
Really Big Elephants Data Warehousing with PostgreSQL
Monday, October 31st, 2011Presentation by Josh Berkus (PostgeSQL developer)
at MySQL User Conference 2011
How InnoDB performs a checkpoint at Xaprb [by Baron Schwartz {of Perconna, MySQL vendor }
Friday, May 6th, 2011An article about MySQL InnoDB checkpoint-ing mechanism written by Perconna folks. Read comments as well, several PostgreSQL core committers have participated in the discussion.
“InnoDB’s checkpoint algorithm is not well documented. It is too co…
How InnoDB performs a checkpoint at Xaprb [by Baron Schwartz {of Perconna, MySQL vendor }
Friday, May 6th, 2011InnoDB Flushing: Theory and solutions – MySQL Performance Blog
Friday, April 29th, 2011blog posts that describes how MySQL InnoDB flushes data to disk (also see bgwriter, checkpoint_* parameters in PostgreSQL)
Valentine’s tech log: [PostgreSQL] Index sizes depending on the type of the field being indexed
Saturday, April 23rd, 2011empirical data about difference in index sizes depending on the data type
Cisco Service Node SN 10 & 100 product data sheet 0900aecd805c3cc1.pdf (application/pdf Object)
Sunday, February 13th, 2011Cisco Service Node for Linksys One — integrated solution for linksys voip CPE (registration, services, provisioning), consists of cisco network gear (chassis + console server ) , 2 HP DL G380G4 servers + MSA100 storage / FreeBSD, PostgreSQL, OpenSER, …
Robert Haas: MySQL vs. PostgreSQL, Part 1: Table Organization
Tuesday, November 30th, 2010An article from a well-known PostgreSQL developer comparing MySQL InnoDB and PostgreSQL table structures
Google Translate "Again about SQL " — route costs lookup for telephony operator
Tuesday, November 23rd, 2010Google translate of 2 posts in Russian section of LJ about route costs look up problem commonly faced by telephony operators
Comparing BenchmarkSQL Performance on Red Hat® Enterprise Linux 5 to Windows Server Enterprise
Wednesday, September 22nd, 2010“This paper compares the performance of an Online Transaction Processing (OLTP) based