Working on this level of integration is way over my head, but I'd love to see this happen and wanted to quickly +1.
I just had to refactor some code to store User Submitted Media into Postgres for background processing. While doing a bit of research, I learned that the streaming functionality is rather important even on "small" files. Postgres has to materialize the entire BYTEA type in memory when selecting; when inserting, a 2MB binary file can account for an 8MB encoded string. According to the pg-users list, this can often max out memory allocations and/or seriously degrade performance. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
