Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.
by mcronix » Thu Sep 18, 2008 11:43 pm
Hey
So I have a rapidly growing Postgres DB (about 1.5million hands) which I believe is stored in 1gb chunks by poker tracker?
Anyways, I've been defragging my hard drive recently and the only files that don't defrag are the DB ones which leaves the defrag status window very messy. I assume this will affect PC performance as usual fragmentation does? Is there a way to sort this or am I concerned about nothing?
Thanks in advance
-
mcronix
-
- Posts: 1
- Joined: Thu Sep 18, 2008 11:27 pm
by ptrack pat » Fri Sep 19, 2008 8:32 am
which I believe is stored in 1gb chunks by poker tracker?
PT doesn't have anything to do with how PostgreSQL stores the files. I'm not sure why these wouldn't defrag, I'm not knowledgeable with the inner workings of PostgreSQL.
-
ptrack pat
-
- Posts: 4841
- Joined: Sun Dec 09, 2007 12:38 pm
by WhiteRider » Fri Sep 19, 2008 1:21 pm
In the PT3 forums it has been suggested that you need to stop the postgres service (Start -> Programs -> Postgres -> Stop Service) before defragging, and maybe even rebooting in Safe Mode. Or failing that, there are applications that will manage the defrag for you, but I can't remember what they are.
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
Return to PostgreSQL Forum
Users browsing this forum: No registered users and 1 guest