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

Поиск
Список
Период
Сортировка
От Eric Hill
Тема Re: [GENERAL] storing large files in database - performance
Дата
Msg-id CY1PR05MB2265E7120E60159FD6BE34A5F0E60@CY1PR05MB2265.namprd05.prod.outlook.com
обсуждение исходный текст
Ответ на Re: [GENERAL] storing large files in database - performance  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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
figureout 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.



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] database is not accepting commands
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: [GENERAL] database is not accepting commands