Re: Warm-up cache may have its virtue

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Warm-up cache may have its virtue
Date: 2006-01-14 21:13:56
Message-ID: dqbpg6$qnq$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


"Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2006-01-15 05:08:42 Re: Surrogate keys (Was: enums)
Previous Message mark 2006-01-14 21:08:44 Re: Surrogate keys (Was: enums)