Re: Warm-up cache may have its virtue - Mailing list pgsql-hackers

From Qingqing Zhou
Subject Re: Warm-up cache may have its virtue
Date
Msg-id dqbpg6$qnq$1@news.hub.org
Whole thread Raw
In response to Warm-up cache may have its virtue  (Qingqing Zhou <zhouqq@cs.toronto.edu>)
Responses Re: Warm-up cache may have its virtue
List pgsql-hackers
"Qingqing Zhou" <zhouqq@cs.toronto.edu> wrote
>
> I wonder if we should really implement file-system-cache-warmup strategy
> which we have discussed before. There are two natural good places to do
> this:
>
> (1) sequentail scan
> (2) bitmap index scan
>

For the sake of memory, there is a third place a warm-up cache or pre-read 
is beneficial (OS won't help us):
(3) xlog recovery

Regards,
Qingqing




pgsql-hackers by date:

Previous
From: mark@mark.mielke.cc
Date:
Subject: Re: Surrogate keys (Was: enums)
Next
From: Greg Stark
Date:
Subject: Re: Surrogate keys (Was: enums)