Re: Performance - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Performance
Date
Msg-id CANzqJaBefx4QaM_jOP1FkuNCA4iugFWukUGYnVG4vQXJ3i7yPg@mail.gmail.com
Whole thread Raw
In response to Re: Performance  (Anex Hul <anexsql2014@gmail.com>)
List pgsql-admin
On Mon, Dec 16, 2024 at 9:05 AM Anex Hul <anexsql2014@gmail.com> wrote:
[snip] 

2. Are you truncating the table after each test run, or deleting all records, or appending?

created new schema for each run.

3. Is the blob data stored in BYTEA column data, or are you using the (discouraged) "Large Objects"?

Blob storage

Postgresql does not know what "Blob storage" means.
 

4. How are you loading the blob data?

used the Import data using a COPY statement, followed this doc

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-use-pg-azure-storage?tabs=portal-01%2Cportal-02%2Cportal-03%2Cportal-04%2Cportal-05

If you're using a Microsoft extension, then you'd better ask Microsoft.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: Anex Hul
Date:
Subject: Re: Performance
Next
From: Fabrice Chapuis
Date:
Subject: pg_stat_statements_reset