Archive for the 'postgresql' Category

Really Big Elephants Data Warehousing with PostgreSQL

Thursday, January 10th, 2013

Presentation by Josh Berkus (PostgeSQL developer)
at MySQL User Conference 2011

Really Big Elephants Data Warehousing with PostgreSQL

Monday, October 31st, 2011

Presentation 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, 2011

An 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, 2011

InnoDB Flushing: Theory and solutions – MySQL Performance Blog

Friday, April 29th, 2011

blog 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, 2011

empirical 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, 2011

Cisco 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, 2010

An 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, 2010

Google 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