On Mon, 2004-06-07 at 15:57, John Liu wrote:
> We upgraded from 7.2 to 7.4, it looks like everything working, but
> when I issue a query such as select * from tab (tab has about 2-3
> million records), it causes core dump. I tuned some the parameters, it
> still produce the core.
How odd. Anything else cause it to dump quickly?
Does it core if you just run explain select ... (note the lack of an
analyze there, as we don't want anything but the planner to run.)
Does selecting from another large table cause the same problem, or is
this a one table thing?