pgsql: Fix running out of file descriptors for spill files.

2020-01-01 Thread Amit Kapila
Fix running out of file descriptors for spill files. Currently while decoding changes, if the number of changes exceeds a certain threshold, we spill those to disk.  And this happens for each (sub)transaction.  Now, while reading all these files, we don't close them until we read all the files.  W

pgsql: Fix running out of file descriptors for spill files.

2020-01-01 Thread Amit Kapila
Fix running out of file descriptors for spill files. Currently while decoding changes, if the number of changes exceeds a certain threshold, we spill those to disk.  And this happens for each (sub)transaction.  Now, while reading all these files, we don't close them until we read all the files.  W

pgsql: Fix running out of file descriptors for spill files.

2020-01-01 Thread Amit Kapila
Fix running out of file descriptors for spill files. Currently while decoding changes, if the number of changes exceeds a certain threshold, we spill those to disk.  And this happens for each (sub)transaction.  Now, while reading all these files, we don't close them until we read all the files.  W

pgsql: Fix running out of file descriptors for spill files.

2020-01-01 Thread Amit Kapila
Fix running out of file descriptors for spill files. Currently while decoding changes, if the number of changes exceeds a certain threshold, we spill those to disk.  And this happens for each (sub)transaction.  Now, while reading all these files, we don't close them until we read all the files.  W

pgsql: Fix running out of file descriptors for spill files.

2020-01-01 Thread Amit Kapila
Fix running out of file descriptors for spill files. Currently while decoding changes, if the number of changes exceeds a certain threshold, we spill those to disk.  And this happens for each (sub)transaction.  Now, while reading all these files, we don't close them until we read all the files.  W

pgsql: Fix running out of file descriptors for spill files.

2020-01-01 Thread Amit Kapila
Fix running out of file descriptors for spill files. Currently while decoding changes, if the number of changes exceeds a certain threshold, we spill those to disk.  And this happens for each (sub)transaction.  Now, while reading all these files, we don't close them until we read all the files.  W

pgsql: Fix running out of file descriptors for spill files.

2020-01-01 Thread Amit Kapila
Fix running out of file descriptors for spill files. Currently while decoding changes, if the number of changes exceeds a certain threshold, we spill those to disk.  And this happens for each (sub)transaction.  Now, while reading all these files, we don't close them until we read all the files.  W

pgsql: Revise BTP_HAS_GARBAGE nbtree VACUUM comments.

2020-01-01 Thread Peter Geoghegan
Revise BTP_HAS_GARBAGE nbtree VACUUM comments. _bt_delitems_vacuum() comments claimed that it isn't worth another scan of the page to avoid falsely unsetting the BTP_HAS_GARBAGE page flag hint (this happens to be the same wording that was removed from _bt_delitems_delete() by my recent commit fe97

pgsql: Test GROUP BY matching of join columns that are type-coerced by

2020-01-01 Thread Tom Lane
Test GROUP BY matching of join columns that are type-coerced by USING. If we have, say, an int column that is left-joined to a bigint column with USING, the merged column is the int column promoted to bigint. GROUP BY's tests for whether grouping on the merged column allows a reference to the unde

pgsql: Update btree_xlog_delete() comments.

2020-01-01 Thread Peter Geoghegan
Update btree_xlog_delete() comments. Commit fe97c61c updated LP_DEAD item deletion comments, but missed a minor discrepancy on the REDO side. Fix it now. In passing, don't talk about the btree_xlog_vacuum() behavior within btree_xlog_delete(). The reliance on XLOG_HEAP2_CLEANUP_INFO records for

pgsql: Update copyrights for 2020

2020-01-01 Thread Bruce Momjian
Update copyrights for 2020 Backpatch-through: update all files in master, backpatch legal files through 9.4 Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f512479c23e02ecd49aeb569064517b07de5cc2e Modified Files -- COPYRIGHT | 2 +-

pgsql: Update copyrights for 2020

2020-01-01 Thread Bruce Momjian
Update copyrights for 2020 Backpatch-through: update all files in master, backpatch legal files through 9.4 Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/9776feb0e9ccb5bd05eb02c1296f0a78a50b766b Modified Files -- COPYRIGHT | 2 +-

pgsql: Update copyrights for 2020

2020-01-01 Thread Bruce Momjian
Update copyrights for 2020 Backpatch-through: update all files in master, backpatch legal files through 9.4 Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/15eb1b66a4e5a9236f5a4a53f1def5ebca81768b Modified Files -- COPYRIGHT | 2 +-

pgsql: Update copyrights for 2020

2020-01-01 Thread Bruce Momjian
Update copyrights for 2020 Backpatch-through: update all files in master, backpatch legal files through 9.4 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/8f3e44a1649e79718da65cd8883d481b329a02a7 Modified Files -- COPYRIGHT | 2 +-

pgsql: Update copyrights for 2020

2020-01-01 Thread Bruce Momjian
Update copyrights for 2020 Backpatch-through: update all files in master, backpatch legal files through 9.4 Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/ce758a3d753748891ba2dbd56ad7953154e256d2 Modified Files -- COPYRIGHT | 2 +-

pgsql: Update copyrights for 2020

2020-01-01 Thread Bruce Momjian
Update copyrights for 2020 Backpatch-through: update all files in master, backpatch legal files through 9.4 Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/78b381c5ddadb25e915ee4f380c28a676851998c Modified Files -- COPYRIGHT | 2 +-