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();

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

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 co

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

___ 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 would cause "X between 20 > and 10" to be r

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

h real workloads 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 mechani

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 effi

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 p

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: 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

RE: Unlogged partitionned tables and hot standbys

Hi, Old mail but I see the issue is corrected in PostgreSQL 18 devel, many thanks. Best regards, Phil De : Phil Florent Envoyé : jeudi 21 décembre 2023 17:00 À : pgsql-gene...@postgresql.org Objet : Unlogged partitionned tables and hot standbys Hi, Today I

pg_comebinebackup

Hi, Not really a bug but I see in the feature matrix a small typo ,https://www.postgresql.org/about/featurematrix/ Feature Matrix - PostgreSQL 17 16 15 14 13 12 11 10 9.6 9.5 9.4 9.3 9.2 9.1 9.0 8.4 8.3 8.2 8.1; ANY_VALUE aggregate: Yes: Yes: No: N