Thread: database size
how can I get the size of my database and table size in MB?
See contrib/dbsize in the source archive, or it should be installed if you installed the contrib RPM (assuming Linux). Lee. philip johnson writes: > how can I get the size of my database > and table size in MB? > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
sorry forgot to say that I'm using source file to generate postgresql 7.2.1 I've search in contrib and I can't find it -----Message d'origine----- De : pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]De la part de Lee Kindness Envoye : mercredi 19 juin 2002 16:04 A : philip johnson Cc : pgsql-general@postgresql.org; Lee Kindness Objet : [GENERAL] database size See contrib/dbsize in the source archive, or it should be installed if you installed the contrib RPM (assuming Linux). Lee. philip johnson writes: > how can I get the size of my database > and table size in MB? > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
See: contrib/dbsize/README.dbsize in the source archive. Lee. philip johnson writes: > sorry forgot to say that I'm using source file to generate postgresql 7.2.1 > I've search in contrib and I can't find it > > -----Message d'origine----- > De : pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org]De la part de Lee Kindness > Envoye : mercredi 19 juin 2002 16:04 > A : philip johnson > Cc : pgsql-general@postgresql.org; Lee Kindness > Objet : [GENERAL] database size > > See contrib/dbsize in the source archive, or it should be installed if > you installed the contrib RPM (assuming Linux). > > Lee. > > philip johnson writes: > > how can I get the size of my database > > and table size in MB?
I've extracted the file postgresql-7.2.1.tar.gz and I can't find the dbsize directory -----Message d'origine----- De : Lee Kindness [mailto:lkindness@csl.co.uk] Envoye : mercredi 19 juin 2002 18:12 A : philip johnson Cc : Lee Kindness; pgsql-general@postgresql.org Objet : RE: [GENERAL] database size See: contrib/dbsize/README.dbsize in the source archive. Lee. philip johnson writes: > sorry forgot to say that I'm using source file to generate postgresql 7.2.1 > I've search in contrib and I can't find it > > -----Message d'origine----- > De : pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org]De la part de Lee Kindness > Envoye : mercredi 19 juin 2002 16:04 > A : philip johnson > Cc : pgsql-general@postgresql.org; Lee Kindness > Objet : [GENERAL] database size > > See contrib/dbsize in the source archive, or it should be installed if > you installed the contrib RPM (assuming Linux). > > Lee. > > philip johnson writes: > > how can I get the size of my database > > and table size in MB?
someone could answer to my question ? -----Message d'origine----- De : pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]De la part de philip johnson Envoye : mercredi 19 juin 2002 18:57 A : Lee Kindness Cc : pgsql-general@postgresql.org Objet : Re: [GENERAL] database size Importance : Haute I've extracted the file postgresql-7.2.1.tar.gz and I can't find the dbsize directory -----Message d'origine----- De : Lee Kindness [mailto:lkindness@csl.co.uk] Envoye : mercredi 19 juin 2002 18:12 A : philip johnson Cc : Lee Kindness; pgsql-general@postgresql.org Objet : RE: [GENERAL] database size See: contrib/dbsize/README.dbsize in the source archive. Lee. philip johnson writes: > sorry forgot to say that I'm using source file to generate postgresql 7.2.1 > I've search in contrib and I can't find it > > -----Message d'origine----- > De : pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org]De la part de Lee Kindness > Envoye : mercredi 19 juin 2002 16:04 > A : philip johnson > Cc : pgsql-general@postgresql.org; Lee Kindness > Objet : [GENERAL] database size > > See contrib/dbsize in the source archive, or it should be installed if > you installed the contrib RPM (assuming Linux). > > Lee. > > philip johnson writes: > > how can I get the size of my database > > and table size in MB? ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
philip johnson wrote: > someone could answer to my question ? > In /contrib/dbsize. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From the looks of it, it's not in any of the releases. You should be able to get it out of CVS though. It appears to have been added very recently (May 20th). -Fran philip johnson wrote: >someone could answer to my question ? > >-----Message d'origine----- >De : pgsql-general-owner@postgresql.org >[mailto:pgsql-general-owner@postgresql.org]De la part de philip johnson >Envoye : mercredi 19 juin 2002 18:57 >A : Lee Kindness >Cc : pgsql-general@postgresql.org >Objet : Re: [GENERAL] database size >Importance : Haute > > >I've extracted the file postgresql-7.2.1.tar.gz and I can't find the >dbsize directory > >-----Message d'origine----- >De : Lee Kindness [mailto:lkindness@csl.co.uk] >Envoye : mercredi 19 juin 2002 18:12 >A : philip johnson >Cc : Lee Kindness; pgsql-general@postgresql.org >Objet : RE: [GENERAL] database size > > >See: > > contrib/dbsize/README.dbsize > >in the source archive. > >Lee. > >philip johnson writes: > > sorry forgot to say that I'm using source file to generate postgresql >7.2.1 > > I've search in contrib and I can't find it > > > > -----Message d'origine----- > > De : pgsql-general-owner@postgresql.org > > [mailto:pgsql-general-owner@postgresql.org]De la part de Lee Kindness > > Envoye : mercredi 19 juin 2002 16:04 > > A : philip johnson > > Cc : pgsql-general@postgresql.org; Lee Kindness > > Objet : [GENERAL] database size > > > > See contrib/dbsize in the source archive, or it should be installed if > > you installed the contrib RPM (assuming Linux). > > > > Lee. > > > > philip johnson writes: > > > how can I get the size of my database > > > and table size in MB? > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > >
On Thu, Jun 20, 2002 at 01:25:10PM -0400, Bruce Momjian wrote: > philip johnson wrote: > > someone could answer to my question ? > > > > In /contrib/dbsize. Hmm. It's not in the 7.2.1 tarball that I downloaded, either. A -- ---- Andrew Sullivan 87 Mowat Avenue Liberty RMS Toronto, Ontario Canada <andrew@libertyrms.info> M6K 3E3 +1 416 646 3304 x110
Fran Fabrizio wrote: > > From the looks of it, it's not in any of the releases. You should be > able to get it out of CVS though. It appears to have been added very > recently (May 20th). Oh, sorry, I didn't realize that wasn't in 7.2. Also, I have added documentation on computing disk space, again for 7.3: http://developer.postgresql.org/docs/postgres/diskusage.html -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026