Re: recovering from "found xmin ... from before relfrozenxid ..."

2020-09-15 Thread Ashutosh Sharma
On Wed, Sep 16, 2020 at 9:14 AM Tom Lane wrote: > > Ashutosh Sharma writes: > > On Wed, Sep 16, 2020 at 1:25 AM Tom Lane wrote: > >> * Should any of the other tables in the test be converted to temp? > > > Are you trying to say that we can achieve the things being done in > > test-case 1 and 2 b

Re: Force update_process_title=on in crash recovery?

2020-09-15 Thread Thomas Munro
On Wed, Sep 16, 2020 at 2:30 PM Michael Paquier wrote: > On Tue, Sep 15, 2020 at 10:01:18AM -0400, Tom Lane wrote: > > Seems like a good argument, but you'd have to be careful about the > > final state when you stop overriding update_process_title --- it can't > > be left looking like it's still-i

Re: Force update_process_title=on in crash recovery?

2020-09-15 Thread Tom Lane
Thomas Munro writes: > On Wed, Sep 16, 2020 at 2:30 PM Michael Paquier wrote: >> Another thing to be careful here is WIN32, see 0921554. And slowing >> down recovery is never a good idea. > Right, that commit makes a lot of sense because it suppresses many > system calls that happen for each qu

Re: Parallelize stream replication process

2020-09-15 Thread Paul Guo
> On Sep 16, 2020, at 11:15 AM, Li Japin wrote: > > > >> On Sep 15, 2020, at 3:41 PM, Fujii Masao wrote: >> >> >> >> On 2020/09/15 13:41, Bharath Rupireddy wrote: >>> On Tue, Sep 15, 2020 at 9:27 AM Li Japin wrote: For now, postgres use single process to send, receive and repl

Re: recovering from "found xmin ... from before relfrozenxid ..."

2020-09-15 Thread Ashutosh Sharma
On Wed, Sep 16, 2020 at 10:40 AM Ashutosh Sharma wrote: > > On Wed, Sep 16, 2020 at 9:14 AM Tom Lane wrote: > > > > Ashutosh Sharma writes: > > > On Wed, Sep 16, 2020 at 1:25 AM Tom Lane wrote: > > >> * Should any of the other tables in the test be converted to temp? > > > > > Are you trying to

Re: Subscription test 013_partition.pl fails under CLOBBER_CACHE_ALWAYS

2020-09-15 Thread Amit Kapila
On Wed, Sep 16, 2020 at 9:41 AM Tom Lane wrote: > > Amit Kapila writes: > > So, can we assume that the current code can only cause the problem in > > CCA builds bot not in any practical scenario because after having a > > lock on relation probably there shouldn't be any invalidation which > > lea

RE: Transactions involving multiple postgres foreign servers, take 2

2020-09-15 Thread tsunakawa.ta...@fujitsu.com
From: Masahiko Sawada > The resolver process has two functionalities: resolving foreign > transactions automatically when the user issues COMMIT (the case you > described in the second paragraph), and resolving foreign transaction > when the corresponding backend no longer exist or when the server

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

2020-09-15 Thread Amit Kapila
On Tue, Sep 15, 2020 at 10:17 AM Amit Kapila wrote: > > On Tue, Sep 15, 2020 at 8:38 AM Tom Lane wrote: > > > As far as I can see they are useless in this case but I think they > > > might be required in case the user provides its own allocator function > > > (using HASH_ALLOC). So, we can probab

<    1   2