| From: | Ed Loehr <ed(at)LoehrTech(dot)com> |
|---|---|
| To: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, Neil Conway <neilc(at)samurai(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: dbsize patch |
| Date: | 2005-01-28 17:30:20 |
| Message-ID: | 200501281030.20968.ed@LoehrTech.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| dbsize.diff | text/x-diff | 9.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2005-01-29 03:09:19 | more fixes for making contrib null safe |
| Previous Message | Robert Treat | 2005-01-28 15:11:34 | Re: Continue transactions after errors in psql |