Timeline for tuning postgresql for large amounts of ram
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 29, 2020 at 14:29 | comment | added | Mikko Rantalainen |
If your system feels slow, run EXPLAIN instead of guessing if more RAM could help. For example, see dba.stackexchange.com/a/226481/29183
|
|
| Nov 15, 2017 at 15:52 | comment | added | mountainclimber11 | related question, maybe of interest: stackoverflow.com/questions/47311485/… | |
| Jan 13, 2017 at 11:09 | comment | added | Sajeev | See this link: tekadempiere.blogspot.ae/2014/09/… And find your resource based conf values from here: pgtune.leopard.in.ua | |
| Jun 4, 2012 at 2:15 | history | tweeted | twitter.com/#!/StackDBAs/status/209468364781920256 | ||
| Jun 1, 2012 at 22:34 | comment | added | dbenhur | Postgres doesn't "use ram" the way you speak of it. It relies on the OS file system page cache for the bulk of its caching, so when you watch ram usage on a system running postgres you typically see many GBs in use by OS buffers/cache, and individual postgres backend processes using only a few to a few tens of MBs each. | |
| May 31, 2012 at 22:07 | answer | added | Tometzky | timeline score: 3 | |
| May 29, 2012 at 16:35 | answer | added | Scott Marlowe | timeline score: 2 | |
| May 29, 2012 at 6:44 | history | migrated | from stackoverflow.com (revisions) | ||
| May 29, 2012 at 4:53 | comment | added | Scott Marlowe | You're really not giving us enough to help a lot. Other than "It's slow" we don't know much about your dataset, how you're accessing it, what types of queries are generally running slowly, what you've already done to tune (and possibly mis-tune) your server. Heck, on a linux machine with lots of cores and memory channels, you can get crappy performance long before you've installed postgresql. Are you CPU or IO bound? What non-default settings do you have already? What kinds of queries are slow? | |
| May 28, 2012 at 21:49 | answer | added | wildplasser | timeline score: 48 | |
| May 28, 2012 at 21:15 | answer | added | Paul Bellora | timeline score: 20 | |
| May 28, 2012 at 21:12 | comment | added | wildplasser |
Did you change anything to the initial tuning? Step1: SET effective_cache_size=18G; (the default setting is extremely low) BTW: assuming this is a 64 bit machine (no PTE)
|
|
| May 28, 2012 at 21:01 | history | asked | user85116 | CC BY-SA 3.0 |