Обсуждение: Determine/Calculate table size
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
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
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 materialthat is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distributionor forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intendedrecipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.