Обсуждение: Installation Size showing huge size in postgres installed on windows os
I have installed Postgres 9.0 in my machine. When I look at Programs and Features under Control Panel, I see the Size for Postgres 9.0 is shown as 121GB. I feel neither the installation or the small postgres databases I would have created use 121GB. Any reason why it shows 121GB Regards NS Rajagopla -- View this message in context: http://postgresql.nabble.com/Installation-Size-showing-huge-size-in-postgres-installed-on-windows-os-tp5842522.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
El mié, 18-03-2015 a las 23:05 -0700, Rajagopal NS escribió: > I have installed Postgres 9.0 in my machine. When I look at Programs and > Features under Control Panel, > I see the Size for Postgres 9.0 is shown as 121GB. > > I feel neither the installation or the small postgres databases I would have > created use 121GB. > > Any reason why it shows 121GB Could you share with us \l+ command in psql session ? > > Regards > NS Rajagopla > > > > -- > View this message in context: http://postgresql.nabble.com/Installation-Size-showing-huge-size-in-postgres-installed-on-windows-os-tp5842522.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > >
Re: Installation Size showing huge size in postgres installed on windows os
От
Raymond O'Donnell
Дата:
On 19/03/2015 12:39, jaime soler wrote: > El mié, 18-03-2015 a las 23:05 -0700, Rajagopal NS escribió: >> I have installed Postgres 9.0 in my machine. When I look at Programs and >> Features under Control Panel, >> I see the Size for Postgres 9.0 is shown as 121GB. >> >> I feel neither the installation or the small postgres databases I would have >> created use 121GB. >> >> Any reason why it shows 121GB > > Could you share with us \l+ command in psql session ? Also, see what Windows reports as the space taken up by the installation and data directories. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
On 19 March 2015 at 13:44, Raymond O'Donnell <rod@iol.ie> wrote: > On 19/03/2015 12:39, jaime soler wrote: >> El mié, 18-03-2015 a las 23:05 -0700, Rajagopal NS escribió: >>> I have installed Postgres 9.0 in my machine. When I look at Programs and >>> Features under Control Panel, >>> I see the Size for Postgres 9.0 is shown as 121GB. >>> >>> I feel neither the installation or the small postgres databases I would have >>> created use 121GB. For what it's worth, I've seen the wildest claims about installation sizes in that panel. Mostly the installation size is severely underestimated, but overestimates happen too - haven't seen anything this bad though. I stopped trusting those numbers quite a while ago. The reliable method is to check the directory size of your catalog directories and the Postgres installation directory yourself. -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest.
Re: Installation Size showing huge size in postgres installed on windows os
От
jaime soler gómez
Дата:
El mié, 18-03-2015 a las 23:05 -0700, Rajagopal NS escribió: > I have installed Postgres 9.0 in my machine. When I look at Programs and > Features under Control Panel, > I see the Size for Postgres 9.0 is shown as 121GB. > > I feel neither the installation or the small postgres databases I would have > created use 121GB. > > Any reason why it shows 121GB Could you share with us \l+ command in psql session ? > > Regards > NS Rajagopla > > > > -- > View this message in context: http://postgresql.nabble.com/Installation-Size-showing-huge-size-in-postgres-installed-on-windows-os-tp5842522.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > -- Jaime Soler Gómez HOPLA Software EnterpriseDB exclusive distributor ES/PT/IT & LatAm