Postgres Pro
Downloads
Home   >   mailing lists

Unable to perform any queries on a table - Mailing list pgsql-novice

From Carol Cheung
Subject Unable to perform any queries on a table
Date
Msg-id 44DCAD63.7040609@consumercontact.com
Whole thread Raw
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Readline, Postgresql and Solaris
Next
From: "Tomeh, Husam"
Date:
Subject: Re: Unable to perform any queries on a table