Josh Berkus <j...@agliodbs.com> wrote: > Wanna go to Collab?
I don't think that works out for me, but thanks for suggesting it. I'd be happy to brainstorm with anyone who does go about issues to discuss; although the ones I keep running into have already been mentioned. Regarding the problems others have mentioned, there are a few features that might be a very big plus for us. Additional ways of hinting pages might be very useful. If we had a way to specify how many dirty pages were cached in PostgreSQL, the OS would count those for calculations for writing dirty pages, and we could avoid the "write avalanche" which is currently so tricky to avoid without causing repeated writes to the same page. Or perhaps instead a way to hint a page as dirty so that the OS could not only count those, but discard the obsolete data from its cache if it is not already dirty at the OS level, and lower the write priority if it is dirty (to improve the odds of collapsing multiple writes). If there was a way to use DONTNEED or something similar with the ability to rescind it if the page was still happened to be in the OS cache, that might help for when we discard a still-clean page from our buffers. And I seem to have a vague memory of there being cases where the OS is first reading pages when we ask to write them, which seems like avoidable I/O. (I'm not sure about that one, though.) Also, something like THP support should really have sysctl support rather than requiring people to put echo commands into scripts and tie those into runlevel changes. That's pretty ugly for something which has turned out to be necessary so often. I don't get too excited about changes to the default schedulers -- it's been pretty widely known for a long time that DEADLINE or NOOP perform better than any alternatives for most database loads. Anyone with a job setting up Linux machines to be used for database servers should know to cover that. As long as those two don't get broken, I'm good. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers