I asked this on general, but didn't receive any responses. Is it possible
via SQL to identify the time of the last stat reset (or pg_stat_reset()
call)? This is what I'm lacking to be able to measure query activity
volume over time via SQL, i.e., maybe a function similar to the fictitious
archives, IMO. What a loss.
Question: What's the next best site/tool for searching technical usenet
archives??
Regards,
Ed Loehr
Tom Lane wrote:
Ed Loehr [EMAIL PROTECTED] writes:
What is the status of the genetic algorithm query optimizer? Is this
supposed to work well on many-table joins, or has it fallen out of favor
or in disrepair?
It's supposed to work ;-). I'm not sure that the default parameters
, is there a reason why GEQO is off by
default in the ODBC driver (postdrv.exe)? I vaguely recall something
about this from a year ago, but can't find it.
Regards,
Ed Loehr
, since
GEQO has essentially no influence over whether the produced plan is
correct or not. GEQO merely forces specific choices of join order.
All else is in the core planner.
You can remove the randomness by setting the Seed configuration value, if
the docs are correct.
Regards,
Ed Loehr
: fk_employee_currency referential integrity violation - key '27'
referenced from employee not found in currency
Regards,
Ed Loehr