PG Index<->seqscan problems...

From: Michael Loftis <mloftis(at)wgops(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: PG Index<->seqscan problems...
Date: 2002-06-11 03:00:33
Message-ID: 3D0567D1.3090603@wgops.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

OK I know this has been long delayed but I've finished some work on the
above. The coster is actually doing a fairly good job. I only recieved
one submission from someone with data that replicated the problem, and
was myself hard pressed to replicate the situation. It's more-or-less a
fencepost error. I don't have the expertise to figure out how to make
the coster more determinate in these types of situations. However as
some suggested the practice of storing actual run data from query plans
(esp. when using precompiled and/or stored queries) would probably help
eliminate these byt adding another weight factor (IE last time we did
this it took X amount of time, and we estimated Y, so lets try it this
way instead).

Unfortunately I'm a bit too pressed for time looking for a job to
continue pursuing this research any further.

Michael Loftis

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-06-11 03:18:09 Re: [HACKERS] Efficient DELETE Strategies
Previous Message Bruce Momjian 2002-06-11 02:53:00 Re: [HACKERS] Efficient DELETE Strategies