Re: Re: proposal: schema variables

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, jian he <jian(dot)universality(at)gmail(dot)com>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Erik Rijkers <er(at)xs4all(dot)nl>, Michael Paquier <michael(at)paquier(dot)xyz>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, DUVAL REMI <REMI(dot)DUVAL(at)cheops(dot)fr>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Re: proposal: schema variables
Date: 2025-01-20 08:26:11
Message-ID: CAFj8pRDDizf70=U6H+=O22mqQcVXB40vzvb-bsw4qsegzYdSXg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Hi

po 20. 1. 2025 v 8:56 odesílatel Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
napsal:

> On 2025-Jan-17, Bruce Momjian wrote:
>
> > Is this really something we are considering applying, since it has been
> > around for years? I am unclear on that and we had better know if we are
> > going to continue reviewing this.
>
> The fact that the patch has been around for years doesn't automatically
> mean it's a bad idea.
>
> I have proposed that we discuss this patch at fosdem developer's meeting
> next month, precisely to seek consensus on whether this patch is
> something we want or not. My view is that this is a feature that has
> been requested by users for years, so IMO we want this or something
> similar.
>
> I wonder if the reason that committers stay away from it is that
> reviewing it fully (and thus taking responsibility for it) seems such a
> daunting task. I might be wrong, but I think this may be the largest
> patch since FTS.
>

This patch is huge, but I think it is not comparable with parallel
processing support or with replication support.

It doesn't introduce new processes or new data structures or does important
changes in planner, and I think so almost all code is very simple.

In early versions of this patch, there was a complex part to ensure
validity of content in memory. But it was fully removed and replaced
just by comparing with create_lsn.

Regards

Pavel

> --
> Álvaro Herrera 48°01'N 7°57'E —
> https://www.EnterpriseDB.com/
> Tom: There seems to be something broken here.
> Teodor: I'm in sackcloth and ashes... Fixed.
>
> http://postgr.es/m/482D1632.8010507@sigaev.ru
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Jones 2025-01-20 11:02:36 Re: XMLDocument (SQL/XML X030)
Previous Message jian he 2025-01-20 08:21:35 Re: Statistics Import and Export

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2025-01-20 20:15:43 Re: Re: proposal: schema variables
Previous Message Gilles Darold 2025-01-18 07:24:04 Re: Fwd: Re: proposal: schema variables