Re: storing large files in database - performance

From: Eric Hill <Eric(dot)Hill(at)jmp(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: storing large files in database - performance
Date: 2017-05-16 15:08:00
Message-ID: CY1PR05MB2265E7120E60159FD6BE34A5F0E60@CY1PR05MB2265.namprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

OK, thanks very much. It seems like my process is somehow flawed. I'll try removing some layers and see if I can figure out what is killing the performance.

Eric

>
> Do these numbers surprise you? Are these files just too large for
> storage in PostgreSQL to be practical? Could there be something about
> my methodology that is slowing things down?

Yes, it does surprise me. I just tested inserting an 11MB file using
psycopg2(Python) and it was less then a second.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-05-16 15:20:58 Re: database is not accepting commands
Previous Message Adrian Klaver 2017-05-16 15:03:55 Re: database is not accepting commands