Обсуждение: Might be worth mentioning that temp_tablespaces can contain duplicate values
Might be worth mentioning that temp_tablespaces can contain duplicate values
От
alecz@berkeley.edu
Дата:
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/static/runtime-config-client.html Description: The section on temp_tablespaces is here: https://www.postgresql.org/docs/9.5/static/runtime-config-client.html I've tried setting temp_tablespaces with duplicate entries and have found that it keeps those duplicates, making that entry used more frequently. This is useful if the user wants to use one tablespace more frequently than others. Example: "tablespace1, tablespace1, tablespace2" It'll pick tablespace1 about 2X as often as tablespace2. Support for duplicate values isn't explicitly mentioned in the documentation, but I inferred it from the wording about the parameter being a "list." But I had to go test to make sure it would work as I thought.
Re: Might be worth mentioning that temp_tablespaces can contain duplicate values
От
Peter Eisentraut
Дата:
On 7/5/16 9:43 PM, alecz@berkeley.edu wrote: > Page: https://www.postgresql.org/docs/9.5/static/runtime-config-client.html > Description: > > The section on temp_tablespaces is here: > https://www.postgresql.org/docs/9.5/static/runtime-config-client.html > > I've tried setting temp_tablespaces with duplicate entries and have found > that it keeps those duplicates, making that entry used more frequently. This > is useful if the user wants to use one tablespace more frequently than > others. Example: "tablespace1, tablespace1, tablespace2" It'll pick > tablespace1 about 2X as often as tablespace2. > > Support for duplicate values isn't explicitly mentioned in the > documentation, but I inferred it from the wording about the parameter being > a "list." But I had to go test to make sure it would work as I thought. Anyone have concerns about explicitly documenting this behavior? Seems possibly useful to me. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services