Re: [GENERAL] storing large files in database - performance

Поиск
Список
Период
Сортировка
От Daniel Verite
Тема Re: [GENERAL] storing large files in database - performance
Дата
Msg-id 22003a80-6bf0-4725-8de4-92e0d82d19c6@manitou-mail.org
обсуждение исходный текст
Ответ на [GENERAL] storing large files in database - performance  (Eric Hill <Eric.Hill@jmp.com>)
Список pgsql-general
Дерево обсуждения 
    Eric Hill wrote:

> I am storing the file contents is of type "bytea" with "Storage" type set to
> "EXTENDED".  Storing a 12.5 MB file is taking 10 seconds

That seems really slow indeed.
Can you import the same file to the same server with psql's
\lo_import command and see how much time it takes?
That would give a baseline to compare against.


Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

В списке pgsql-general по дате отправления:

Предыдущее
От: David Chapman
Дата:
Сообщение: [GENERAL] Different query plan used for the same query depending on howparameters are passed
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round4 - compilation issues on RHEL 7.2