Re: Mention of PG 14 in docs

2021-05-03 Thread Alexander Korotkov
On Tue, May 4, 2021 at 3:55 AM Bruce Momjian wrote: > On Tue, May 4, 2021 at 03:51:51AM +0300, Alexander Korotkov wrote: > > Hi, Bruce! > > > > On Tue, May 4, 2021 at 2:49 AM Bruce Momjian wrote: > > > In patch "Handle equality operator in contrib/pg_trgm" (935f5), I > > > see this text: > >

Re: Mention of PG 14 in docs

2021-05-03 Thread Bruce Momjian
On Tue, May 4, 2021 at 03:51:51AM +0300, Alexander Korotkov wrote: > Hi, Bruce! > > On Tue, May 4, 2021 at 2:49 AM Bruce Momjian wrote: > > In patch "Handle equality operator in contrib/pg_trgm" (935f5), I > > see this text: > > > > --> ~ and ~* queries. Beginning > > in > > --> Po

Re: Mention of PG 14 in docs

2021-05-03 Thread Alexander Korotkov
Hi, Bruce! On Tue, May 4, 2021 at 2:49 AM Bruce Momjian wrote: > In patch "Handle equality operator in contrib/pg_trgm" (935f5), I > see this text: > > --> ~ and ~* queries. Beginning in > --> PostgreSQL 14, these indexes also support > equality operator (simple comparison op

Re: Mention of PG 14 in docs

2021-05-03 Thread Bruce Momjian
On Mon, May 3, 2021 at 08:10:24PM -0400, Bruce Momjian wrote: > On Mon, May 3, 2021 at 07:49:14PM -0400, Bruce Momjian wrote: > > In patch "Handle equality operator in contrib/pg_trgm" (935f5), I > > see this text: > > > > --> ~ and ~* queries. Beginning in > > --> PostgreSQL 14, these inde

Re: Mention of PG 14 in docs

2021-05-03 Thread Bruce Momjian
On Mon, May 3, 2021 at 07:49:14PM -0400, Bruce Momjian wrote: > In patch "Handle equality operator in contrib/pg_trgm" (935f5), I > see this text: > > --> ~ and ~* queries. Beginning in > --> PostgreSQL 14, these indexes also support > equality operator (simple comparison operators

Mention of PG 14 in docs

2021-05-03 Thread Bruce Momjian
In patch "Handle equality operator in contrib/pg_trgm" (935f5), I see this text: --> ~ and ~* queries. Beginning in --> PostgreSQL 14, these indexes also support equality operator (simple comparison operators are not supported). Note that those indexes may not be as ef

Update maintenance_work_mem/autovacuum_work_mem to reflect the 1GB limitation with VACUUM

2021-05-03 Thread Martín Marqués
Hi, There's a well known limitation in the amount of memory that any VACUUM process can use, capped at 1GB now. This is not reflected in the documentation https://www.postgresql.org/docs/current/runtime-config-resource.html We should add a line that indicates that there is a limitation (that sho