Re: REGEXP_REPLACE : How to use a column value in the regex

On Mon, Feb 17, 2020 at 06:37:11AM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/functions-matching.html > Description: > > The documentation doesn't talk about any regex syntax for using a

Re: Clarification on interactions between query parameters and partial indexes

On Fri, Feb 14, 2020 at 11:42:34AM -0500, Tom Lane wrote: > PG Doc comments form writes: > > In section "11.8 Partial Indexes" it states the following: > > > "Matching takes place at query planning time, not at run time. As a result, > > parameterized query clauses do not work with a partial

Re: pg_buffercache query example results misleading, grouping by just relname, needs schema_name

On Wed, Feb 12, 2020 at 11:55:51PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/pgbuffercache.html > Description: > > The pg_buffercache query example results are misleading. The "group by"

Re: COPY performance vs insert

On Wed, Feb 12, 2020 at 09:25:05AM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/populate.html > Description: > > I think this could be clearer. In particular, performance of COPY vs INSERT >