Weekly tweet digest for 2009-11-22

twittering on 2009-11-21

twittering on 2009-11-20

  • 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 #

twittering on 2009-11-19

twittering on 2009-11-18

  • 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 #

twittering on 2009-11-18

  • 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 #

twittering on 2009-11-17

twittering on 2009-11-16