Re: Performance implications of numeric? - Mailing list pgsql-general

From Craig Ringer
Subject Re: Performance implications of numeric?
Date
Msg-id 50357912.3010905@ringerc.id.au
Whole thread Raw
In response to Performance implications of numeric?  (Wells Oliver <wellsoliver@gmail.com>)
List 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



pgsql-general by date:

Previous
From: Mike Christensen
Date:
Subject: What text format is this and can I import it into Postgres?
Next
From: Rob Sargent
Date:
Subject: Re: What text format is this and can I import it into Postgres?