Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more
Stephen Frost
Stephen Frost
Contributing author David Youatt An underappreciated element of PostgreSQL performance can be the data types chosen and their organization in tables. For sites that are always looking for that incremental performance improvement, managing the exact layout and utilization of every byte of a row (also known as a tuple) can be worthwhile. This is an important consideration for databases that are migrating from other databases to PostgreSQL as the data types available in PostgreSQL and how th...
Read MoreStephen Frost
Stephen Frost
PostgreSQL provides a bevy of authentication methods to allow you to pick the one that makes the most sense for your environment. One desired implementation that I have found customers wanting is to use Windows Active Directory with PostgreSQL's GSSAPI authentication interface using Kerberos . I've put together this guide to help you take advantage of this setup in your own environment. The first step in setting up a Windows Active Directory is to create a regular user account. The passw...
Read MoreStephen Frost
Stephen Frost
Today, I am wrapping up my preview of next week's PGConf.EU conference . I'm really excited about all of the excellent topics and speakers that we get to choose from! Once again, here's the full Schedule . On Friday morning, I have to recommend Arthur Zakirov and Oleg Bartunov ’s talk on Better Full Text Search in PostgreSQL , even if you don’t use any Full Text Search today, they will be discussing the new RUM indexing capability which is currently being worked on. If that isn’t your thi...
Read MoreStephen Frost
Stephen Frost
Today, I will continue with my preview of the exciting talks at the upcoming PGConf.EU conference. In Part 1 , I discussed the talks that will happen on Wednesday. Today, I want to dive into the Thursday sessions. Starting in early on Thursday morning,if you haven’t tracked all the fantastic progress we’ve made with PostgreSQL 9.6 then definitely go to Magnus Hagander ’s talk on What's New in PostgreSQL 9.6 . If all of that is old news to you and you’re looking at PG10 with the other devel...
Read MoreStephen Frost
Stephen Frost
Only one week left til PGConf.EU in Tallinn, Estonia! Next week will be PGConf.EU’s 8th conference, having traveled to many different parts of Europe, and lately moving on a North-East trajectory, two years ago in Madrid, last year in Vienna, is now in Tallinn, Estonia with another fantastic line-up of talks . Here are the talks which I am most interested in this year. Warning for the unwary, I’m a PostgreSQL Committer, so I tend to be quite developer heavy when it comes to my talk selections....
Read More