Dave PostgreSQL

/Dave PostgreSQL

Relocatable PG RPMs

Relocatable PostgreSQL RPMs - You asked and we delivered! In our years of dealing with PostgreSQL users, one of the main gripes they have with PostgreSQL is not a missing feature or capability but rather it is the fact that the provided rpms are non relocatable rpms. The reasons for wanting relocatable rpms are many [...]

By | October 19th, 2016|BigSQL, Dave PostgreSQL, OpenSource|0 Comments

Holy Easy PostgreSQL deployment

Holy Easy PostgreSQL deployment! In case you missed it, the BigSQL team released an awesome package manager for installing and configuring PostgreSQL and many related, useful components. The package manager can be found here: https://www.bigsql.org/package-manager.jsp. Playfully named pgc, for ‘pretty good command line’, pgc is a utility similar to yum or apt-get that allows you [...]

By | October 14th, 2016|BigSQL, Dave PostgreSQL, OpenSCG|0 Comments

PostgreSQL Replication Checklist

Replication is a key part of creating an "Enterprise" Postgres deployment, to support high availability, failover, disaster recovery, or scale-out queries. Built-in streaming replication was added to PostgreSQL in version 9.0, but the Postgres community has had a number of trigger based replication options for many years, with the big 3 being Slony-I, Londsite, and Bucardo (we're [...]

By | September 28th, 2016|Dave PostgreSQL|0 Comments

Improve PostgreSQL on Windows performance by 100%

It sounds like click-bait, or one of those late night TV promotions - "Improve your database performance by 100% - by changing just this one setting!" But in this case, it's true - you can drastically improve PostgreSQL on Windows performance by changing one configuration setting - and we made this the default in our [...]

By | September 20th, 2016|Dave PostgreSQL, OpenSCG|0 Comments