using Postgres to store many small files
От | Matthew Hixson |
---|---|
Тема | using Postgres to store many small files |
Дата | |
Msg-id | 7887996D-6D76-11D8-B832-000A95D05926@poindextrose.org обсуждение исходный текст |
Список | pgsql-general |
I am currently working on a Java web application. We are making use of the JDBC driver for Postgres 7.4.1. Part of our application allows the administrators to manage a large number of small images, most of them not exceeding 5KB. There is about a gigabyte of these small files. We're currently storing the files on disk and the other information about the file in the database (historical reasons that I won't complain about here). I recently discovered the Hibernate project and was pleasantly surprised how simple it was to store an image in Postgres as a bytea using Hibernate's BLOB support. I'm wondering if Postgres would have any problem handling all of our files if we were to put them into Postgres as bytea data. And how well would Postgres scale as the number of files increased? Our Java application and Postgres are currently running on the same machine, a dual Xeon 2.6Ghz with 1GB of RAM. We are currently not working this machine very hard at all. Thanks, -M@
В списке pgsql-general по дате отправления: