On Wed, Sep 17, 2008 at 7:18 AM, Vivek_Sharan <[EMAIL PROTECTED]> wrote: > Yes that's true and that's planned. We will migrate to Oracle. But as of now > need some pointers on solving the problem in hand.
Well, updating to the latest 7.4 version would be a very very good move. There are some very real and nasty data loss bugs in 7.4.5. It's an in place update that requires only a few minutes of downtime. I would guess you've got something like sort_mem set too high. P.s. If you think PostgreSQL is hard to troubleshoot, I can't wait to see you running Oracle. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
