pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Don Baccus <dhogaza@pacifier.com>
To: Hannu Krosing <hannu@tm.ee>
Cc: Zeugswetter Andreas SB SD <ZeugswetterA@spardat.at>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Daniel Kalchev <daniel@digsys.bg>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Subject: Re: again on index usage
Date: Sat, 12 Jan 2002 07:44:29 -0800
Message-ID: <3C4059DD.1040801@pacifier.com> (raw)
References: <46C15C39FEB2C44BA555E356FBCD6FA42128AD@m0114.s-mxs.net>
	<3C3F15A7.8000202@pacifier.com>
	<3C405168.8AEAAB8E@tm.ee>

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

view thread (48+ messages)  latest in thread

Message-ID: <3C4059DD.1040801@pacifier.com>
Permalink:  ../3C4059DD.1040801@pacifier.com/
Also on:    postgresql.org/message-id/3C4059DD.1040801@pacifier.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: dhogaza@pacifier.com, hannu@tm.ee, ZeugswetterA@spardat.at, pgman@candle.pha.pa.us, daniel@digsys.bg, tgl@sss.pgh.pa.us
  Subject: Re: again on index usage
  In-Reply-To: <3C4059DD.1040801@pacifier.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox