PDA

View Full Version : PostgreSQL Size



jl001300
11-01-2011, 08:14 PM
My PostgresSQL size shows that it's over 100GB in my control panel. I've deleted my largest database in pgAdmin, but it didn't reduce the size. Is there something I am not doing correctly when deleting the databases? How can I reduce the size?

Patvs
11-02-2011, 01:57 AM
Control Panel--> Programs won't accurately show the size of PostgreSQL.
Check the properties manually, of the C:/Program Files (x86)/PostgreSQL folder.

1 million handhistories take up about 10 GB of disk space.
Also delete the files in the C:/Program Files (x86)/PostgreSQL/8.4/data/pg_log folder.