Am Thu, Jun 13, 2024 at 09:49:46AM +0200 schrieb Laurenz Albe:
> > > Note that with DROP COLLATION you can only remove collations
> > > that belong to the encoding of your current database.
>
> src/backend/catalog/namespace.c:
>
> /*
>* get_collation_oid - find a collation by possibly qualif
On 6/13/24 23:20, Shenavai, Manuel wrote:
Hi everyone,
I would like to configure the autovacuum in a way that it runs very
frequently (i.e. after each update-statement). I tried the following
Why?
What is the problem you are trying to solve?
settings on my table:
alter table mytable set
> On Jun 13, 2024, at 6:47 AM, Daniel Gustafsson wrote:
>
> While not strictly that, there was a patch not too long ago for teaching
> postgres the PROXY protocol.
As I understand it, PROXY protocol support would be nice if one connects
through haproxy on standalone hosts, so that postgres coul
On Fri, Jun 14, 2024 at 2:20 AM Shenavai, Manuel
wrote:
> Hi everyone,
>
>
>
> I would like to configure the autovacuum in a way that it runs very
> frequently (i.e. after each update-statement). I tried the following
> settings on my table:
>
> alter table mytable set (autovacuum_vacuum_scale_fa
On Thu, 2024-06-13 at 12:26 -0700, Narek Galstyan wrote:
> I am an extension developer. I use `MarkGUCPrefixReserved` to reserve GUC
> prefixes,
> which my extension uses to help avoid accidentally misspelled config-file
> entries.
>
> However, since the reservation happens in `_PG_init()` and `
On Fri, 2024-06-14 at 06:20 +, Shenavai, Manuel wrote:
> I would like to configure the autovacuum in a way that it runs very frequently
> (i.e. after each update-statement). I tried the following settings on my
> table:
> alter table mytable set (autovacuum_vacuum_scale_factor = 0.0);
> alter
> company_nbr | company_name
> -+-
> 1 | Markowitz Herbold PC
> 2 | Markowitz Herbold PC
> 3 | Markowitz Herbold PC
> 4 | Markowitz Herbold PC
> 5 | Markowitz Herbold PC
>
