| From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
|---|---|
| To: | Hannu Krosing <hannu(at)tm(dot)ee> |
| Cc: | Zeugswetter Andreas SB SD <ZeugswetterA(at)spardat(dot)at>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Daniel Kalchev <daniel(at)digsys(dot)bg>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: again on index usage |
| Date: | 2002-01-12 15:44:29 |
| Message-ID: | 3C4059DD.1040801@pacifier.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hannu Krosing wrote:
> One radical way to get better-than-average cache behaviour in such
> pathologigal casescases would be to discard a _random_ page instead of
> LRU page (perhaps tuned to not not select from 1/N of pages on that are
> MRU)
Yep, that's one of the ways to improve performance when the same table's
being scanned sequentially multiple times, or where different queries
sometimes scan it sequentially, other times by index. MRU would help if
you're constantly doing sequential scans.
So would flipping the scan order depending on what's in the cache :)
But none of these would mitigate the effects on other concurrent queries
that don't query the large table at all.
--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-01-12 16:21:12 | Re: checkpoint hang in 7.2b4 |
| Previous Message | Hannu Krosing | 2002-01-12 15:08:24 | Re: again on index usage |