Weekly tweet digest for 2009-11-22

wow. that was a long weekend 🙂 #
oh good – :set nohlsearch
i've wanted to know that one for a while #vim #
RT @edaypdx: #opensqlcamp over, lots of fun and interesting conversations… Thanks to everyone who came out to make it such a great event! #
@rduffner glad you, drew and tom were there! hope to see more of you all at pdx events. #opensqlcamp #
thank yous for #opensqlcamp http://tr.im/F5Z3 #
RT @br3nda: picking which death metal albums to take to hospital for the birth. #
@zrusilla ooh, can i read a copy of that? in reply to zrusilla #
did you attend #opensqlcamp? Give us some feedback: http://opensqlcamp.org/Events/Portland2009/Feedback #
RT @jonjensen0: can also disable highlighting of the last search only with :nohl, if you want to leave it on for the next search #vim #
@igalko thanks for the tip re toggling highlighting. in reply to igalko #
looking forward to the direct flight to tokyo tomorrow. JPUG 10th anniversary conference, here I come! #postgresql #
i guess the leaves are turning and beautiful near tokyo: http://www.japan-guide.com/blog/koyo09/091116_takaosan.html #
RT @dukeleto: if you are in seattle, there is an open source/linux meetup going on tonight: http://bit.ly/4owp4f #gooutanddosomething #
#protip: book flights through Delta, not NWA. #
guidebooks acquired, maps printed. having a beer and relaxing. i'll pack tomorrow. 🙂 #jpug #postgresql #
@mherrick66 the developers themselves 🙂 but many are so new-ops support not clear. i'm interested in supporting luciddb,mongodb,cassandra. in reply to mherrick66 #
@mherrick66 yeah, not a lot of great answers right now for those types of questions 🙂 in reply to mherrick66 #
sort of packed. making coffee. TOTALLY FREAKING EXCITED. #
@snaga thanks! looking forward to meeting you. in reply to snaga #
@skinny tokyo for 10 days 🙂 in reply to skinny #
The official hashtag for this week's JPUG conference is #pgcon09j – take note my fellow attendees! (via @snaga) #postgres #
@LeahRosin @notbenh @darkixion thanks so much! will take tons of pictures. in reply to LeahRosin #
Thanks @trimet driver for stopping for me even though I wasn't at a bus stop #notthinkingstraight #
@kindrawoo thanks for the warning. Still thinking about what I'm going to eat at the airport. in reply to kindrawoo #
~@jenred haha! Maybe some ladies of open source should go on an Tour of Asia 🙂 in reply to jenred #
.@PDX ftw! Tacos and tamales for $5. Like having carts at the airport. #
@abrichar 🙂 thanks. we must catch up when i get back. in reply to abrichar #
@kcomandich thanks! I am so excited. Feeling fortunate and inspired. in reply to kcomandich #
Having a sweet time in Tokyo with @magnushagander @pgsnake. Thanks to Hiroshi, Tado, Ishikawa for fugu dinner where I didn't die. Yet. #
@snaga no, tonight we are having a Japanese whiskey. in reply to snaga #
Having tea. Wondering who else is coming to the clustering summit from my hotel this morning. #pgcon09j #
in #postgres cluster developer meeting, listening to @fuzzychef talk about what we *should* be thinking about implementing #pgcon09j #
.@fuzzychef says: three main clustering use cases: transactional, analytic, online. #pgcon09j #
online is the use case that most matches the 'eventually consistent' model #pgcon09j #
follow what's happening in #pgcon09j: http://tr.im/Fg9C #
my notes from josh's presentation http://wiki.postgresql.org/wiki/ClusteringUseCases #pgcon09j #
now listening to what skype is up to with replication #pgcon09j #
skype working on SPLIT implementation in PL/Proxy (parallel exec of functions with partitioned data) and two-phase commit #pgcon09j #
skytools version three coming very soon #pgcon09j #
.@snaga actually, @turnstep (Greg Sabino Mullane) is the primary developer of #bucardo #
Postgres-2 hoping to open up the code by the end of 2009. and yes, please support APIs and hooks! #pgcon09j #
setting the afternoon agenda for the clustering summit discussion: community accessibility, improve user knowledge & access #pgcon09j #
@samv another giant leap forward for cross-continental trolling 😉 in reply to samv #
@robtreat2 that issue was raised by the skype team themselves.. just hasn't been a priority so far, they say. in reply to robtreat2 #
Great welcoming party hosted by NTT. Now off to the after party at a pub #pgcon09j #
Helping @Simon_riggs prepare for his talk with more shochu. #pgcon09j #
Up at 4:05am to go to the fishmarket and have sushi breakfast #pgcon09j #
On the road http://yfrog.com/37qxwj #
got to #pgcon09j 1 hour early and grabbed sweet seats with power. got a seed packet from Hitachi in my swag bag. #
talking about when tom lane first appeared on postgres mailing lists #pgcon09j #
listening to Inaba-san give the opening remarks and an overview of yesterday's clustering meeting #pgcon09j #
fun to hear about start of JPUG in 1999. people excited about postgres getting together to advocate its use. #pgcon09j #
There will be ustream access to #pgcon09j tomorrow: http://www.postgresql.jp/events/pgcon09j/e/pgcon2009j/ #
listening about Streaming Replication from Masao Fujii, Simon Riggs up next for Hot Standby #pgcon09j http://tr.im/FkM1 http://tr.im/FkM6 #
Replication war! (from Masao's talk) http://yfrog.com/4izxxuj #
'recv' mode is likely best tradeoff between performance, data loss possibility and durability. must use heartbeat for failover. #pgcon09j #
.@simon_riggs is up to talk about hot standby #pgcon09j #
Going over hot standby query conflicts #pgcon09j http://yfrog.com/37crivj #
and now for a live demo of streaming rep & hot standby from Masao Fujii #pgcon09j #
streaming rep configuration instructions: http://wiki.postgresql.org/wiki/Streaming_Replication#How_to_Use #pgcon09j #
awww, awesome @simon_riggs gave Koichi-san a bottle of scotch #pgcon09j #
liking the morph labs UI. also their commitment to using open source tools. no lockin, ftw. #pgcon09j #
michael glaesemann on visualizing data about postgres.7 places for data: analyze, host, bloat, dtrace/systap, logs, contrib, stats #pgcon09j #
@Mettadore yes, definitely. in reply to Mettadore #
listening to @stefankaltenb talk about postgres project infrastructure team and projects #pgcon09j #
listening to Greg Stark talk about forensic analysis of corrupted postgresql databases #pgcon09j #
most common failure reported on the postgres mailing lists is bad memory #pgcon09j #
common errors:fsync=off,full_page_writes=off,hot backups done wrong,recover to different architecture, IMMUTABLE misuse,collation #pgcon09j #
.@janl we can just blame hardware 😉 but really, some config issues should be better documented, and maybe doing it wrong should be harder. in reply to janl #
@janl maybe config examples should be on a continuum: cheap/fast/OOC <-> absolute consistency in reply to janl #
@stewartsmith no 🙂 there's a data structure that gets verified – then you get errors/warnings, but no checksum. in reply to stewartsmith #
@janl LOL i could make a custom config parameter that executes a function…. in reply to janl #
greg stark demonstrating zeroing out corrupted 8k pages. yeah, we've all done that before. #pgcon09j #
@snaga oh awesome! nice to know that, and thank you! in reply to snaga #
worried about memory errors? use ECC memory, and monitor for corrected errors. DIMMs usually have 0 or lots of errors. #pgcon09j #
DRAM Errors in the Wild: A Large-Scale Field study (by Bianca Schroeder, and Eduardo Pinheiro/Wolf-Dietrich) http://tr.im/FpsO #pgcon09j #
workaround for lack of checksum: use a FS checksum (ZFS)-only catches a subset of errors & does not catch in-memory corruption. #pgcon09j #
@funkatron no, I don't use zfs. primarily xfs or ext3. looking forward to ext4 and, eventually, btrfs. in reply to funkatron #
done with user groups talk for #pgcon09j. now looking forward to giving a final bucardo lightning talk. #
They are livestreamin the lightning talks on ustream #pgcon09j #
Ustream : PostgreSQL Conference 2009 Japan Lightning Talks http://j.mp/7ayf51 #pgcon09j (via @suzuki) #
Pg_reorg looks interesting. Wishing I understood Japanese. #pgcon09j #
@snaga heh. We need realtime translation of my lightning talk now! in reply to snaga #
Lightning talks are over, now closing session from Kaori Inaba. #pgcon09j #
38 speakers gave talks at #pgcon09j. Really have enjoyed it! #
@stefankaltenb nice work! Now that you fixed the bug 😉 in reply to stefankaltenb #
350 participants through the conference! #pgcon09j #
my lightning talk is already online! RT @suzuki: @selenamarie your talks at http://j.mp/7XphnN #pgcon09j #
Discussing social networking storage to distribute WAL and how we're rapidly approaching an exceptionally slow streaming rep implementation #
@DopeFac4Life yes, you really should be 🙂 in reply to DopeFac4Life #
@snaga so good to meet you as well. look forward to translating 🙂 in reply to snaga #
@umitanuki re: visualizer would be very nice – even simple ASCII art would be useful in reply to umitanuki #
@xanderpico Ah! make sure you go through to the visitor entrance, get there early (4:15am!), fresh shrimp was amazing. tuna is huge! in reply to xanderpico #
headed out for a day of sight-seeing in Kamakura with Ishii-san and others http://tr.im/Fsuk #
Had amazing Chinese lunch, and saw the giant kannon. http://bit.ly/8GF0Ut #
Waiting at Tokyo station for @mildwail #
pretty, sunny day. headed off to the rainbow bridge. #