Tuesday, August 19, 2008

Re: [HACKERS] Extending varlena

Am Monday, 18. August 2008 schrieb Tom Lane:
> - permissions features (more than "none" anyway)
> - better management of orphaned objects (obsoleting vacuumlo)
> - support > 16TB of large objects (maybe partition pg_largeobject?)
> - dump and restore probably need improvement to be practical for such
>   large data volumes

If you replace the third point by "maybe partition TOAST tables", replace
large object handle by TOAST pointer, and create an API to work on TOAST
pointers, how are the two so much different? And why should they be? I can
see that there are going to be needs to access large data with interfaces
that are not traditional SQL, but at least the storage handling could be the
same. That way you would solve the first two points and others for free.

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

No comments: