On Fri, Dec 17, 2021 at 2:43 PM Bruce Momjian wrote:
> I am attaching an updated patch which mentions non-HOT updates for
> expression indexes.
>
Thanks. I'm a bit concerned that before this patch the only place we
mentioned HOTin the docs is in the appendix acronym listing which points to
the
On Tue, Dec 21, 2021, at 6:46 AM, PG Doc comments form wrote:
> include_dir 'directory'
>
> it it not 100% clear whether the include_dir option also allows 'if_exists'
> funtionality.
>
> I think a include_dir_if_exists should be possible.
> If it is it should be expressed specifically in th
On Wed, Dec 22, 2021 at 02:40:12PM -0700, David G. Johnston wrote:
> On Fri, Dec 17, 2021 at 2:43 PM Bruce Momjian wrote:
>
> I am attaching an updated patch which mentions non-HOT updates for
> expression indexes.
>
>
> Thanks. I'm a bit concerned that before this patch the only place
On Wed, Dec 22, 2021 at 2:45 PM Bruce Momjian wrote:
> On Wed, Dec 22, 2021 at 02:40:12PM -0700, David G. Johnston wrote:
> > On Fri, Dec 17, 2021 at 2:43 PM Bruce Momjian wrote:
> >
> > I am attaching an updated patch which mentions non-HOT updates for
> > expression indexes.
> >
> >
>
On Wed, Dec 22, 2021 at 03:06:12PM -0700, David G. Johnston wrote:
> On Wed, Dec 22, 2021 at 2:45 PM Bruce Momjian wrote:
> Not sure what else we can do --- it would be odd to explain it in the
> expression index docs.
>
>
>
> Found another one:
>
> https://www.postgresql.org/docs/curr
On Wed, Dec 22, 2021 at 05:09:53PM -0500, Bruce Momjian wrote:
> On Wed, Dec 22, 2021 at 03:06:12PM -0700, David G. Johnston wrote:
> > On Wed, Dec 22, 2021 at 2:45 PM Bruce Momjian wrote:
> > Not sure what else we can do --- it would be odd to explain it in the
> > expression index docs.
On Wed, Dec 22, 2021 at 3:09 PM Bruce Momjian wrote:
> On Wed, Dec 22, 2021 at 03:06:12PM -0700, David G. Johnston wrote:
> > On Wed, Dec 22, 2021 at 2:45 PM Bruce Momjian wrote:
> > Not sure what else we can do --- it would be odd to explain it in the
> > expression index docs.
> >
> >
On Wed, Dec 22, 2021 at 3:13 PM Bruce Momjian wrote:
> I think our _big_ missing information is a definition of HOT updates and
> that updating a column involved in an index disables HOT updates.
>
Along those lines adding "51.7 Special Considerations for Updates" would be
minimally invasive. H
On Wed, Dec 22, 2021 at 2:13 PM Bruce Momjian wrote:
> I think our _big_ missing information is a definition of HOT updates and
> that updating a column involved in an index disables HOT updates.
I *strongly* agree that that's the single most important piece of
information, by far. Though we coul
