Re: Performance
| От | Ron Johnson |
|---|---|
| Тема | Re: Performance |
| Дата | |
| Msg-id | CANzqJaBefx4QaM_jOP1FkuNCA4iugFWukUGYnVG4vQXJ3i7yPg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Performance (Anex Hul <anexsql2014@gmail.com>) |
| Список | 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
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 по дате отправления: