Re: [PERFORM] Excessive rows/tuples seriously degrading query

2003-12-17 Thread Tom Lane
Hannu Krosing <[EMAIL PROTECTED]> writes: > Chadwick, Russell kirjutas L, 13.12.2003 kell 00:40: >> Can anyone explain why this table which has never had more than a >> couple rows in it shows > 500k in the query planner even after running >> vacuum full. > It can be that there is an idle transact

Re: [PERFORM] Excessive rows/tuples seriously degrading query

2003-12-16 Thread Hannu Krosing
Chadwick, Russell kirjutas L, 13.12.2003 kell 00:40: > > Hello everyone. > Can anyone explain why this table which has never had more than a > couple rows in it shows > 500k in the query planner even after running > vacuum full. Its terribly slow to return 2 rows of data. The 2 rows > in it are

[PERFORM] Excessive rows/tuples seriously degrading query performance

2003-12-16 Thread Chadwick, Russell
  Hello everyone. Can anyone explain why this table which has never had more than a couple rows in it shows > 500k in the query planner even after running vacuum full.  Its terribly slow to return 2 rows of data.  The 2 rows in it are being updated a lot but I couldn't find any explanation for