On Fri, Apr 11, 2014 at 2:12 PM, Michael Paquier
wrote:
> On Fri, Apr 11, 2014 at 9:53 PM, lkcl . wrote:
>>> section: https://wiki.postgresql.org/wiki/Materialized_Views.
> When updating a materialized view, or refreshing it, you need as well
> to be aware that an exclusive l
On Fri, Apr 11, 2014 at 1:26 PM, Heikki Linnakangas
wrote:
> On 04/11/2014 03:20 PM, lkcl . wrote:
>>
>> so i had an idea. there already exists the concept of indexes. there
>> already exists the concept of "cached queries". question: would it be
>> practic
hi folks, please cc me direct on responses as i am subscribed on digest.
i've been asked to look at how to deal with around 7 billion records
(appx 30 columns, appx data size total 1k) and this might have to be
in a single system (i will need to Have Words with the client about
that). the data is