PDA

View Full Version : PostgreSQL taking too much space



erikmvs
03-18-2013, 08:47 PM
Something was wrong with my pc because it was almost running out of free disk space...

So I went to look through the files to see what is taking so much space of it.

Then I discovered that in Program Files, the File "PostgreSQL" was taking 193 GB. Yeah you didn't read it wrongly... its almost 200 GB!!!!

Then I followed this steps
PostgreSQL > 8.3 > data (with 193 GB) > base (170 GB) > 81163 ( 142 GB) and the file 36136 (20 GB)

So how can I make Postgre use less space of my disk? In the file "81163" there are lots of archives there...

Patvs
03-18-2013, 09:11 PM
How many hands are in your database?
Do you have multiple databases? (including old databases, you don't use anymore)

1 million hands =
HM1: 6.8 GB
HM2: 4.3 GB
PT4: 13.6 GB

So with a 10 million hand database you need as SSD of at least 60 GB (Windows) + 100 GB = 160 GB.
We use 1 million = 10 GB (instead of 6.8) because when you want to perform a vacuum/analyse or backup/restore a database it will require a LOT of disk space to perform such a task.



To get disk space back, run a vacuum/analyse/reindex in pgadminIII.