planner switch from index scan to seq scan?

From: Bob Parkinson <rwp(at)biome(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: planner switch from index scan to seq scan?
Date: 2000-07-26 10:46:21
Message-ID: Pine.OSF.4.21.0007261145390.15796-100000@omni.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Is there are simple rule for when the planner switches over from doing an
index scan to a seq scan?

Cheers,

Bob

Bob Parkinson
rwp(at)biome(dot)ac(dot)uk
------------------------------------------------------------------
Technical Manager: Biome http://biome.ac.uk/

Greenfield Medical Library,
Queens Medical Centre,
Nottingham. 0115 9249924 x 42059
------------------------------------------------------------------
We are stardust

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jules Bean 2000-07-26 10:51:33 Performance for seq. scans
Previous Message brad 2000-07-26 10:10:05 Re: 4 billion record limit?