203 Articles tagged “PostgreSQL”

Those days feel really lucky to me. I’m currently visiting friends and customers in San Francisco, and really enjoying my trip here! Of course Josh Berkus took the opportunity to organise a SFPUG meeting and I had the pleasure of being the speaker over there. My talk was about the most recent version of Skytools and the opportunity to realise that we’re still missing a lot on documentation. One of the attendee did propose to help us on that front as he apparently really likes technical writing.

Last week was held the CHAR(13) conference in a great venue in the UK countryside. Not only did we discover UK under good weather conditions and some local beers, we also did share a lot of good ideas! *The Hordwood House is quite of a maze really!* The conference was run side to side with PGDAY UK, and those two days were packed with great conferences! I had the pleasure to present a talk about Advanced Distributed Architectures where some examples of architectures using Streaming Replication, Skytools and PLproxy are shown.

In a recent article here we’ve been talking about how do do Batch Updates in a very efficient way, using the Writable CTE features available in PostgreSQL 9.1. I sometime read how Common Table Expressions changed the life of fellow DBAs and developers, and would say that Writable CTE are at least the same boost again.

In a recent article Craig Kerstiens from Heroku did demo the really useful crosstab extension. That function allows you to pivot a table so that you can see the data from different categories in separate columns in the same row rather than in separate rows. The article from Craig is Pivoting in Postgres. *Pivoting a matrix, also known as a matrix transposition* Let’s do the same setup as he did, with a table containing some randomly generated data about hypothetical visits to a web page, say, by date then by operating system.

Recently I’ve been to some more conferences and didn’t take the time to blog about them, even though I really did have great fun over there. So I felt I should take some time and report about my experience at those conferences. And of course, some more is on the way, as the PostgreSQL Conference Tour gets busier each year it seems. *And PostgreSQL Conferences get more attendees each year!* PGCON 2013, Ottawa In may was the famous PGCON conference where PostgreSQL contributors are meeting all together, offering the occasion to run the Hackers Meeting.