Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"

On 2022-02-19 14:54:41 +0800, Yoong S. Chow wrote: > Could you please clarify what core files are? I am truly a newbie to > postgresql.  Core files are a feature of Linux and other Unix-like operating systems. When a process crashes, the OS records its state in a file named "core" (sometimes withe

Re: tsvector string representation and parsing

Thanks, Tom. On 23/02/2022 23.30, Tom Lane wrote: =?UTF-8?Q?Johannes_Gra=c3=abn?= writes: This is a minimal example that goes wrong (but shouldn't IMHO: SELECT format('%L:1', '\:')::tsvector format(%L) is designed to produce a SQL literal, which does not have the same requirements as a

Re: tsvector string representation and parsing

=?UTF-8?Q?Johannes_Gra=c3=abn?= writes: > This is a minimal example that goes wrong (but shouldn't IMHO: >> SELECT format('%L:1', '\:')::tsvector format(%L) is designed to produce a SQL literal, which does not have the same requirements as a tsvector element ... yeah, they're close, but not clos

tsvector string representation and parsing

Hi, I am constructing a tsvector representation of some text manually because I need to provide explicit positional parameters. In some cases, the conversion fails and I get a "syntax error in tsvector". This is a minimal example that goes wrong (but shouldn't IMHO: SELECT format('%L:1',

Plan regression from 12 to 13

Hi, I have a query (generated by RequestTracker) that has regressed after upgrading from postgresql 12 to 13. The strange thing is that decreasing the effective_cache_size causes postgresql 13 to generate an acceptable plan. My setup is: 1 VM, 4 cores, 16 GB RAM (server has around 10 GB for filesys