Zdenek Kotala's weblog
COMMIT or ROLLBACK that is the question
All | Personal | PostgreSQL | Sun

20080529 Čtvrtek květen 29, 2008

PGCon 2008 - Lets go Elephant

PGCon 2008 is over. It held in Ottawa, Canada last week and it was really busy week. Conference began on Tuesday with two days of tutorials. And two days of talks followed afterwards in three separate tracks. Quality of tutorials and talks were very high. It was very nice to be there again and met with people. Especially most of Sun's Elephants were there and we could meet personally.

The conference is not only about talks. Social events are big advantage of the conference. Meet and discuss with other developers or PostgreSQL users is very useful. You can see photos for example on Magnus Hanager's photo album. It is nice to connect face with email address.

My talk

My main task there was present about in-place upgrade project. I discuss this topic with many people during the conference and it is really big issue. One TB database is usual size today and migrate data from old version to new one is DBA's nightmare. Everybody asked me if I have some code for testing. It has been big motivation for me. I'm now focusing on storage upgrade and unfortunately, code which I have now is only experiment. The changes between 8.2 and 8.3 version of postgreSQL are big and I thought that online conversion will not be possible without major rework. Fortunately, I got idea how to process old data structure online during my long flight to Ottawa. I discussed it with Tom Lane during a lunch and on Friday morning I had to adjust my presentation. It seems that my presentation has been accepted. It is mentioned in Bruce's and Josh'es blogs. I think my mission was accomplished successful. I have green light and now, I can start coding.

Thanks all who gave me a feedback and who offered me a help.

Posted by hlipa ( V 29 2008, 01:56:11 odp. CEST ) Permalink Comments [2]

Comments:

Your talk was indeed one of those that was of *enormous* interest, in view that the "in place upgrade" would be of immense value, particularly with data warehouse-like systems where the database is so large that establishing a backup would be problematic.

It was one of the more difficult talks in which to see a conclusion being drawn, and with your comments "I have green light and now, I can start coding." I think I see why; you weren't trying to have a conclusion in the talk, but rather to elicit reaction from the Core team on what approach(es) they consider viable.

As a suggestion for future talks: if you had ended the talk with a slide saying something like "Here are my open questions, and the direction I plan to proceed with; your feedback may change that!" that would have provided better closure to the talk.

At any rate, I think you documented the challenges and the dilemmas involved very well. Yes, indeed, that mission was successful. Hopefully it leads to useful code!

Posted by Chris Browne on červen 03, 2008 at 06:34 odp. CEST #

Thanks Chris for your suggestion. I really omitted to put any last closing slide :(.

Posted by Zdenek Kotala on červen 04, 2008 at 04:48 odp. CEST #

Post a Comment:

Comments are closed for this entry.

Archives
Links
Referrers