Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-07 Thread Thomas Munro
On Tue, May 7, 2019 at 11:02 AM Bruce Momjian wrote: > https://git.postgresql.org/pg/commitdiff/bdf595adbca195fa54a909c74a5233ebc30641a1 > +Use pread() and pwrite() for random I/O (Thomas Munro) Hi Bruce, For this one, can we please add Oskari Saarenmaa as first author, and keep me as second?

pgsql: doc: Generate keywords table automatically

2019-05-07 Thread Peter Eisentraut
doc: Generate keywords table automatically The SQL keywords table in the documentation had until now been generated by some ad hoc scripting outside the source tree once for each major release. This changes it to an automated process. We have the PostgreSQL keywords available in a parseable form

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-07 Thread Andrew Gierth
> "Bruce" == Bruce Momjian writes: Bruce> docs: fist draft version of the PG 12 release notes Bruce> Still needs text markup, links, word wrap, and indenting. The floating-point output change probably needs to be called out as a compatibility issue, not just a performance enhancement. --

pgsql: Avoid "invalid memory alloc request size" while reading pg_stat_

2019-05-07 Thread Tom Lane
Avoid "invalid memory alloc request size" while reading pg_stat_activity. On a 64-bit machine, if you set track_activity_query_size and max_connections such that their product exceeds 1GB, shared memory setup will still succeed (given enough RAM), but attempts to read pg_stat_activity fail with "i

pgsql: Fix typos and clarify a comment

2019-05-07 Thread Magnus Hagander
Fix typos and clarify a comment Author: Daniel Gustafsson Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/98719af6c2e30d538cd05cfe044f58ba4067b52b Modified Files -- src/backend/utils/adt/jsonpath_exec.c | 7 --- 1 file changed, 4 insertions(+), 3 de

pgsql: Add TRUNCATE parameter to VACUUM.

2019-05-07 Thread Fujii Masao
Add TRUNCATE parameter to VACUUM. This commit adds new parameter to VACUUM command, TRUNCATE, which specifies that VACUUM should attempt to truncate off any empty pages at the end of the table and allow the disk space for the truncated pages to be returned to the operating system. This parameter,

pgsql: Tag refs/tags/REL_11_3 was created

2019-05-07 Thread noreply
Tag refs/tags/REL_11_3 was created.

pgsql: Tag refs/tags/REL_10_8 was created

2019-05-07 Thread noreply
Tag refs/tags/REL_10_8 was created.

pgsql: Tag refs/tags/REL9_6_13 was created

2019-05-07 Thread noreply
Tag refs/tags/REL9_6_13 was created.

pgsql: Tag refs/tags/REL9_5_17 was created

2019-05-07 Thread noreply
Tag refs/tags/REL9_5_17 was created.

pgsql: Tag refs/tags/REL9_4_22 was created

2019-05-07 Thread noreply
Tag refs/tags/REL9_4_22 was created.

pgsql: Remove word "singleton" out of jsonpath docs

2019-05-07 Thread Alexander Korotkov
Remove word "singleton" out of jsonpath docs Word "singleton" is hard for user understanding, especially taking into account there is only one place it's used in the docs and there is even no definition. Use more evident wording instead. Discussion: https://postgr.es/m/23737.1556550645%40sss.pgh.

pgsql: Improve error reporting in jsonpath

2019-05-07 Thread Alexander Korotkov
Improve error reporting in jsonpath This commit contains multiple improvements to error reporting in jsonpath including but not limited to getting rid of following things: * definition of error messages in macros, * errdetail() when valueable information could fit to errmsg(), * word "singleto

Re: pgsql: Improve error reporting in jsonpath

2019-05-07 Thread Tom Lane
Alexander Korotkov writes: > Improve error reporting in jsonpath Buildfarm's not too happy --- looks like you forgot to update jsonpath_encoding_1.out all the way. regards, tom lane

pgsql: Add jsonpath_encoding_1.out changes missed in 29ceacc3f9

2019-05-07 Thread Alexander Korotkov
Add jsonpath_encoding_1.out changes missed in 29ceacc3f9 Reported-by: Tom Lane Discussion: https://postgr.es/m/14305.1557268259%40sss.pgh.pa.us Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/e5f978631722bb3cac42f0eb6e65e947e0f088ec Modified Files -- sr

Re: pgsql: Improve error reporting in jsonpath

2019-05-07 Thread Alexander Korotkov
On Wed, May 8, 2019 at 1:31 AM Tom Lane wrote: > Alexander Korotkov writes: > > Improve error reporting in jsonpath > > Buildfarm's not too happy --- looks like you forgot to update > jsonpath_encoding_1.out all the way. What a oversight! Will fix immediately. -- Alexander Korotkov Postgre

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-07 Thread Amit Langote
Hi Bruce, On 2019/05/07 8:02, Bruce Momjian wrote: > docs: fist draft version of the PG 12 release notes > > Still needs text markup, links, word wrap, and indenting. Thanks for crafting these up, as always. About the partitioning performance improvement item: + + + + +Improve performance of

pgsql: Correct obsolete nbtsort.c minimum key comment.

2019-05-07 Thread Peter Geoghegan
Correct obsolete nbtsort.c minimum key comment. It is no longer possible under any circumstances for nbtree code to reconstruct a strict lower bound key (parent page's pivot tuple key) for a right sibling page by retrieving the first item in the right sibling page. Branch -- master Details -

pgsql: Remove leftover reference to old "flat file" mechanism in a comm

2019-05-07 Thread Heikki Linnakangas
Remove leftover reference to old "flat file" mechanism in a comment. The flat file mechanism was removed in PostgreSQL 9.0. Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/2bc59f890100f9a90289f8ef10b9403294915ff8 Modified Files -- src/backend/acc

pgsql: Remove leftover reference to old "flat file" mechanism in a comm

2019-05-07 Thread Heikki Linnakangas
Remove leftover reference to old "flat file" mechanism in a comment. The flat file mechanism was removed in PostgreSQL 9.0. Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f40fb143eddb4838c7309881ff929a65c28dd8d0 Modified Files -- src/backend/acc

pgsql: Remove leftover reference to old "flat file" mechanism in a comm

2019-05-07 Thread Heikki Linnakangas
Remove leftover reference to old "flat file" mechanism in a comment. The flat file mechanism was removed in PostgreSQL 9.0. Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/46012d152f8d123ddc9c739aed06d093b8553b66 Modified Files -- src/backend/acc

pgsql: Remove leftover reference to old "flat file" mechanism in a comm

2019-05-07 Thread Heikki Linnakangas
Remove leftover reference to old "flat file" mechanism in a comment. The flat file mechanism was removed in PostgreSQL 9.0. Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/9e078fed21a0d60166896ffc82b5ff4c30b118d2 Modified Files -- src/backend/acc

pgsql: Remove leftover reference to old "flat file" mechanism in a comm

2019-05-07 Thread Heikki Linnakangas
Remove leftover reference to old "flat file" mechanism in a comment. The flat file mechanism was removed in PostgreSQL 9.0. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/256be1050cbbf90b1e44d11c8ed10f98255aa27d Modified Files -- src/backend/access/tra

pgsql: Remove leftover reference to old "flat file" mechanism in a comm

2019-05-07 Thread Heikki Linnakangas
Remove leftover reference to old "flat file" mechanism in a comment. The flat file mechanism was removed in PostgreSQL 9.0. Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b0c546136776f198c1858521698c074226eaed57 Modified Files -- src/backend/acc