Re: Attempt to consolidate reading of XLOG page

2019-11-16 Thread Alvaro Herrera
BTW ... contrib/test_decoding fails with this patch. -- Álvaro Herrerahttps://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: could not stat promote trigger file leads to shutdown

2019-11-16 Thread Alvaro Herrera
On 2019-Nov-15, Tom Lane wrote: > If we add a GUC-check-hook test, then the problem of misconfiguration > is reduced to the previously unsolved problem that we have crappy > feedback for erroneous on-the-fly configuration changes. So it's > still unsolved, but at least we've got one unsolved prob

Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly

2019-11-16 Thread Steve Singer
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, failed Spec compliant: not tested Documentation:tested, failed * I had to replace heap_open/close with table_open/close to get t

Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions?

2019-11-16 Thread Daniel Gustafsson
> On 12 Nov 2019, at 19:33, Andres Freund wrote: Thanks for reviewing! > On 2019-11-12 16:25:06 +0100, Daniel Gustafsson wrote: >>> On 11 Nov 2019, at 09:32, Michael Paquier wrote: >> >>> This part has resulted in 75c1921, and we could just change >>> DecodeMultiInsert() so as if there is no t

Copyright information in source files

2019-11-16 Thread vignesh C
Hi, I noticed that some of the source files does not include the copyright information. Most of the files have included it, but few files have not included it. I felt it should be included. The attached patch contains the fix for including the copyright information in the source files. Let me know

Re: Postgres on IBM z/OS 2.2.0 and 2.3.0

2019-11-16 Thread Tom Lane
parveen mehta writes: > I am researching whether an postgres installation can be done on Unix system > services(USS) in z/OS. USS is a POSIX compliant OS on z/OS and i wonder if > you have any experience with installing it there that you can share with me. > I would be highly appreciative of yo

Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index.

2019-11-16 Thread Te
Moin, On 2019-11-16 01:04, Peter Geoghegan wrote: On Fri, Nov 15, 2019 at 5:16 AM Robert Haas wrote: Hmm. Well, maybe I'm just behind the times. But that same wikipedia article also says that deduplication works on large chunks "such as entire files or large sections of files" thus differentia

Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions

2019-11-16 Thread Amit Kapila
On Thu, Nov 7, 2019 at 5:13 PM Amit Kapila wrote: > > Some notes before commit: > -- > 1. > Commit message need to be changed for the first patch > - > A. > > The memory limit is defined by

Postgres on IBM z/OS 2.2.0 and 2.3.0

2019-11-16 Thread parveen mehta
I am researching whether an postgres installation can be done on Unix system services(USS) in z/OS. USS is a POSIX compliant OS on z/OS and i wonder if you have any experience with installing it there that you can share with me. I would be highly appreciative of your comments and thoughts. Thank