Large objects system
Hello,
I am dealing with the old decision about hiw to store data objects and
trying to understand deep the postgre system including toast,
pg-largedataobject table and so on.
My real doubt right now is why bytea does not gets processed by toast
system even when is grow enough. Since ive read that tuples are not allowed
to expand over several dtabase pages.
Maybe someone has the explanaition for this behavior?
Thank you very much
Rafael B.C. wrote:
I am dealing with the old decision about hiw to store data objects and trying to understand deep the
postgre system including toast, pg-largedataobject table and so on.My real doubt right now is why bytea does not gets processed by toast system even when is grow enough.
Since ive read that tuples are not allowed to expand over several dtabase pages.Maybe someone has the explanaition for this behavior?
What makes you think that bytea won't get TOASTed?
It sure should.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 10/3/2013 2:22 AM, Rafael B.C. wrote:
My real doubt right now is why bytea does not gets processed by toast
system even when is grow enough. Since ive read that tuples are not
allowed to expand over several dtabase pages.
a tuple can't expand over ONE database page, and generally it prefers
packing several to many tuples per page.
any bytea field over a few bytes should be getting toasted.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general