Postgresql tuning in Mac OS

[KobeBryantLA]

Hello,

I have a Mac Mini Late 2012 with 16 GB RAM, PT4 running in Mac OS and a huge 150 GB Database. As you can imagine it works very slow with the default settings. What changes in config files do you recommend to increase the performance? Is there any FAQ for this?

[kraada]

Our database tuning should work for OS X as well - you can access it via the Housekeeping button in the Database Management window - it should take care of everything you need.

[KobeBryantLA]

Our database tuning should work for OS X as well - you can access it via the Housekeeping button in the Database Management window - it should take care of everything you need.

I used it Windows, but in Mac OS there is no such button in Database Management window.

[kraada]

I'll ask our Mac guy tomorrow what he recommends for you.

[KobeBryantLA]

I'll ask our Mac guy tomorrow what he recommends for you.

Any news?

[kraada]

Use the numbers listed here -- you'll have to make the changes manually though. To do this, open Applications -> Utilities -> Terminal and type:
sudo nano /Library/PostgreSQL/9.0/data/postgresql.conf

After making the changes, ctrl+x exits the program (save the changes when prompted) and reboot your machine and that should do it.

[KobeBryantLA]

I set parameters like this

Code: Select all

shared_buffers = 2048MB   
work_mem = 256MB
maintenance_work_mem = 1024MB   

Changed sysctl.conf to

Code: Select all

kern.sysv.shmall=537466   
kern.sysv.shmmax=2201460736
kern.sysv.shmmin=1
kern.sysv.shmmni=256
kern.sysv.shmseg=64

But still have bad performance.
Any thoughts?

[kraada]

Purging is one of our slowest operations. How are import speeds for you? If you're purging enough data it may actually be faster to export what you want and reimport the data you want to keep into a new database.

[KobeBryantLA]

Purging is one of our slowest operations. How are import speeds for you? If you're purging enough data it may actually be faster to export what you want and reimport the data you want to keep into a new database.

Thanks for advise. Speed is about 82 h/s.

[WhiteRider]

That sounds reasonable.