PDA

View Full Version : Vacuum analyze reindex



Shloogy
11-23-2009, 08:27 AM
1. Whats the difference between them?

Also, what Full, Free, Analyze stands for ? (under Vacuum options)

2. What should I do in order to get max performance?

3. Deleting observed hands - does it have impact on import speed etc ?

4. Why do we have to do all the maintenance from pgadmin?


Thanks guys

netsrak
11-23-2009, 10:20 AM
1.For a detailled explanation of the options you should use the Help button in the pgadmin window.

In general it frees harddisk space and optimizes the read access to the data.

2. Please see the performance tips from the link in my signature.

3. You should delete them regularly and then do the maintance steps from above to increase import speed.

4. At the moment we have no HM interface for this tasks.

Shloogy
11-23-2009, 11:19 AM
thanks.
Purging means I wont be able to review hands via HM player?

netsrak
11-23-2009, 12:46 PM
Yes thats the main thing. The hands are deleted from the database, the stats remain there for the Hud display. I recommend you only purge mined hands not your own.

Shloogy
11-24-2009, 09:42 AM
I have made the following steps but it seems like it has no effect on my import speed:

1. Deleted all observed hands
2. Vacuum - Full via pgadmin
3. Reindex


My machine is pretty fast and when I import on a completely new db the import is 200 hands\second.
Now its 26 hands\second.

Patvs
11-24-2009, 09:52 AM
Most performance tips will decrease the size of your database, and increase performance while using HoldemManager.

They have no direct effect on import speeds. Except for: defragging your harddisk. And editing the postgreSQL.conf file can improve all SQL performance.

It's normal the import speeds drastically decrease when importing to a large database (that's why you should VACUUM/PURGE to keep your database small). Also importing many small .txt files is a lot faster than importing 1+ MB .txt files.

Shloogy
11-26-2009, 07:18 PM
And editing the postgreSQL.conf

can you provide with a link how to edit the config to improve performance ?

Thanks

Patvs
11-26-2009, 08:28 PM
http://www.revsys.com/writings/postgresql-performance.html