Thread: blobs and the toast project ?

blobs and the toast project ?

From
dominique papin
Date:
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.


Re: blobs and the toast project ?

From
Neil Conway
Date:
On Tue, Nov 14, 2000 at 10:35:52AM +0100, dominique papin wrote:
> 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 ?

Actually, your problem is fixed in 2 different ways.

1) With TOAST

2) LOs have been improved. My understanding is that instead of
storing each LO in a separate file, 7.1 will store all the LOs in
a single file.

I have been using a pre-7.1 snapshot for development, and
it's been perfectly useable.

Regards,

Neil

--
Neil Conway <neilconway@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

Hard work never hurt anyone - but why take chances?