Peter Eisentraut wrote:
Heikki Linnakangas wrote:
Here's an update of Simon's Heap Page Diagnostic Functions. I now
consider it ready to commit.

How is this better than pg_filedump?

It's handy to be able to inspect pages from within a live database. The new functions work through shared_buffers, so you can see changes without having to issue a checkpoint to flush them to disk. pg_filedump takes a filename as argument, the new function takes relation name.

Having them as functions also allows you to do more advanced queries like "... WHERE (t_infomask & 1) <> 0 " to show tuples with a null bitmap.

"diagnostics" is an awfully general name, too.

We already played the name game on hackers. My original suggestion was "pgforensics". "pgdiagfuncs" and "pginspect" were also suggested, among others. I'm still open to suggestions, though. Have any?

  Heikki Linnakangas

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not

Reply via email to