Re: [PERFORM] Performance with many updates

2011-08-29 Thread Tomas Vondra
On 29 Srpen 2011, 11:13, Tasdassa Asdasda wrote: > Hi. I have a table called work (id bigserial, userid int4, kind1 enum, > kind2 enum, kind3 enim, value bigint, modified timestamp) > Table will have about 2*10^6 rows (at same time - overall it can have > higher IDs but old records are eventually d

[PERFORM] Performance with many updates

2011-08-29 Thread Tasdassa Asdasda
Hi. I have a table called work (id bigserial, userid int4, kind1 enum, kind2 enum, kind3 enim, value bigint, modified timestamp) Table will have about 2*10^6 rows (at same time - overall it can have higher IDs but old records are eventually deleted (moved to separate archive table) therefore the