Re: [HACKERS] pg_dump/restore to convert BLOBs to LZTEXT (optional!)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: pgsql-hackers(at)postgreSQL(dot)org, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [HACKERS] pg_dump/restore to convert BLOBs to LZTEXT (optional!)
Date: 2000-08-04 01:10:53
Message-ID: 28080.965351453@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> For BLOBS that are referenced in more than one table, this will duplicate
> the text which may be a problem,

As well as break the semantics: if you have a multiply-referenced BLOB
then you can update it through any reference and the changes are visible
through all the references. Not so after you convert the data into
non-BLOB values.

Another problem is that even if you manage to restructure the database
properly, you can't do anything to help with conversion of the
application code that talks to the database (not even the functions
and triggers/rules that may appear right in the database).

AFAICS converting from BLOB to TOAST storage is going to require a
fair amount of actual thought and work on the part of the DB
programmer/admin. I don't see that pg_dump can help meaningfully,
and I'd just as soon resist feature bloat in pg_dump.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Warner 2000-08-04 01:29:28 Re: [HACKERS] pg_dump/restore to convert BLOBs to LZTEXT (optional!)
Previous Message Philip Warner 2000-08-04 00:54:02 pg_dump/restore to convert BLOBs to LZTEXT (optional!)

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-08-04 01:24:23 Re: Raw constraint & pg_relcheck.rcsrc
Previous Message Tatsuo Ishii 2000-08-04 01:07:38 Re: comparing rows