Hi! PG8,4, Window XP, Python.
I have a program that makes many picture version from an original with XNView effects. Because I want preserve the integrity, previous datas, I used transactions, and PGSQL. The main problem with blobs that insertion is good, the select is good, but the deletion is very slow. I had 300 MB source, and 4 GB database with effect-converted images. The table was: blobs(id integer, file_id integer, ext char(3), size integer, blob bytea) with primary key, and some index on file_id, ext, size. But these indexes not matter, when I stored the blobs in the picture table in fields, I also got this problem. Extremely slow - this meaning that I started a query that do: delete * from blobs where file_id in () (file_id have index, and select is very fast on it). And I need to wait 2 hours for the deletion, and 1 hours for vacuum... :-( I tried with PySQLite also. The deletion is also slow, but it was 30 minutes only, but compact was 1 hours process... Ok, I know that better to store blobs in other ways, but I want to preserve the integrity, and anydbm (for example) is does not browsable, etc... Prev. I tried with Text fields (and with Hexlify), but it was also slow. So something is basically wrong with blobs, or blob deletion... Thanks for your help: dd