From: | dominique papin <dominique(at)infodia(dot)fr> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | blobs and the toast project ? |
Date: | 2000-11-14 09:35:52 |
Message-ID: | 3A110778.AE6F34D4@infodia.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
In june, I had to migrate a web site using paradox tables on a winNT to
a Linux box. I had chosen first postgresql 7.0 for its solid-based
features.
But unfortunately, when I started to migrate my tables, a problem raised
: the implementation of blobs in Postgre. My tables stored lots of
blobs (images, big text files, ... ) and I expected PostgreSql to store
this blobs as Paradox does, ie. in a big file where data is compressed.
But as I found out, with Postgre, 2 files are created for one blob
record and as i manipulate large amounts of blobs, it increased
seriously the amount of disk space used and the memory mangement crashed
after a while. Therefore, I turned back to use mysql.
But I kept an eye on the future development. Now I have read the summary
of TOAST project which will be implemented in the future 7.1 release. It
seems to me that it could fix my problem with blobs in postgresql, am i
right ?
If so, it would be nice and i could then migrate again to PostgreSql.
From | Date | Subject | |
---|---|---|---|
Next Message | Mickaël Jouanne | 2000-11-14 11:20:38 | smallint to bigint |
Previous Message | Marcos | 2000-11-14 09:21:26 | about time. |