Re: (When) can a single SQL statement return multiple result sets?

On Mon, Apr 15, 2024 at 10:24 AM Jan Behrens wrote: > On Wed, 10 Apr 2024 19:02:48 -0400 > Tom Lane wrote: > > > > > Here, "DELETE FROM magic" returns multiple result sets, even though it > > > is only a single SQL statement. > > > > Right, so it's kind of a case that you have to support. We're

Re: Failing streaming replication on PostgreSQL 14

On 2024-Apr-15, Nicolas Seinlet wrote: > I'm using the Ubuntu/cyphered ZFS/PostgreSQL combination. I'm using > Ubuntu LTS (20.04 22.04) and provided ZFS/PostgreSQL with LTS > (PostgreSQL 12 on Ubuntu 20.04 and 14 on 22.04). What exactly is "cyphered ZFS"? Can you reproduce the problem with some

Re: (When) can a single SQL statement return multiple result sets?

On Wed, 10 Apr 2024 19:02:48 -0400 Tom Lane wrote: > Jan Behrens writes: > > While writing a PostgreSQL client library for Lua supporting > > Pipelining (using PQsendQueryParams), I have been wondering if there > > are any single SQL commands that return multiple result sets. > > Right now, I d

Re: (When) can a single SQL statement return multiple result sets?

On 11.04.24 01:02, Tom Lane wrote: And if not, why can't I write a stored procedure or function that returns multiple result sets? [ shrug... ] Lack of round tuits, perhaps. We don't have any mechanism today whereby a stored procedure could say "please ship this resultset off to the client, bu

No error message/code for commands after libpq pipeline abortion

Hello, I am writing a Lua client library for PostgreSQL using libpq that supports pipelining in an async/effect-based context. I understand that when an error occurs, all subsequent commands also fail (where PQgetResult returns PGRES_PIPELINE_ABORTED). However, only the first command has an erro

re: constant crashing hardware issue and thank you

It seems that the hardware may in fact be the issue. I ran the exact same process during the night on a much slower machine (4 core Xeon E5-1620 v4 32G Ram) and it worked fine. It did not crash and completed all the updates on 113 million records successfully. I will be bringing the i9 in for a

Re: Failing streaming replication on PostgreSQL 14

On Monday, April 15th, 2024 at 14:36, Ron Johnson wrote: > On Mon, Apr 15, 2024 at 2:53 AM Nicolas Seinlet wrote: > > > Hello everyone, > > > > Since I moved some clusters from PostgreSQL 12 to 14, I noticed random > > failures in streaming replication. I say "random" mostly because I hav

Re: efficiency random values / sequential ID values in indexes

On Mon, Apr 15, 2024 at 6:05 AM Sanjay Minni wrote: > Hi > > Is there any appreciable difference in using random values or sequential > values in indexes > > in a multi tenanted application there is a choice that the single field > ID's value is totally random / UUID or the numbers are created wi

Re: Failing streaming replication on PostgreSQL 14

On Mon, Apr 15, 2024 at 2:53 AM Nicolas Seinlet wrote: > Hello everyone, > > Since I moved some clusters from PostgreSQL 12 to 14, I noticed random > failures in streaming replication. I say "random" mostly because I haven't > got the source of the issue. > > I'm using the Ubuntu/cyphered ZFS/Pos

efficiency random values / sequential ID values in indexes

Hi Is there any appreciable difference in using random values or sequential values in indexes in a multi tenanted application there is a choice that the single field ID's value is totally random / UUID or the numbers are created with a prefix of the tenant. Since all access will be within a tenan

Re: constant crashing

Jack: On Sun, 14 Apr 2024 at 22:18, jack wrote: > The CSV files are being produced by another system, a WIndows app on a > Windows machine. I then copy them to a USB key and copy them onto the ubuntu > machine. The data is then imported via the COPY command. > > COPY master (field01,field02..fi