PDA

View Full Version : Database >60Gig



N0talent
10-27-2009, 08:46 AM
Hi

I import alot of hands daily from 3 sites I play at. now my Database is growing extremly fast and is now over 62Gig. Is there a way to "clean" it up and delete hands older than a month? I used the purge funktion (and afterwards vakuumed my Database) but that only made my DB 3Gig smaller. Do I have to start a new DB if I want it to be small agian? would appiciate some help! :)

netsrak
10-27-2009, 08:54 AM
Check the postgresql subfolder data\pg_log. You can delete all files in there.
Did you do a vacuum/full or only a vacuum? Should be full...
Try a reindex at the same position too.

A defragmentation of the harddisk with not running postgresql service will help too.

See the top 10 performance tips from the link in my signature too.

N0talent
10-27-2009, 09:20 AM
Check the postgresql subfolder data\pg_log. You can delete all files in there.
what are these files? will I loose any HH?



Did you do a vacuum/full or only a vacuum? Should be full...
Try a reindex at the same position too.
Full. Ill try out reindex.



A defragmentation of the harddisk with not running postgresql service will help too.

See the top 10 performance tips from the link in my signature too.
thanks :) How much space do you think I can save?

dtkodak123
10-27-2009, 09:40 AM
stop datamining while u sleep every night.. =D

N0talent
10-27-2009, 10:57 AM
stop datamining while u sleep every night.. =D

lol...start burning money dtkodak :P

dtkodak123
10-27-2009, 12:10 PM
nah, i do it enuff while im awake. dont need to as i sleep.