>>> On Fri, Jul 18, 2008 at 2:35 PM, in message <[EMAIL PROTECTED]>, Sanjay Rajdev <[EMAIL PROTECTED]> wrote: > Thanks for the thought, I think that this can be the problem, as earlier > there was no indexing on the column, but 2 days back we added index on 5 of > columns in the table and "somedate" is one of them. This problem have been > noticed after the index's were added. > I can't test this out as this happens while people are using the software, Try adding another index on the column (with a different index name) using CREATE INDEX CONCURRENTLY. Then drop the old index. -Kevin
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
