Re: pg_largeobject - Mailing list pgsql-general

From John R Pierce
Subject Re: pg_largeobject
Date
Msg-id 56FA4C45.1030003@hogranch.com
Whole thread Raw
In response to pg_largeobject  (Sridhar N Bamandlapally <sridhar.bn1@gmail.com>)
Responses Re: pg_largeobject  (Sridhar N Bamandlapally <sridhar.bn1@gmail.com>)
List pgsql-general
On 3/29/2016 2:13 AM, Sridhar N Bamandlapally wrote:
> Hi
>
> pg_largeobject is creating performance issues as it grow due to single
> point storage(for all tables)
>
> is there any alternate apart from bytea ?
>
> like configuration large-object-table at table-column level and oid
> PK(primary key) stored at pg_largeobject
>

I would as soon use a NFS file store for larger files like images,
audio, videos, or whatever.   use SQL for the relational metadata.

just sayin'....



--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: Sridhar N Bamandlapally
Date:
Subject: pg_largeobject
Next
From: Geoff Winkless
Date:
Subject: Re: More correlated (?) index woes