Eric Hill schrieb am 16.05.2017 um 14:25: > I have a node.js application using PostgreSQL to store uploaded > files. The column in which 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, and storing a 25MB file is taking 37 seconds. > Two notable things about those numbers: It seems like a long time, > and the time seems to grow exponentially with file size rather than > linearly. > > Do these numbers surprise you?
When my (JDBC based) SQL client and the database server are on the same computer, I can store a 45MB file about 4 seconds, a 240MB file in about 20seconds When I do the same with a server on the (same) network, the 45MB take about 9 seconds, the 240MB take about 60 seconds. So yes, these numbers sound a bit surprising. > Could there be something about my methodology that is slowing things down? How far are your app server and the database server apart? Maybe it's just a case of a slow network Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
