PostgreSQL
Importing XML content from file
The problem was raised this week on IRC and this time again I felt it would be a good occasion for a blog entry: how to load an XML file content into a single field? The …
tag
PostgreSQL
210 posts
Conferences
Asko Oja talks about Skype architecture
In this russian page you’ll see a nice presentation of Skype databases architectures by Asko Oja himself. It’s the talk at Russian PostgreSQL Community …
PostgreSQL
Comparing Londiste and Slony
In the page about Skytools I’ve encouraged people to ask some more questions in order for me to be able to try and answer them. That just happened, as usual on the …
PostgreSQL
Controling HOT usage in 8.3
As it happens, I’ve got some environments where I want to make sure HOT ( aka Heap Only Tuples) is in use. Because we’re doing so much updates a second that I …
PostgreSQL
Londiste Trick
So, you’re using londiste and the ticker has not been running all night long, due to some restart glitch in your procedures, and the on call admin didn’t …
Software Programming
Fake entry
This is a test of a fake entry to see how muse will manage this. With some SQL inside: SELECT * FROM planet.postgresql.org WHERE author = "dim";