Monthly Archives: March 2017

//March

BIG NEWS from BigSQL: Introducing pgDevOps!

To help our colleagues at OpenSCG provide better service to our clients, BigSQL developed pgDevOps - a one stop shop to provision, develop, and monitor PostgreSQL databases. And now... we are making pgDevOps available to the PostgreSQL community! How Does pgDevOps Help? Install and Provision: Package Manager: One-click installs of PostgreSQL [...]

By | March 30th, 2017|Categories: BigSQL, Holly PostgreSQL, OpenSource|Tags: , , , , , , |0 Comments

C++14 and Postgres

The C++ 14 specification came with huge improvements: Auto type deduction, lambdas, movable RValue expressions etc. -- the list is huge. Its a dream come true for lazy programmers like me : write less code & create fewer bugs ;) And get huge performance gains for free. OK this time I thought I'd try some [...]

By | March 28th, 2017|Categories: BigSQL, Jobin PostgreSQL, PostgreSQL Blogs|0 Comments

Importing Shapefiles into PostGIS with shp2pgsql

Geojson may be catching up, but by and far the most popular data format for sharing geospatial data is (and has been since the early 1990's) the shapefile. Although a shapefile is a simple way to share data that can be easily consumed by almost any GIS system, it comes with many limitations and is [...]

By | March 23rd, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , |1 Comment

Proliferation of NUMERIC

More and more I'm seeing people use a NUMERIC for their primary keys. This is a direct result of people leveraging automated tools for their Oracle to PostgreSQL migration. Oracle's NUMBER data type is frequently used as the primary key for a table so the tools just map to a PostgreSQL NUMERIC and calls it [...]

By | March 20th, 2017|Categories: Jim PostgreSQL|Tags: , , , |4 Comments

How to Save Money: Migrating from Oracle DW to AWS RDS PostgreSQL

How do you migrate a large, expensive, and on premises Oracle data warehouse to a free, open source, and cloud hosted database? PostgreSQL + Amazon RDS + OpenSCG (of course) The Customer A leader in the GPS (Global Positioning System) market has a fleet management product that provides businesses with real-time visibility of vehicle location, [...]

By | March 13th, 2017|Categories: Case Studies|Tags: , , |2 Comments

Migrations: What applications should I migrate?

When you have made the decision to investigate migrating your database applications from one database platform to another, the next big question you will need to answer is ‘Which application(s)?’ It seems like an easy enough question but there are many variables involved in whether or not the migration will be smooth. Technically, any application [...]

By | March 9th, 2017|Categories: Migration, OpenSCG, PostgreSQL|Tags: , , |0 Comments

Strategic Autovacuum

There's a big mis-conception that autovacuum is evil. Although it's true that autovacuum can do things unexpectedly, I've found that it's better to tune it up and let it do what it does best. There are always going to be large / busy / special tables that need special attention, and that's okay. Attached is [...]

By | March 8th, 2017|Categories: Scott PostgreSQL|Tags: , |2 Comments

Migrating from MongoDB (back) to PostgreSQL

We helped a customer move from MongoDB back to PostgreSQL. It's an interesting story about some of the challenges of scaling a database platform and ways that PostgreSQL provides very reliable, robust, scalable data services. The Customer The customer is a software company that provides mobile enterprise security and threat protection. Their product provides security [...]

By | March 8th, 2017|Categories: Case Studies, Migration|Tags: , , |3 Comments