Search Postgresql Archives

Re: Performance implications of numeric?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux