From: Peter <pmc@citylink.dinoex.sub.org>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Autovacuum endless loop in heap_page_prune()?
Date: Mon, 27 May 2024 15:49:38 +0200
Message-ID: <ZlSPciVCS5QmfP6B@disp.intra.daemon.contact> (raw)
In-Reply-To: <edf97a228e17a4702438da969893228b516142c3.camel@cybertec.at>
References: <ZlHCxjfpxXyqS_wz@disp.intra.daemon.contact>
<34f2beb882d607b360dea53433f95a767d1cad8f.camel@cybertec.at>
<ZlRk7qsfp8LKE12s@disp.intra.daemon.contact>
<edf97a228e17a4702438da969893228b516142c3.camel@cybertec.at>
On Mon, May 27, 2024 at 01:51:56PM +0200, Laurenz Albe wrote:
! > ! Apart from hardware problems, one frequent cause is upgrading glibc
! > ! (if the index on a string column or expression).
! >
! > No, this is FreeBSD, we don't normally do such things... ;)
!
! You don't update the C library, or collations never change?
I rarely update the C library.
Kernel + libraries + OS programs are a single unit here, updated
about once a year, and then by many people and with all the usual
testing.
I could lookup how often some locale was modified, but honestly, I'm
too lazy now.
| (but of course SQL_ASCII is a mistake).
Really? I re-read the chapter on Locale/CharSet Support, and I don't
see the mistake. Only one can not convert that to anything else, which
is fine in this usecase (storing arbitrary filenames from any OS in
any character-set within the same column).
regards,
PMc
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: pmc@citylink.dinoex.sub.org, laurenz.albe@cybertec.at, pgsql-general@lists.postgresql.org
Subject: Re: Autovacuum endless loop in heap_page_prune()?
In-Reply-To: <ZlSPciVCS5QmfP6B@disp.intra.daemon.contact>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox