Unable to perform any queries on a table
This is a discussion on Unable to perform any queries on a table within the pgsql Novice forums, part of the PostgreSQL category; --> Hi, I have table that had appx 675K rows. Performing SELECTs were fine. Then I added appx 300K records ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 11:06 PM
| ||||
| ||||
 Unable to perform any queries on a table 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org      |
 |
« Re: Using SERIAL Column Type While Creating Some_List Table
|
Re: Unable to perform any queries on a table »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 04:08 PM.
