What does tuning PostGRES do?

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

What does tuning PostGRES do?

Postby fatbear5090 » Tue Apr 17, 2012 9:04 pm

Just wondering, because I just went into DB and clicked "Housekeeping" and tuned it, took like 3 seconds and idk what it did.
fatbear5090
 
Posts: 12
Joined: Sat Dec 11, 2010 10:09 pm

Re: What does tuning PostGRES do?

Postby sym25 » Wed Apr 18, 2012 1:56 am

+1 for me
sym25
 
Posts: 208
Joined: Wed Nov 26, 2008 3:38 am

Re: What does tuning PostGRES do?

Postby WhiteRider » Wed Apr 18, 2012 5:16 am

It changes some of the settings in your PostgreSQL configuration to optimize performance based on your hardware.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: What does tuning PostGRES do?

Postby socorrista5 » Wed Apr 18, 2012 5:56 am

So, may be it recognizes the amount of RAM we have and configures a bigger RAM usage according to what developers consider the best option???
Things like that??? More than just RAM?
socorrista5
 
Posts: 142
Joined: Mon May 24, 2010 7:56 am

Re: What does tuning PostGRES do?

Postby kraada » Wed Apr 18, 2012 8:41 am

Amount of RAM is the key factor here - the PostgreSQL defaults were created over a decade ago and as such are not really best set for modern machines.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: What does tuning PostGRES do?

Postby Fox128 » Wed Apr 18, 2012 8:49 am

This is what it did for me:

2012/04/18 14:13:41.484 [00005]: [0000232C][PostgresTuner] Tuning local postgres server on port ****
2012/04/18 14:13:41.530 [00046]: [0000232C][PostgresTuner] Profile: 2GB
2012/04/18 14:13:41.530 [00000]: [0000232C][PostgresTuner] Changing 'shared_buffers' from '32MB' to '512MB'
2012/04/18 14:13:41.530 [00000]: [0000232C][PostgresTuner] Changing 'temp_buffers' from '8MB' to '8MB'
2012/04/18 14:13:41.531 [00000]: [0000232C][PostgresTuner] Changing 'work_mem' from '1MB' to '64MB'
2012/04/18 14:13:41.531 [00000]: [0000232C][PostgresTuner] Changing 'wal_buffers' from '64kB' to '512kB'
2012/04/18 14:13:41.531 [00000]: [0000232C][PostgresTuner] Changing 'maintenance_work_mem' from '16MB' to '256MB'
2012/04/18 14:13:41.531 [00000]: [0000232C][PostgresTuner] Changing 'effective_cache_size' from '128MB' to '1GB'
2012/04/18 14:13:41.532 [00000]: [0000232C][PostgresTuner] Changing 'autovacuum' from 'on' to 'on'
2012/04/18 14:13:41.532 [00000]: [0000232C][PostgresTuner] Changing 'checkpoint_segments' from '3' to '32'
2012/04/18 14:13:41.532 [00000]: [0000232C][PostgresTuner] Changing 'random_page_cost' from '4.0' to '3.0'
2012/04/18 14:13:41.532 [00000]: [0000232C][PostgresTuner] Stopping the postgres service
2012/04/18 14:13:42.621 [01089]: [0000232C][PostgresTuner] Starting the postgres service
2012/04/18 14:13:49.836 [07214]: [0000232C][PostgresTuner] Tuning complete
Fox128
 
Posts: 56
Joined: Sun Mar 09, 2008 1:27 pm

Re: What does tuning PostGRES do?

Postby sym25 » Wed Apr 18, 2012 9:13 am

if i understand correct you have 2Gb RAM?
I have 4Gb, but have the same values like you.
If tunning with 'guide for tunning postgreSQL' values must multiplied by 2.
What is better?
sym25
 
Posts: 208
Joined: Wed Nov 26, 2008 3:38 am

Re: What does tuning PostGRES do?

Postby tarix » Wed Apr 18, 2012 9:47 am

sym25 wrote:if i understand correct you have 2Gb RAM?
I have 4Gb, but have the same values like you.


You probably have too much memory being taken by on-board video so that you actually have closer to 3.5GB. It is also possible that you are running Windows XP which can only access 3GB. We only will activate the 4GB profile if Windows has a full 4GB of memory available.
tarix
Developer
 
Posts: 3760
Joined: Tue May 20, 2008 2:49 pm

Re: What does tuning PostGRES do?

Postby kraada » Wed Apr 18, 2012 9:55 am

Also keep in mind that the 2G profile is still going to be better for you than the PostgreSQL defaults if you have 3G of RAM.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: What does tuning PostGRES do?

Postby Fox128 » Wed Apr 18, 2012 10:46 am

sym25 wrote:if i understand correct you have 2Gb RAM?
I have 4Gb, but have the same values like you.
If tunning with 'guide for tunning postgreSQL' values must multiplied by 2.
What is better?

Nope I have 4GB too actually.
Fox128
 
Posts: 56
Joined: Sun Mar 09, 2008 1:27 pm

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 0 guests