Re: dbsize patch - Mailing list pgsql-patches

From Ed Loehr
Subject Re: dbsize patch
Date
Msg-id 200501281030.20968.ed@LoehrTech.com
Whole thread Raw
In response to Re: dbsize patch  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: dbsize patch
List pgsql-patches
If the C code for the prior dbsize patch is not acceptable for whatever
reason, here's a SQL-based patch to replace it.  It's not a drop-in for
7.3/7.4 as I'd hoped, only an 8.1 patch.  I believe it is functionally
equivalent to the C patch, but simpler, shorter, and probably a tad slower.
I also removed the README section on how to aggregate since it was
incomplete/incorrect (it didn't count toasted indices) and added a SQL
function that itemizes the size for a relation's table and index data
(helpful to us in identifying bloat, measuring performance, capacity
estimation, etc).

Ed

Attachment

pgsql-patches by date:

Previous
From: Ed Loehr
Date:
Subject: Re: dbsize patch
Next
From: Alvaro Herrera
Date:
Subject: Re: Continue transactions after errors in psql