Re: [DOCS] Might be worth mentioning that temp_tablespaces can contain duplicate values
1 view
Skip to first unread message
Peter Eisentraut
unread,
Aug 3, 2016, 3:14:02 PM8/3/16
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
On 7/5/16 9:43 PM, al...@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