Re: Can any_value be used like first_value in an aggregate?

On Tue, Jun 25, 2024 at 13:08:45 -0400, Tom Lane wrote: Not really. It will work that way in simple cases, but I think the behavior stops being predictable if the input gets large enough to induce the planner to use parallel aggregation. In any case, the example shown isn't amazingly efficie

Re: PostgreSQL Community Enquire !

On 6/25/24 12:00, madhav sira wrote: Hi Team, Just wanted to reconfirm, for any queries or discussion on postgres coding/peformance tuning related questions, I have email to ( pgsql-gene...@postgresql.org ) and discussion will continue on emails only but 

Re: Replication After manual Failover

How were you replicating? What was the status of the replication? On Tue, Jun 25, 2024 at 1:20 PM Yongye Serkfem wrote: > Hello Engineer, > Below is the error message I am getting after failing over to the standby > and reconfiguring the former master as the new standby. Any help will be > appr

Re: Replication After manual Failover

On Tue, Jun 25, 2024 at 2:39 PM Muhammad Ikram wrote: > Hi, > > Please reinitialize using pg_basebackup > Might not be possible during a switchover. > or use pg_rewind > > > > Muhammad Ikram > Bitnine Global > > > On Tue, 25 Jun 2024 at 22:20, Yongye Serkfem wrote: > >> Hello Engineer, >> Bel

Re: Replication After manual Failover

Hi, Please reinitialize using pg_basebackup or use pg_rewind Muhammad Ikram Bitnine Global On Tue, 25 Jun 2024 at 22:20, Yongye Serkfem wrote: > Hello Engineer, > Below is the error message I am getting after failing over to the standby > and reconfiguring the former master as the new stand

Replication After manual Failover

Hello Engineer, Below is the error message I am getting after failing over to the standby and reconfiguring the former master as the new standby. Any help will be appreciated. [image: image.png]

Re: Can any_value be used like first_value in an aggregate?

Bruno Wolff III writes: > For example, is output of 10 guaranteed in the following: > bruno=> select any_value(x order by x desc) from generate_series(1,10) as x; > any_value > --- > 10 > (1 row) Not really. It will work that way in simple cases, but I think the behavior stops

Can any_value be used like first_value in an aggregate?

For example, is output of 10 guaranteed in the following: bruno=> select any_value(x order by x desc) from generate_series(1,10) as x; any_value --- 10 (1 row) The use case is that I want to return a value of one column that is paired with the maximum value of another column in

Re: Postgresql python in upgraded version 16.2

On 6/21/24 00:33, Šika Michal wrote: Hello, I get the install packages from this repository: https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8.9-ppc64le/ I would go here: https://yum.postgresql.org/contac

Re: Issue with pgstattuple on Sequences in PostgreSQL

> I agree it’s a documentation bug Thanks for confirmation, then maybe I can start a new thread in pgsql-hackers about this bug and I can myself create a patch for the same. > then the regression test should be fixed as well I will add regress test for sequences as well. We can remove *SEQUENCE*