pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDetermine/Calculate table size
3+ messages / 3 participants
[nested] [flat]
* Determine/Calculate table size
@ 2007-06-27 16:32 Nathaniel Banks Jr. <nbanks@impulsemg.com>
2007-06-27 17:23 ` Re: Determine/Calculate table size Vishal Arora <aroravishal22@hotmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Nathaniel Banks Jr. @ 2007-06-27 16:32 UTC (permalink / raw)
To: pgsql-admin
Hello Gurus,
I'm fairly new to Postgres and I was wondering what command/sql query
will give me a list of each table in a schema with it's size? I've
searched around and I haven't been able to find...I'm on postgres 7.3 by
the way
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Determine/Calculate table size
2007-06-27 16:32 Determine/Calculate table size Nathaniel Banks Jr. <nbanks@impulsemg.com>
@ 2007-06-27 17:23 ` Vishal Arora <aroravishal22@hotmail.com>
2007-06-28 06:06 ` Re: Determine/Calculate table size Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
0 siblings, 1 reply; 3+ messages in thread
From: Vishal Arora @ 2007-06-27 17:23 UTC (permalink / raw)
To: nbanks@impulsemg.com; pgsql-admin
you can try for your reference
http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE
in earlier versions use the functions in contrib/dbsize.
- Vishal
>From: "Nathaniel Banks Jr." <nbanks@impulsemg.com>
>To: <pgsql-admin@postgresql.org>
>Subject: [ADMIN] Determine/Calculate table size
>Date: Wed, 27 Jun 2007 12:32:08 -0400
>
>Hello Gurus,
>
>I'm fairly new to Postgres and I was wondering what command/sql query
>will give me a list of each table in a schema with it's size? I've
>searched around and I haven't been able to find...I'm on postgres 7.3 by
>the way
>
>
>
>
>
_________________________________________________________________
Like puzzles? Play free games & earn great prizes. Play Clink now.
http://club.live.com/clink.aspx?icid=clink_hotmailtextlink2
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Determine/Calculate table size
2007-06-27 16:32 Determine/Calculate table size Nathaniel Banks Jr. <nbanks@impulsemg.com>
2007-06-27 17:23 ` Re: Determine/Calculate table size Vishal Arora <aroravishal22@hotmail.com>
@ 2007-06-28 06:06 ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jayakumar_Mukundaraju @ 2007-06-28 06:06 UTC (permalink / raw)
To: Vishal Arora <aroravishal22@hotmail.com>; nbanks@impulsemg.com; pgsql-admin
Hi Vishal,
I need a help.. How to set the job scheduler in postgres windows box..
Thanks & Regards
Jayakumar M
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal Arora
Sent: Wednesday, June 27, 2007 10:54 PM
To: nbanks@impulsemg.com; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Determine/Calculate table size
you can try for your reference
http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNC
TIONS-ADMIN-DBSIZE
in earlier versions use the functions in contrib/dbsize.
- Vishal
>From: "Nathaniel Banks Jr." <nbanks@impulsemg.com>
>To: <pgsql-admin@postgresql.org>
>Subject: [ADMIN] Determine/Calculate table size
>Date: Wed, 27 Jun 2007 12:32:08 -0400
>
>Hello Gurus,
>
>I'm fairly new to Postgres and I was wondering what command/sql query
>will give me a list of each table in a schema with it's size? I've
>searched around and I haven't been able to find...I'm on postgres 7.3
by
>the way
>
>
>
>
>
_________________________________________________________________
Like puzzles? Play free games & earn great prizes. Play Clink now.
http://club.live.com/clink.aspx?icid=clink_hotmailtextlink2
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-06-28 06:06 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-27 16:32 Determine/Calculate table size Nathaniel Banks Jr. <nbanks@impulsemg.com>
2007-06-27 17:23 ` Vishal Arora <aroravishal22@hotmail.com>
2007-06-28 06:06 ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
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