Re: [GENERAL] Problem with table slowing down - Help with EXPLAIN reqd

2006-07-26 Thread Q
On 27/07/2006, at 2:00 PM, Peter Watling wrote: I have a table with only 30 odd records... I use one field on each record as a sort of status, as a means of handshaking between a number of clients... It works OK in theory.. however, over time ( just days ) it gets progressively slower.. its as i

[GENERAL] Problem with table slowing down - Help with EXPLAIN reqd

2006-07-26 Thread Peter Watling
I have a table with only 30 odd records... I use one field on each record as a sort of status, as a means of handshaking between a number of clients... It works OK in theory.. however, over time ( just days ) it gets progressively slower.. its as if postgreSQL is keep a list of all updates... I tr