Re: bytea encode performance issues - Mailing list pgsql-general

From Tom Lane
Subject Re: bytea encode performance issues
Date
Msg-id 12837.1218031839@sss.pgh.pa.us
Whole thread Raw
In response to Re: bytea encode performance issues  (Sim Zacks <sim@compulab.co.il>)
Responses Re: bytea encode performance issues  (Sim Zacks <sim@compulab.co.il>)
List pgsql-general
Sim Zacks <sim@compulab.co.il> writes:
> After the alter table, then I have to update each row with an
> update dbmail_messageblks set messageblk=messageblk;
> so that it uses the new storage.

I wouldn't actually bet on that changing anything at all ...
I'd try something like messageblk = messageblk || '' to make
completely sure the value gets detoasted.

            regards, tom lane

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: Invocation overhead for procedural languages
Next
From: Richard Huxton
Date:
Subject: Re: bytea encode performance issues