I got asked on irc to show some examples how to use recursive CTE. Apparently my previous post wasn't good enough 🙂
I think that most of the users will use recursive cte to deal with trees I decided to show how to use it, even though it's not my favorite approach to dealing with trees in SQL.
Continue reading r/trees ( recursive trees, what did you think about? )
On 14h of December, Andrew Dunstan committed patch:
Add --exclude-table-data option to pg_dump. Andrew Dunstan, reviewed by Josh Berkus, Robert Haas and Peter Geoghegan. This allows dumping of a table definition but not its data, on a per table basis. Table name patterns are supported just as for --exclude-table.
Continue reading Waiting for 9.2 – excluding data of table from dump
I'm huge fan of stand-up comedy, and one of the guys that I like is Louis CK. Learned today that he made new movie – “Live at the Beacon Theater", and it's available on his site. For $5. Without DRM, geographical limitations or other bullshit.
So, if you can handle his kind of jokes – it's a must have. And at this price (again: 5 USD!) it's not like your budget will collapse.
The site is https://buy.louisck.net/, and there is also interesting statement explaining some things, and telling how much did he made so far.
Apparently there are some DNS issues with their site – it the name doesn't resolve, either switch (temporarily) to 8.8.8.8 dns server, or use following information to fill your /etc/hosts:
$ host buy.louisck.net buy.louisck.net is an alias for LiveSiteELB-1109051832.us-east-1.elb.amazonaws.com. LiveSiteELB-1109051832.us-east-1.elb.amazonaws.com has address 107.21.105.222 LiveSiteELB-1109051832.us-east-1.elb.amazonaws.com has address 107.21.113.172 LiveSiteELB-1109051832.us-east-1.elb.amazonaws.com has address 107.22.233.77 LiveSiteELB-1109051832.us-east-1.elb.amazonaws.com has address 107.21.103.188 LiveSiteELB-1109051832.us-east-1.elb.amazonaws.com has address 107.21.105.96 LiveSiteELB-1109051832.us-east-1.elb.amazonaws.com has address 107.21.105.220
( title, in case you don't know, comes from excellent “movie" about databases )
The secret ingredient is of course sharding.
Can we do sharding in PostgreSQL? First, let's define what sharding is:
Continue reading The secret ingredient in the webscale sauce
No Points Name Hp [max]
1 179310 depesz-Wiz-Hum-Fem-Cha died in The Dungeons of Doom
on level 22. Killed by a minotaur. - [94]Just released version 0.2.0 of OmniPITR. There is one important change – that is OmniPITR backup programs can now create checksum files for backups.
Details in docs, but the basic idea is that to all the other options to omnipitr-backup-{master,slave} we added (Phil Sorber to be exact) –digest option, which lets you specify that you want some checksums (md5, sha1, sha2).
Recently I had birthday, and I'd like to share one picture. My wife got me a cake. In shape of my currently favorite drink. All of it, including the label, was edible, and actually really good (a bit on the sweet side, but still good).
On 3rd of November, Heikki Linnakangas committed patch:
Support range DATA types. Selectivity estimation functions are missing FOR SOME range TYPE operators, which IS a TODO. Jeff Davis
As I wrote earlier, we (my wife and me) went to Maldives. This is brief summary, with some photos below.
This post is scheduled to appear on the web when we will be on our way.
I would like to express big gratitude to all of you who helped me with my plan. As far as I know right now (Monday, 10th of October) Ula still doesn't know about the surprise trip. Which should make for a nice effect on Wednesday on the airport.
Anyway – for those of you curious on where we're going: Maldives, Kuredu Resort/Island. When we'll be back I will probably have some pictures, but not sure about it as neither I nor Ula are big fans on making photos.
I hope it will will work out fine, the place seems nice, even though the weather forecast is not in favor of us. We'll see.
During this time I do not plan to check email, write blogposts (even in case of something big would get committed to PostgreSQL), so if you'd need to contact me for something – well, after 21st I should be back online.
Thanks again for all the help.