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.
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
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
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,
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
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
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
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
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
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
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
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/PostgreSQL combination. I'm using Ubuntu LTS
(20.04 22.04) and
12 matches
Mail list logo
