Unlogged partitionned tables and hot standbys

Hi, Today I corrected a bug on my perf tool, I had forgotten to set the unlogged attribute on the table partitions if end-user wanted to miminize the overhead of data collection and purges. Then I played a bit with partitioning, unlogged attribute and hot standby just for fun and I am a bit

Support logical replication of DDLs

Hi, As an end-user, I am highly interested in the patch https://commitfest.postgresql.org/42/3595/ but I don't fully get its main goal in its first version. It's "for all tables" that will be implemented ? If one needs a complete replication of a cluster, a hot standby will always be more

RE: pg 13 fatal error message mentionning "standby_mode"

Thanks Guillaume. After this change the error message will even be clearer in French than in the original version in fact. Regards, Phil De : Guillaume Lelarge Envoyé : mardi 8 juin 2021 13:21 À : Phil Florent Cc : pgsql-gene...@postgresql.org Objet : Re: pg

pg 13 fatal error message mentionning "standby_mode"

Hi, I had forgotten to include a restore_command and my standby database did not start (expected behavior) but the error message puzzled me : select version(); version

RE: Strange (and good) side effect of partitioning ?

ds anyway. Best regards, Phil De : Tom Lane Envoyé : vendredi 15 janvier 2021 03:12 À : Phil Florent Cc : pgsql-gene...@postgresql.org Objet : Re: Strange (and good) side effect of partitioning ? I wrote: > There's no specific mechanism in Postgres that

RE: Strange (and good) side effect of partitioning ?

15 janvier 2021 03:12 À : Phil Florent Cc : pgsql-gene...@postgresql.org Objet : Re: Strange (and good) side effect of partitioning ? I wrote: > There's no specific mechanism in Postgres that would cause "X between 20 > and 10" to be reduced to constant-false Wait, I take that b

Strange (and good) side effect of partitioning ?

Hi, I read that on Jonathan Lewis' blog : (I believe that there may be some RDBMS which will treat (e.g.) “X between 20 and 10” as being identical to “X between 10 and 20” ) I am puzzled. PostgreSQL seems NOT to treat X between 20 and 10” as being identical to “X between 10 and 20" but it's

No parallel plan on an union all subquery

Hi, I have a question about parallel plans. Here is my test case : select version(); version -- PostgreSQL

Parallel index creation & pg_stat_activity

Hi, I created an index on a 11devel base while sampling pg_stat_activity with a little tool. Tool catches a line if state = active. Collected rows are aggregated and sorted by activity percentage. Test environment : select version();