Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] storing large files in database - performance - Mailing list pgsql-general

From Daniel Verite
Subject Re: [GENERAL] storing large files in database - performance
Date
Msg-id 22003a80-6bf0-4725-8de4-92e0d82d19c6@manitou-mail.org
Whole thread Raw
In response to [GENERAL] storing large files in database - performance  (Eric Hill <Eric.Hill@jmp.com>)
List pgsql-general
Tree view 
    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 by date:

Previous
From: David Chapman
Date:
Subject: [GENERAL] Different query plan used for the same query depending on howparameters are passed
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round4 - compilation issues on RHEL 7.2