| From: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
|---|---|
| To: | Wells Oliver <wellsoliver(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Performance implications of numeric? |
| Date: | 2012-08-23 00:28:02 |
| Message-ID: | 50357912.3010905@ringerc.id.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 08/23/2012 12:48 AM, Wells Oliver wrote:
> Hey, thanks for your feedback. Just to clarify: pg_total_relation_size
> returns bytes, correct?
Please reply to the list, not directly to me.
Yes, pg_total_relation_size returns bytes. The documentation
(http://www.postgresql.org/docs/9.1/static/functions-admin.html) doesn't
seem to explicitly say that for pg_total_relation_size though it does
for pg_relation_size and other functions.
Use pg_size_pretty to convert bytes to "human" values for display.
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edson Richter | 2012-08-23 00:33:06 | Re: What text format is this and can I import it into Postgres? |
| Previous Message | Mike Christensen | 2012-08-23 00:23:09 | What text format is this and can I import it into Postgres? |