On Mon, Apr 11, 2022 at 11:44 AM Zhihong Yu wrote:
> On Sun, Apr 10, 2022 at 7:41 PM Justin Pryzby wrote:
>> On Sun, Apr 10, 2022 at 06:46:25AM -0700, Zhihong Yu wrote:
>> > Looking at the second hunk of the patch:
>> > FdwRoutine *fdwroutine = path->parent->fdwroutine;
>> > ...
>
Hi,
(I added Tomas in CC:.)
One thing I noticed while reviewing the patch for fast copying into
foreign tables/partitions using batch insert [1] is that in
postgres_fdw we allow batch-inserting into foreign tables/partitions
with before row triggers, but such triggers might query the target
table/
On Sun, Apr 17, 2022 at 1:48 AM Etsuro Fujita
wrote:
> On Mon, Apr 11, 2022 at 11:44 AM Zhihong Yu wrote:
> > On Sun, Apr 10, 2022 at 7:41 PM Justin Pryzby
> wrote:
> >> On Sun, Apr 10, 2022 at 06:46:25AM -0700, Zhihong Yu wrote:
> >> > Looking at the second hunk of the patch:
> >> >
Hi,
On 4/17/22 04:43, dl x wrote:
My name is Donglin Xie, a MSc. student at Zhejiang University, in China. I
am interested in the project *pgexporter: Custom_file.*
The proposal is attached to this email. Looking forward to the suggestions!
Thanks for your proposal to Google Summer of Code
Hi,
On 2022-04-16 14:42:39 -0400, Tom Lane wrote:
> In the meantime, since it's clear that HaveRegisteredOrActiveSnapshot
> is failing to meet its contract, I'm going to go fix it.
+1
> I think (based on the above argument) that what it intends to enforce
> is not really the system design we ne
Hi,
On 2022-04-16 13:11:59 -0400, Tom Lane wrote:
> My pet dinosaur prairiedog just failed in the contrib/test_decoding
> tests [1]:
>
> diff -U3
> /Users/buildfarm/bf-data/HEAD/pgsql.build/contrib/test_decoding/expected/stream.out
>
> /Users/buildfarm/bf-data/HEAD/pgsql.build/contrib/test_dec
Hi,
Adding Amit, I think this is stuff he worked on...
On 2022-04-17 07:31:04 -0700, Andres Freund wrote:
> On 2022-04-16 13:11:59 -0400, Tom Lane wrote:
> > My pet dinosaur prairiedog just failed in the contrib/test_decoding
> > tests [1]:
> >
> > diff -U3
> > /Users/buildfarm/bf-data/HEAD/pgs
Hi,
On 2022-04-15 11:12:34 -0700, Peter Geoghegan wrote:
> On Fri, Apr 15, 2022 at 10:43 AM Andres Freund wrote:
> > I think it'd be interesting - particularly for large relations or when
> > looking to adjust autovac cost limits.
>
> > Something like:
> > removable cutoff: %u, age at start: %u,
On 2022-04-17 Su 00:17, Michael Paquier wrote:
>> Since it's quite painful to run TAP tests under valgrind, I found a
>> place to stick a plain old sleep to repro these problems:
> Actually, I am wondering how you are patching Cluster.pm to do that.
I don't really think it's Cluster.pm's busin
On Sun, Apr 17, 2022 at 7:36 AM Andres Freund wrote:
> > Part of the problem here is that we determine VACUUM's FreezeLimit by
> > calculating `OldestXmin - vacuum_freeze_min_age` (more or less [1]).
>
> What the message outputs is OldestXmin and not FreezeLimit though.
My higher level point is t
Andres Freund writes:
> On 2022-04-16 14:42:39 -0400, Tom Lane wrote:
>> I think (based on the above argument) that what it intends to enforce
>> is not really the system design we need, but it certainly isn't
>> helping anyone that it enforces that design incorrectly.
> I think it's approximatel
Andres Freund writes:
>> On 2022-04-16 13:11:59 -0400, Tom Lane wrote:
>>> We've seen this sort of problem before [2], and attempted to fix it [3]
>>> by making these tests ignore empty transactions. But of course
>>> auto-analyze's transaction wasn't empty, so that didn't help.
>> I don't quite
Hi
On 2022-04-17 12:01:53 -0400, Tom Lane wrote:
> Andres Freund writes:
> >> On 2022-04-16 13:11:59 -0400, Tom Lane wrote:
> >>> We've seen this sort of problem before [2], and attempted to fix it [3]
> >>> by making these tests ignore empty transactions. But of course
> >>> auto-analyze's tran
Andres Freund writes:
> On 2022-04-17 12:01:53 -0400, Tom Lane wrote:
>> It seems likely to me that trying to make a test like this one blind to
>> autovacuum/autoanalyze activity will make it less useful, not more so.
>> Why is such blindness desirable?
> Maybe I misunderstood - I thought you we
On Sun, Apr 17, 2022 at 10:56:08AM -0400, Andrew Dunstan wrote:
> I don't really think it's Cluster.pm's business to deal with that. It
> takes an install path as given either explicitly or implicitly.
>
> It shouldn't be too hard to get Makefile.global to install valgrind
> wrappers into the tmp_
On Fri, Apr 15, 2022 at 4:26 PM Noah Misch wrote:
>
> On Thu, Apr 07, 2022 at 08:39:58PM +0900, Masahiko Sawada wrote:
> > On Thu, Apr 7, 2022 at 7:28 PM Amit Kapila wrote:
> > > On Thu, Apr 7, 2022 at 8:25 AM Amit Kapila
> > > wrote:
> > > > I'll take care of this today. I think we can mark th
Hello,
PFA my proposal for GSoC 2022 Project: GUI representation of monitoring System
Activity with the system_stats Extension in pgAdmin 4
Potential Mentor: Khushboo Vashi
Thank you
Kunal Kashyap
GSOC '22 - Project Proposal - GUI representation of monitoring System Activity with the syste
Hello all,
PFA my proposal for GSoC 2022 Project: Improve PgArchives
Potential Mentors: Ilaria Battiston, Stephen Frost
Thank you
Kunal Kashyap
GSOC '22 - Project Proposal - Improve pgArchives - Kunal Kashyap.pdf
Description: Adobe PDF document
On Thu, Apr 14, 2022 at 06:18:29AM +0900, Michael Paquier wrote:
> The issue back then was how to design the option set to handle all
> that (right? My memories may be short on that), and pg_basebackup
> takes care of that with its option design.
I have looked at that again this morning, and the
On Sun, Apr 17, 2022 at 8:02 PM Andres Freund wrote:
>
> Adding Amit, I think this is stuff he worked on...
>
I'll look into this and share my findings.
--
With Regards,
Amit Kapila.
On Mon, Apr 18, 2022 at 10:45:50AM +0900, Masahiko Sawada wrote:
> On Fri, Apr 15, 2022 at 4:26 PM Noah Misch wrote:
> > On Thu, Apr 07, 2022 at 08:39:58PM +0900, Masahiko Sawada wrote:
> > > On Thu, Apr 7, 2022 at 7:28 PM Amit Kapila
> > > wrote:
> > > > On Thu, Apr 7, 2022 at 8:25 AM Amit Kapi
On Fri, Apr 15, 2022 at 11:49 AM Kyotaro Horiguchi
wrote:
>
> At Thu, 14 Apr 2022 10:33:50 +0530, vignesh C wrote in
> > On Wed, Apr 6, 2022 at 12:29 PM vignesh C wrote:
> > >
> > > On Tue, Apr 5, 2022 at 9:18 PM Robert Haas wrote:
> > > > This looks like a grotty hack.
> > >
> > > I have chang
On Thu, Apr 14, 2022 at 5:52 PM Euler Taveira wrote:
>
> On Wed, Apr 13, 2022, at 7:45 AM, Amit Kapila wrote:
>
> Sawada-San, Euler, do you have any opinion on this approach? I
> personally still prefer the approach implemented in v10 [1] especially
> due to the latest finding by Wang-San that we
On Thu, Apr 14, 2022 at 5:50 PM Masahiko Sawada wrote:
>
> On Wed, Apr 13, 2022 at 7:45 PM Amit Kapila wrote:
> >
> > On Mon, Apr 11, 2022 at 12:09 PM wangw.f...@fujitsu.com
> > wrote:
> > >
> > > So I skip tracking lag during a transaction just like the current HEAD.
> > > Attach the new patch.
On Sat, Jan 01, 2022 at 04:07:50PM -0800, Noah Misch wrote:
> On Sat, Jan 01, 2022 at 11:35:02AM -0500, Tom Lane wrote:
> > Noah Misch writes:
> > > I get the same results. The leak arises because AIX freelocale() doesn't
> > > free
> > > all memory allocated in newlocale(). The following progr
Hello all,
PFA my proposal for GSoC 2022 Project: Improve PgArchives
Potential Mentor: Dave Cramer
Thank you
Kunal Kashyap
GSOC '22 - Project Proposal - New & Improved Website for PgJDBC - Kunal Kashyap.pdf
Description: Adobe PDF document
(I pushed the main patch as f2698ea, on 2022-03-04.)
On Fri, Feb 18, 2022 at 06:41:36PM -0800, Noah Misch wrote:
> On Fri, Feb 18, 2022 at 10:26:52AM -0500, Tom Lane wrote:
> > Noah Misch writes:
> > > On Thu, Feb 17, 2022 at 09:48:25PM -0800, Andres Freund wrote:
> > >> Meson's test runner has t
On Wed, Dec 29, 2021 at 8:06 PM Bharath Rupireddy
wrote:
>
> On Wed, Dec 29, 2021 at 7:27 PM Stephen Frost wrote:
> > > On Thu, Dec 23, 2021, at 9:58 AM, Bharath Rupireddy wrote:
> > > > pg_archivecleanup currently takes a WAL file name as input to delete
> > > > the WAL files prior to it [1]. As
On Mon, Apr 18, 2022 at 12:22 PM Noah Misch wrote:
>
> On Mon, Apr 18, 2022 at 10:45:50AM +0900, Masahiko Sawada wrote:
> > On Fri, Apr 15, 2022 at 4:26 PM Noah Misch wrote:
> > > On Thu, Apr 07, 2022 at 08:39:58PM +0900, Masahiko Sawada wrote:
> > > > On Thu, Apr 7, 2022 at 7:28 PM Amit Kapila
On Mon, Apr 18, 2022 at 1:01 PM Amit Kapila wrote:
>
> On Thu, Apr 14, 2022 at 5:50 PM Masahiko Sawada wrote:
> >
> > On Wed, Apr 13, 2022 at 7:45 PM Amit Kapila wrote:
> > >
> > > On Mon, Apr 11, 2022 at 12:09 PM wangw.f...@fujitsu.com
> > > wrote:
> > > >
> > > > So I skip tracking lag during
On Mon, Apr 18, 2022 at 9:29 AM Amit Kapila wrote:
>
> On Thu, Apr 14, 2022 at 5:52 PM Euler Taveira wrote:
> >
> > On Wed, Apr 13, 2022, at 7:45 AM, Amit Kapila wrote:
> >
> > Sawada-San, Euler, do you have any opinion on this approach? I
> > personally still prefer the approach implemented in v
On Tue, Apr 12, 2022 at 12:49:48PM +0900, Michael Paquier wrote:
> This comes from df86e52, where we want to recovery a history file that
> would be created as RECOVERYHISTORY and make sure that the file gets
> removed at the end of recovery. So $standby2 should choose a new
> timeline different f
On Sat, Apr 16, 2022 at 10:42 PM Tom Lane wrote:
>
> My pet dinosaur prairiedog just failed in the contrib/test_decoding
> tests [1]:
>
> diff -U3
> /Users/buildfarm/bf-data/HEAD/pgsql.build/contrib/test_decoding/expected/stream.out
>
> /Users/buildfarm/bf-data/HEAD/pgsql.build/contrib/test_dec
>> One thing that this doesn't fix is that the existing text appears
>> to suggest that the "failures" column is something different from
>> the sum of the serialization_failures and deadlock_failures
>> columns, which it's obvious from the code is not so. If this isn't
>> a code bug then I think
On Thu, Apr 14, 2022 at 8:55 AM Amit Kapila wrote:
>
> On Thu, Apr 14, 2022 at 1:29 AM Euler Taveira wrote:
> >
> > On Wed, Apr 13, 2022, at 12:24 AM, Peter Smith wrote:
> >
> > PSA patch v10 which addresses the remaining review comments from Euler [1]
> >
> > Looks good to me.
> >
>
> Thanks, th
On Mon, Apr 18, 2022 at 00:35 PM Masahiko Sawada wrote:
> On Mon, Apr 18, 2022 at 1:01 PM Amit Kapila wrote:
> >
> > On Thu, Apr 14, 2022 at 5:50 PM Masahiko Sawada
> wrote:
> > >
> > > On Wed, Apr 13, 2022 at 7:45 PM Amit Kapila
> wrote:
> > > >
> > > > On Mon, Apr 11, 2022 at 12:09 PM wangw.f
On Thur, Apr 14, 2022 at 8:21 PM Euler Taveira wrote:
>
Thanks for your comments.
> + * For a large transaction, if we don't send any change to the downstream
> for a
> + * long time then it can timeout. This can happen when all or most of the
> + * changes are either not published or got filter
On Friday, April 15, 2022 12:46 AM Alvaro Herrera
wrote:
>
> On 2022-Apr-11, houzj.f...@fujitsu.com wrote:
>
> > I have confirmed that the bug of ATTACH PARTITION has been fixed due to
> recent
> > commit 7f481b8. Currently, we always invalidate the RelationSyncCache when
> > attaching a partit
On Thu, Mar 24, 2022 at 05:44:31PM -0400, Tom Lane wrote:
> Note that that's basically a workaround for buggy placement of the
> OAT hooks, as per previous discussion. I hope that we fix that bug
> pretty soon, so it shouldn't really be a factor for the meson conversion.
So, this issue is still l
39 matches
Mail list logo