Re: [GENERAL] Installation Size showing huge size in postgres installed on windows os

2015-03-19 Thread 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



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Installation Size showing huge size in postgres installed on windows os

2015-03-19 Thread Alban Hertroys
On 19 March 2015 at 13:44, Raymond O'Donnell  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.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Installation Size showing huge size in postgres installed on windows os

2015-03-19 Thread 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
r...@iol.ie


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Installation Size showing huge size in postgres installed on windows os

2015-03-19 Thread jaime soler
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.
> 
> 




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general