Tobias Brox wrote:
[Tobias Brox - Tue at 06:04:34PM +0200]
(...) and at one
point in the code I'm even asking the database for explain plan, grepping
out the estimated cost number, and referring the user to take contact with
the IT-dept if he really needs the report. But I digress.
I just
Btw - I tried playing around with some of the other planner cost
constants but I wasn't able to get the planner to choose the index
scan. It seems like the issue is that the estimated cost for
fetching one row from the index (3.02) is a little high in my
case. Is there any way that I can adjust
I have in my possession some performance tuning documents authored by Bruce
Momjian, Josh Berkus, and others. They give good information on utilities to
use (like ipcs, sar, vmstat, etc) to evaluate disk, memory, etc. performance
on Unix-based systems.
Problem is, I have applications running on
Lane Van Ingen wrote:
I have in my possession some performance tuning documents authored by Bruce
Momjian, Josh Berkus, and others. They give good information on utilities to
use (like ipcs, sar, vmstat, etc) to evaluate disk, memory, etc. performance
on Unix-based systems.
Problem is, I