stion: Why is this so slow, even though it's reading from disk?
On 24 March 2015 at 07:49, David Rowley wrote:
> On 21 March 2015 at 23:34, Roland Dunn wrote:
>>
>>
>> If we did add more RAM, would it be the effective_cache_size setting
>> that we would alte
_size setting
that we would alter? Is there a way to force PG to load a particular
table into RAM? If so, is it actually a good idea?
Thanks again,
R
On 21 March 2015 at 09:10, Maxim Boguk wrote:
>
> On Sat, Mar 21, 2015 at 6:01 AM, Roland Dunn wrote:
>>
>> Hi,
>&
Hi,
Wonder if anyone can help.
Have a lookup table where the primary key is a native uuid type
(filled with uuid's of type 4), around 50m rows in size.
Have a separate table, table A, similar size (around 50m rows).
Primary key in table A is the standard integer, nextval, etc type
primary key. Ta
