Re: Probable memory leak with ECPG and AIX

2021-12-31 Thread Noah Misch
On Wed, Dec 15, 2021 at 04:20:42PM +0100, Benoit Lobréau wrote: > * with LDR_CNTRL=MAXDATA=0x1000, we reach 256Mo but there is no > segfault, the program just continues running ; > * with LDR_CNTRL=MAXDATA=0x8000, we reach 2Go and there is no segfault > either, the program just continues ru

Re: Speed up transaction completion faster after many relations are accessed in a transaction

2021-12-31 Thread Zhihong Yu
On Fri, Dec 31, 2021 at 5:45 PM David Rowley wrote: > On Fri, 3 Dec 2021 at 20:36, Michael Paquier wrote: > > Two months later, this has been switched to RwF. > > I was discussing this patch with Andres. He's not very keen on my > densehash hash table idea and suggested that instead of relying o

Re: Fix BUG #17335: Duplicate result rows in Gather node

2021-12-31 Thread David Rowley
On Fri, 31 Dec 2021 at 00:14, Yura Sokolov wrote: > Problem: > - Append path is created with explicitely parallel_aware = true > - It has two child, one is trivial, other is parallel_aware = false . > Trivial child is dropped. > - Gather/GatherMerge path takes Append path as a child and thinks >

Re: Speed up transaction completion faster after many relations are accessed in a transaction

2021-12-31 Thread David Rowley
On Fri, 3 Dec 2021 at 20:36, Michael Paquier wrote: > Two months later, this has been switched to RwF. I was discussing this patch with Andres. He's not very keen on my densehash hash table idea and suggested that instead of relying on trying to make the hash table iteration faster, why don't we

slowest tap tests - split or accelerate?

2021-12-31 Thread Andres Freund
Hi, cfbot now runs most tests on windows, the windows task is by far the slowest, and the task limitted most in concurrency [2]. Running tap tests is the biggest part of that. This is a bigger issue on windows because we don't have infrastructure (yet) to run tests in parallel. There's a few test

Re: Add header support to text format and matching feature

2021-12-31 Thread Rémi Lapeyre
Here’s an updated version of the patch that takes into account the changes in d1029bb5a2. The actual code is the same as v10 which was already marked as ready for committer. v11-0001-Add-header-support-to-COPY-TO-text-format.patch Description: Binary data v11-0002-Add-header-matching-mode-t

Re: Column Filtering in Logical Replication

2021-12-31 Thread Justin Pryzby
> @@ -5963,8 +5967,20 @@ describePublications(const char *pattern) > { > /* Get the tables for the specified publication */ > printfPQExpBuffer(&buf, > - "SELECT n.nspname, > c.relname\n

Re: Extend compatibility of PostgreSQL::Test::Cluster

2021-12-31 Thread Andrew Dunstan
On 12/31/21 11:20, Dagfinn Ilmari Mannsåker wrote: > Andrew Dunstan writes: > >> +my $subclass = __PACKAGE__ . "::V_$maj"; >> +bless $node, $subclass; >> +unless ($node->isa(__PACKAGE__)) >> +{ >> +# It's not a subclass, so re-b

Re: Extend compatibility of PostgreSQL::Test::Cluster

2021-12-31 Thread Dagfinn Ilmari Mannsåker
Andrew Dunstan writes: > + my $subclass = __PACKAGE__ . "::V_$maj"; > + bless $node, $subclass; > + unless ($node->isa(__PACKAGE__)) > + { > + # It's not a subclass, so re-bless back into the main > package > +

Introducing PgVA aka PostgresVectorAcceleration using SIMD vector instructions starting with hex_encode

2021-12-31 Thread Hans Buschmann
INTENTION Inspired by the effort to integrate JIT for executor acceleration I thought selected simple algorithms working with array-oriented data should be drastically accelerated by using SIMD instructions on modern hardware. I want to introduce this style of programming with the example of he

Re: Adding CI to our tree

2021-12-31 Thread Alvaro Herrera
On 2021-Dec-30, Andres Freund wrote: > On 2021-12-30 17:46:52 -0800, Andres Freund wrote: > > I plan to push this after another cycle of tests passing (and driving > > over the bay bridge...) unless I hear protests. > > Pushed. > > Marked CF entry as committed. I tried it using the column filte

Re: Parameter for planner estimate of recursive queries

2021-12-31 Thread Simon Riggs
On Wed, 27 Oct 2021 at 15:58, Simon Riggs wrote: > The poor performance is traced to the planner cost estimates for > recursive queries. Specifically, the cost of the recursive arm of the > query is evaluated based upon both of these hardcoded assumptions: > > 1. The recursion will last for 10 lo

Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work

2021-12-31 Thread Bharath Rupireddy
Hi, Currently the server is erroring out when unable to remove/parse a logical rewrite file in CheckPointLogicalRewriteHeap wasting the amount of work the checkpoint has done and preventing the checkpoint from finishing. This is unlike CheckPointSnapBuild does for snapshot files i.e. it just emits