Re: Streaming Replication between PostGreSQL 9.2.2 on Red Hat and PostGreSQL 9.2.24 on Debian

Hi, - Doing Streaming Replication between different minor version of PG is possible but not recommended [2] - Doing Streaming Replication between different OSes is not recommended pre ICU (pg10), please check you glibc versions. [1] [1] https://www.postgresql.org/message-id/ba6132e

Re: Setting up continuous archiving

Hi, I am not sure what you call discrete / continuous. pgbackrest allows backups of different kinds: full, incremental and differential. It keeps the wals necessary to recover since the oldest backup until the current time. The retention is expressed in number of full backups. You can also specif

Hash aggregate spilling (v13) / partitions & batches

Hi, I am testing things on hash aggregate spilling in version 13.1 and am struggling to understand the partition thing in the two explains below. My understanding is that a partition corresponds to a spill file which will be treated in a later batch (which can re-spill in some cases). Am I right

Re: pg9.6 when is a promoted cluster ready to accept "rewind" request?

Hi, You might have to wait for pg_is_in_recovery to be false after the promotion. (in 9.6 pg_ctl promote doesn't wait for promotion to complete unlike 10). [1] You should CHECKOINT between 2 and 3. (or wait for the first checkpoint to finish) In the thread [2], Michael Paquier explains that: "

Gist fastbuild and performances

Hi, I am playing around with the gist fast build and comparing the result between v13 and v14. The space gain and speed increase are really awesome. When I compare the performance with the following script, I get a lot more data read into the buffers in v14 and a little slower query. Is it expec

Re: Gist fastbuild and performances

Hi, thanks for the answer. I ran the same scipt on both sides at first. Then I switched to a COPY because the CREATE TABLE generates random data. Since I got weird results, I wanted to be sure I had the same data on both versions. I ran the tests several times (and even asked a collegue to do it

Re: Gist fastbuild and performances

On Fri, Oct 8, 2021 at 4:33 PM Francisco Olarte wrote: > If you do not run the same sequences, you do not know. Note I do not > know what exact sequences you have tested, I write with only what I > have read as as input. > I ran this on both versions on fresh instances / clusters with the data f