On Mon, 2004-06-07 at 16:19, Bill Moran wrote: > "John Liu" <[EMAIL PROTECTED]> 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. > > It's unlikely that any config settings are causing coredumps. > > Did you backup and rebuild the database during the upgrade procedure? If not, > this could be your problem. You can't run 7.4 on a 7.2 database.
7.4 should refuse to start, without touching the data directory in the old 7.2 directory You should get a version mismatch and a bail out when trying to do so. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
