pgsql: docs: clarify that CREATE TABLE ... _AS_ can be parallelized

2018-05-10 Thread Bruce Momjian
docs: clarify that CREATE TABLE ... _AS_ can be parallelized CREATE TABLE without AS doesn't have anything to parallelize. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/25468994cab87ab7e946b6866937ee642fc1261d Modified Files -- doc/src/sgml/parallel.

pgsql: Last-minute updates for release notes.

2018-05-10 Thread Tom Lane
Last-minute updates for release notes. Security: CVE-2018-1115 Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/1950d5b7a2aa6570dfc170f2fef1e921271d0024 Modified Files -- doc/src/sgml/release-9.6.sgml | 38 +++--- 1

pgsql: adminpack: Revoke EXECUTE on pg_logfile_rotate()

2018-05-10 Thread Stephen Frost
adminpack: Revoke EXECUTE on pg_logfile_rotate() In 9.6, we moved a number of functions over to using the GRANT system to control access instead of having hard-coded superuser checks. As it turns out, adminpack was creating another function in the catalog for one of those backend functions where

pgsql: adminpack: Revoke EXECUTE on pg_logfile_rotate()

2018-05-10 Thread Stephen Frost
adminpack: Revoke EXECUTE on pg_logfile_rotate() In 9.6, we moved a number of functions over to using the GRANT system to control access instead of having hard-coded superuser checks. As it turns out, adminpack was creating another function in the catalog for one of those backend functions where

pgsql: Last-minute updates for release notes.

2018-05-10 Thread Tom Lane
Last-minute updates for release notes. Security: CVE-2018-1115 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/b56d5f230fae5fccf4fb9f255dfa78b01afed0d9 Modified Files -- doc/src/sgml/release-10.sgml | 44 --- doc/

pgsql: Last-minute updates for release notes.

2018-05-10 Thread Tom Lane
Last-minute updates for release notes. Security: CVE-2018-1115 Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/27a65851801c41c66d72d8c55ffab093419da793 Modified Files -- doc/src/sgml/release-10.sgml | 44 -

pgsql: adminpack: Revoke EXECUTE on pg_logfile_rotate()

2018-05-10 Thread Stephen Frost
adminpack: Revoke EXECUTE on pg_logfile_rotate() In 9.6, we moved a number of functions over to using the GRANT system to control access instead of having hard-coded superuser checks. As it turns out, adminpack was creating another function in the catalog for one of those backend functions where

pgsql: Various improvements of skipping index scan during vacuum techni

2018-05-10 Thread Teodor Sigaev
Various improvements of skipping index scan during vacuum technics - Change vacuum_cleanup_index_scale_factor GUC to PGC_USERSET. vacuum_cleanup_index_scale_factor GUC was defined as PGC_SIGHUP. But this GUC affects not only autovacuum. So it might be useful to change it from user session