pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Table Size
5+ messages / 5 participants
[nested] [flat]

* Table Size
@ 2001-03-05 11:41  Karthikeyan Shanmuganathan <karthikeyan.shan@wipro.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Karthikeyan Shanmuganathan @ 2001-03-05 11:41 UTC (permalink / raw)
  To: pgsql-admin

Dear Sir,

I would like to know how can I find the size of a table in Oracle.

regards,
Karthik.S.





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Table size
@ 2007-06-14 12:40  Shyam Sunder Rai <ssrai@ismartpanache.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Shyam Sunder Rai @ 2007-06-14 12:40 UTC (permalink / raw)
  To: pgsql-admin

Hi,

 

How can I calculate a table size in postgres ? 

 

Help please..

 

 

Regards,

Shyam Sunder Rai

 

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Table size
@ 2007-06-14 13:16  Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
  parent: Shyam Sunder Rai <ssrai@ismartpanache.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Andreas 'ads' Scherbaum @ 2007-06-14 13:16 UTC (permalink / raw)
  To: pgsql-admin


Hello,

On Thu, 14 Jun 2007 18:10:15 +0530 Shyam Sunder Rai wrote:

> How can I calculate a table size in postgres ? 

thats in the docu:

Docu -> The SQL Language -> Functions and Operators ->
System Administration Functions

http://www.postgresql.org/docs/8.2/interactive/functions-admin.html


Kind regards

-- 
				Andreas 'ads' Scherbaum
Failure is not an option. It comes bundled with your Microsoft product.
 (Ferenc Mantfeld)



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Table size
@ 2007-06-14 13:16  Michael Fuhr <mike@fuhr.org>
  parent: Shyam Sunder Rai <ssrai@ismartpanache.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Michael Fuhr @ 2007-06-14 13:16 UTC (permalink / raw)
  To: Shyam Sunder Rai <ssrai@ismartpanache.com>; +Cc: pgsql-admin

On Thu, Jun 14, 2007 at 06:10:15PM +0530, Shyam Sunder Rai wrote:
> How can I calculate a table size in postgres ? 

To find the size of an existing table use pg_relation_size() or
pg_total_relation_size() (8.1 and later; in earlier versions use
the functions in contrib/dbsize).

http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE

Or did you want to estimate the size of a table given the number
and types of its columns and the number of rows?

-- 
Michael Fuhr



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Table size
@ 2007-06-18 22:18  Jim Nasby <decibel@decibel.org>
  parent: Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 5+ messages in thread

From: Jim Nasby @ 2007-06-18 22:18 UTC (permalink / raw)
  To: Michael Fuhr <mike@fuhr.org>; +Cc: Shyam Sunder Rai <ssrai@ismartpanache.com>; pgsql-admin

On Jun 14, 2007, at 8:16 AM, Michael Fuhr wrote:
> On Thu, Jun 14, 2007 at 06:10:15PM +0530, Shyam Sunder Rai wrote:
>> How can I calculate a table size in postgres ?
>
> To find the size of an existing table use pg_relation_size() or
> pg_total_relation_size() (8.1 and later; in earlier versions use
> the functions in contrib/dbsize).

If you don't need an exact size, you can also look at  
pg_class.relpages, which is the size of a relation in pages. The  
relation_size functions actually read the size off the filesystem,  
which seems to be quite a bit slower if you're dealing with more than  
a few files.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)





^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2007-06-18 22:18 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-05 11:41 Table Size Karthikeyan Shanmuganathan <karthikeyan.shan@wipro.com>
2007-06-14 12:40 Table size Shyam Sunder Rai <ssrai@ismartpanache.com>
2007-06-14 13:16 ` Re: Table size Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
2007-06-14 13:16 ` Re: Table size Michael Fuhr <mike@fuhr.org>
2007-06-18 22:18   ` Re: Table size Jim Nasby <decibel@decibel.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox