Re: Performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Dec 16, 2024 at 9:05 AM Anex Hul <anexsql2014@xxxxxxxxx> 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!

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux