pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedMight be worth mentioning that temp_tablespaces can contain duplicate values
2+ messages / 2 participants
[nested] [flat]
* Might be worth mentioning that temp_tablespaces can contain duplicate values
@ 2016-07-06 01:43 alecz@berkeley.edu
0 siblings, 1 reply; 2+ messages in thread
From: alecz@berkeley.edu @ 2016-07-06 01:43 UTC (permalink / raw)
To: pgsql-docs
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.
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Might be worth mentioning that temp_tablespaces can contain duplicate values
@ 2016-08-03 19:13 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
parent: alecz@berkeley.edu
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2016-08-03 19:13 UTC (permalink / raw)
To: pgsql-docs; +Cc: alecz@berkeley.edu
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
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-08-03 19:13 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-07-06 01:43 Might be worth mentioning that temp_tablespaces can contain duplicate values alecz@berkeley.edu
2016-08-03 19:13 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox