Unable to perform any queries on a table

Поиск
Список
Период
Сортировка
От Carol Cheung
Тема Unable to perform any queries on a table
Дата
Msg-id 44DCAD63.7040609@consumercontact.com
обсуждение исходный текст
Список 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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Readline, Postgresql and Solaris
Следующее
От: "Tomeh, Husam"
Дата:
Сообщение: Re: Unable to perform any queries on a table