Housekeeping cluster

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Re: Housekeeping cluster

Postby ThePkayer » Thu Jan 29, 2009 3:07 am

Its done :D 11½ hours

How must space do I need availible on my hard drive to cluster 5.000k hands?
ThePkayer
 
Posts: 19
Joined: Sun Feb 10, 2008 12:52 pm

Re: Housekeeping cluster

Postby kraada » Thu Jan 29, 2009 11:56 am

In Beta 24 you need twice as much free space as the size of your database. If you only have one database, check the size of your C:\Program Files\PostgreSQL\ directory, and you'd need twice that free.

This is why a lot of people who datamine have separate datamining databases and create new ones every couple of months, that way they don't get nearly that large.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Housekeeping cluster

Postby ThePkayer » Fri Jan 30, 2009 4:30 am

Ok thanks for the answer.

I started to import and then cluster on a different computer with more space availible. Now I need to delete the same hands on my laptop. Is this correct, so I only delete the hands I datamined and still keep my own played hands:
Database -> Purge -> Advanced -> Observed only (with my name), only pokerstars -> Purge sessions

Tx
ThePkayer
 
Posts: 19
Joined: Sun Feb 10, 2008 12:52 pm

Re: Housekeeping cluster

Postby kraada » Fri Jan 30, 2009 10:50 am

That should work.

For a large database, expect it to take a while to complete, so do be patient.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Housekeeping cluster

Postby ThePkayer » Fri Jan 30, 2009 3:37 pm

I started the purging and it has calculated the estimated time: 1807:39:58 ~ 75 days.

Is it possible to extract the sessions I played (maybe by a seperate postgresql function, a search for my username in the hands historys) and then remove PT3 and postgresql for a clean start. The alternativ is unfortunaly to remove pt3, for a reinstall and then lose all my played sessions.
ThePkayer
 
Posts: 19
Joined: Sun Feb 10, 2008 12:52 pm

Re: Housekeeping cluster

Postby kraada » Fri Jan 30, 2009 3:46 pm

If you're comfortable running queries from the command line, you can find the query to pull hand histories out of the database directly in this thread.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Housekeeping cluster

Postby ThePkayer » Fri Jan 30, 2009 4:01 pm

I will look into it :) thx
ThePkayer
 
Posts: 19
Joined: Sun Feb 10, 2008 12:52 pm

Previous

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 10 guests

cron
highfalutin