A lot is being said about the new ‘tablesample’ feature of PostgreSQL 9.5. The ability to retrieve a random sample of data in a short amount of time from a very large table makes it ideal to use tablesample as part of big data analytics. To demonstrate my point, I created 6 tables using the same DDL and then inserted varying amounts of data in them. I ended up with tables of row count 1k, 100k, 1m...

So, the Alpha 2 for 2ndQuadrant’s Unified Data Analytics (or 2UDA) was released today. We have basically repackaged the latest versions of PostgreSQL 9.5, Orange 3, & LibreOffice 5 in this release. Some major installer enhancements have also made it in, including operating system level services for PostgreSQL on OSX and Linux as well as code signing certificate for Windows. To give you a little...

It’s been an interesting 9 months for me personally, joining the 2ndQuadrant team in April 2013 to lead marketing. I’ve been particularly impressed by the quality and skills of the people I’ve met – not just from 2ndQuadrant but also the Postgres Community, from many countries around the world. Of course what has also impressed me is the quality of PostgreSQL. The more I learn, the more I can see...