Unable to perform any queries on a table

From: Carol Cheung <cacheung(at)consumercontact(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Unable to perform any queries on a table
Date: 2006-08-11 16:16:35
Message-ID: 44DCAD63.7040609@consumercontact.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
I have table that had appx 675K rows. Performing SELECTs were fine. Then
I added appx 300K records to the table, all queries on this table are
now stalling.
Trying to "EXPLAIN ANALYZE" the queries aren't returning anything.
Vacuuming (not full) is hanging as well.

Does anyone have any pointers on how to investigate what's going on?

Thanks,
C

Browse pgsql-novice by date

  From Date Subject
Next Message Tomeh, Husam 2006-08-11 16:21:18 Re: Unable to perform any queries on a table
Previous Message Tom Lane 2006-08-11 16:06:09 Re: Readline, Postgresql and Solaris