Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL survey

From: Jim Nasby <Jim(at)Nasby(dot)net>
To: Cesar Massaki Kamiya <cesarmk(at)gmail(dot)com>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: PostgreSQL survey
Date: 2011-12-24 19:25:17
Message-ID: D5B7C206-D9B3-4897-8EDB-101DB1A6C011@Nasby.net (view raw or flat)
Thread:
Lists: pgsql-advocacy
<html><body class="ApplePlainTextBody" style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">On Dec 9, 2011, at 3:42 PM, Cesar Massaki Kamiya wrote:<br><blockquote type="cite">1. Anyone using PostgreSQL for enterprise mission critical system ?<br></blockquote><br>Enova Financial runs all of our OLTP and a large portion of our reporting on Postgres. Our largest OLTP database is ~1.8TB and the&nbsp;last time I measured it (almost 2 years ago) it averaged 640TPS and peaked at over 4kTPS.<br><br>Downtime on that database costs the company well over $100k/hour.<br><br><blockquote type="cite">2. How big are the servers you are running PostgreSQL, Is there anyone using more than 32 cores or 256GB memory ?<br></blockquote><br>We don't currently have anything over 32 cores, but we have several servers with 1/2TB of memory. The vast majority of that memory&nbsp;is used by the filesystem cache.<br><br><blockquote type="cite">3. What OS you are using to run this mission critical system on PostgreSQL ? Linux, Unix ?<br></blockquote><br>Linux.<br><br><blockquote type="cite">4. Who provides PostgreSQL support ? &nbsp;Do you have any support contract with a third party company ? If so, how much is the monthly&nbsp;support fee ?<br></blockquote><br>We use Command Prompt for our formal support contract, but we have also used consulting services from PgX and 2nd Quadrant.<br><br>As others have mentioned, support on the mailing list is generally excellent and you will have a challenge hiring someone that is&nbsp;highly knowledgable in Postgres (I would estimate the pool of people who could be considered experts in Postgres and would consider&nbsp;a job offer in the US to be less than 1000). Your best bet may be to find someone who is experienced in a number of other RDBMSes&nbsp;and is willing to learn Postgres. Just make sure to bump up their compensation as they become experienced or you risk loosing them&nbsp;(my rule of thumb is that PG knowledge is worth ~25% more than comparable Oracle knowlege).<br>--<br>Jim C. Nasby, Database Architect &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jim(at)nasby(dot)net<br>512.569.9461 (cell) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; http://jim.nasby.net<br><br><br></body></html>

Attachment: unknown_filename
Description: text/html (2.3 KB)

In response to

pgsql-advocacy by date

Next:From: Eric RedmondDate: 2012-01-20 05:49:10
Subject: Book Reviewers
Previous:From: Gilberto Castillo MartínezDate: 2011-12-19 14:46:16
Subject: News from Cuba

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group