varlena objects greater than 1GB

Поиск
Список
Период
Сортировка
От Michel Pelletier
Тема varlena objects greater than 1GB
Дата
Msg-id CACxu=v+S13EigQ1fSGtkxevhKyinfTtfWfMLwG2NpXoCOaExxg@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Hello,

I have read through this thread started by pg-strom's Kohei KaiGai:


and have a similar need to Kohei for varlena objects greater than 1GB, in my case, also vector/matrix objects stored by the pggraphblas extension.  

Thinking through my options, I was wondering if it would be a good idea to use large object support to store matrix backing data, perhaps first as a varlena object up to the limit, and then switch (in the flatten_into function for my types) to an object storing the oid of the large object holding the matrix data?  

I'm going to experiment with this approach, but first wanted to raise the issue to shoot some holes in first before trying it.

Thanks!

-Michel

В списке pgsql-general по дате отправления:

Предыдущее
От: Jamesie Pic
Дата:
Сообщение: Re: Where to store Blobs?
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: [External] Re: xmin and very high number of concurrent transactions