Postgres and Open Source Experts

I gave a lightning talk at Pg Conference: West 08 about a tool that I have developed call PITRTools. PITRTools is a python based log shipping utility. Essentially it wraps itself around standard tools such as rsync, and pg_standby to provide a usable experience. Some of the features is provides are:

• Auto initialization of environment
• Simple base backups
• Monitoring of Master
• Arbitrary alerts
• Failover
• Failover actions
• etc...

In all it …

I know it appears that it has been pretty quiet since we open sourced Replicator but that isn't the case. We have been actively working on 1.9 and fixing 1.8 Beta as bug reports have come in, including a bug to sequence replication. However, 1.9 is the true milestone release where we have finally moved away from the original architecture. For those that don't know, the original architecture looked like …

I have gotten a couple more of the West 2007 Videos.

• PostgreSQL Partitioning - Robert Treat
• Babel of PLs - David Fetter

PostgreSQL Conference, U.S. is having a PgDay at LinuxFest Northwest in Bellingham Washington on April 25th, 2009. The PgDay (and LinuxFest Northwest) is a free event. We are holding the PgDAY on the first day of the event (a Saturday) parallel with LFNW. There was over 700 attendees to LFNW last year. LFNW is hoping for even more this year! In short, we are looking for some PostgreSQL talks (45 …

As I was working on PostgreSQL Conference this weekend I happen to crawl under my desk to pick up a pin I dropped. As I was crawling back out I smacked my head on the top of the desk and in the process jostled an empty (black) computer case that was sitting there. I noticed something on top of the case so I took a long hard look and behold! …

I have closed the survey, "When to hold it" and provided the results. Of particular interest to me was the majority wanted Late March/Early April but a significant amount were also interested in having the conference in Early June. I am also glad to see that people were not interested in conflicting with Ottawa as I hear it is a very good conference.

Although I don't follow the Perl world very much, my respected peer Matt S. Trout emailed me wondering when I would be able to get the Perl 5 is Alive! video up. Apparently there are some buffoons spreading FUD about the state of this very much alive, very much supported, very much developed, very much kicking language. So take a look at the link above and see for yourself. If …

I have been negotiating (with the help of Bruce and others) with various parties to determine where we are going to hold East 2009. One of the questions that keeps popping up is, "When are we going to hold PostgreSQL Conference East: 2009". Since we now have this nifty new Drupal (with PostgreSQL) driven web site, we should take advantage of the ease of use and ask for some feedback. …

As with any PostgreSQL question, the first place you should look for answer is the PostgreSQL docs. I was recently reviewing the EXPLAIN docs as freshen up on some query tuning fu and I came across this little gem:

EXPLAIN SELECT * FROM tenk1 WHERE unique1 < 100;

                                  QUERY PLAN
------------------------------------------------------------------------------
 Bitmap Heap Scan on tenk1  (cost=2.37..232.35 rows=106 width=244)
   Recheck Cond: (unique1 < 100)
   ->  Bitmap Index Scan on tenk1_unique1  (cost=0.00..2.37 rows=106 width=0)
         Index Cond: (unique1 < 100)

What the above says (per the docs) is :

Here the planner has …

Last March at PostgreSQL Conference: East we video taped almost all the talks. It has taken some time to get them up and we are still encoding (and learning the tricks of the trade) but we do have a few up now that people may enjoy.

• Deploying PostgreSQL on Windows
• The magic of MVCC
• PostgreSQL Interprocess Coordination and Communication
• PostgreSQL Logic and Databases

You can find them at the newly …