Request for information about postgres version 15.2 stability

Hi Team, Our company is currently supporting around 100+ postgres databases and we are planning to upgrade to version 15.2. We want to ensure that there are no major critical bugs that could impact our production systems. I would appreciate if you could provide us with information about the stabi

Fwd: Request for information about Postgres version 15.2 stability

-- Forwarded message - From: gayathri ramesh <17gayathriram...@gmail.com> Date: Tue, 18 Apr, 2023, 12:20 pm Subject: Request for information about Postgres version 15.2 stability To: Hi Team, Our company is currently supporting around 100+ postgres databases and we are planning

Re: Guidance on INSERT RETURNING order

On Tue, 18 Apr 2023 at 00:21, John Howroyd wrote: > > May I clarify the ideas being discussed so far, perhaps with a view to make a > relevant proposal. My apologies if I get anything wrong or go too far. > > As I understand it the proposal is to supplement the syntax to something like: > > INSE

Re: Question on SSI - Serializable Snapshot Isolation

Siddharth Jain writes: > When using SSI , lets say we have two > transactions T1 and T2 and there is a serialization conflict. Postgres > knows when one or the other transaction is doomed to fail > [image: image.png] Please don't use images for things that co

Re: Guidance on INSERT RETURNING order

PS: Sorry, I haven't yet thought how this might work with UPDATE or MERGE, but if I am on the right track with INSERT I'll give this some thought. On Mon, 17 Apr 2023 at 18:48, John Howroyd wrote: > May I clarify the ideas being discussed so far, perhaps with a view to > make a relevant proposa

Re: Guidance on INSERT RETURNING order

May I clarify the ideas being discussed so far, perhaps with a view to make a relevant proposal. My apologies if I get anything wrong or go too far. As I understand it the proposal is to supplement the syntax to something like: INSERT INTO table (a, b, c) VALUES ((1,2,3), (4,5,6), ...) WITH ORDI

Re: Should I add a new schema for my application?

On Sat, 2023-04-15 at 12:06 +0200, Alexander Farber wrote: > I am seeking for a general advice if it would be a good idea for a > PostgreSQL/PostGIS using application to add a third schema. > > I am using postgis/postgis Docker image which comes with "public" schema. > > Then I have loaded OpenS

Question on SSI - Serializable Snapshot Isolation

Hi All, When using SSI , lets say we have two transactions T1 and T2 and there is a serialization conflict. Postgres knows when one or the other transaction is doomed to fail [image: image.png] but will not raise serialization error until the transaction commi

Re: Suppress logging of "pg_hba.conf rejects connection for host"

On 4/16/23 10:02, ertan.kucuko...@1nar.com.tr wrote: Hello, One of the systems running PostgreSQL 14.7 receive a lot of lines like in the subject. I have below pg_hba.conf line and that line causes these to be logged. host all all 0.0.0.0/0 reject If possible, I do not want to see these lines

Re: cursor with hold must be save to disk?

the Postgresql version is 13.6 and the DECLARE COMMAND IS declare sdx_3a6c_8 no scroll binary cursor without hold for select "roalkL"."smid","roalkL"."smgeometry" from "public"."roalkL" where "roalkL"."smgeometry" && st_makeenvelope(321673.3153346270555630,3375950.6560412631370127,367212.191580321