pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
effective_io_concurrency option in ALTER TABLESPACE
2+ messages / 2 participants
[nested] [flat]

* effective_io_concurrency option in ALTER TABLESPACE
@ 2017-01-25 15:49  thusson@informiciel.com
  0 siblings, 1 reply; 2+ messages in thread

From: thusson@informiciel.com @ 2017-01-25 15:49 UTC (permalink / raw)
  To: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/sql-altertablespace.html
Description:

This page:
https://www.postgresql.org/docs/9.6/static/runtime-config-resource.html

Tell about effective_io_concurrency could be changed for a specific
tablespace and refer to this page:
https://www.postgresql.org/docs/9.6/static/sql-altertablespace.html
Who said "Currently, the only available parameters are seq_page_cost and
random_page_cost." and refer to them.

Option "effective_io_concurrency" is missing as I tried the following
command and it worked:
alter tablespace emet_temp set (effective_io_concurrency=50);

Cheers

-- 
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: effective_io_concurrency option in ALTER TABLESPACE
@ 2017-01-27 00:34  Michael Paquier <michael.paquier@gmail.com>
  parent: thusson@informiciel.com
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Paquier @ 2017-01-27 00:34 UTC (permalink / raw)
  To: thusson@informiciel.com; +Cc: pgsql-docs

On Thu, Jan 26, 2017 at 12:49 AM,  <thusson@informiciel.com> wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/sql-altertablespace.html
> Description:
>
> This page:
> https://www.postgresql.org/docs/9.6/static/runtime-config-resource.html
>
> Tell about effective_io_concurrency could be changed for a specific
> tablespace and refer to this page:
> https://www.postgresql.org/docs/9.6/static/sql-altertablespace.html
> Who said &quot;Currently, the only available parameters are seq_page_cost and
> random_page_cost.&quot; and refer to them.
>
> Option &quot;effective_io_concurrency&quot; is missing as I tried the following
> command and it worked:
> alter tablespace emet_temp set (effective_io_concurrency=50);

Thanks for the report, this has been fixed recently by this commit and
will be available with 9.6.2:
commit: 4e344c2cf4ff00ca38ea0035bc137dab95fdd0c0
author: Fujii Masao <fujii@postgresql.org>
date: Sat, 17 Dec 2016 01:25:29 +0900
Add missing documentation for effective_io_concurrency tablespace option.

The description of effective_io_concurrency option was missing in ALTER
TABLESPACE docs though it's included in CREATE TABLESPACE one.
-- 
Michael


-- 
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:[~2017-01-27 00:34 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-01-25 15:49 effective_io_concurrency option in ALTER TABLESPACE thusson@informiciel.com
2017-01-27 00:34 ` Michael Paquier <michael.paquier@gmail.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