[PERFORM] Very slow update statement on 40mio rows

2013-02-15 Thread Florian Schröck
log |  1790 | 2013-01-30 14:02:48 |   0 |    0 | 0 | NEW | f  | f    | 0001-01-01 00:00:00 | ++-+---+-+-+--+---+-++--+-+ -- Mit freundlichen Grüßen Best regards Florian Schröck IT

Re: [PERFORM] Very slow update statement on 40mio rows

2013-02-15 Thread Florian Schröck
inutes with the original statement. Best regards, Florian On 02/15/2013 03:59 PM, Kevin Grittner wrote: > Florian Schröck wrote: > >> UPDATE BackupFiles >>SET nTapeNr=0, nAFIOCounter=0, nBlockCounter=0, >>cStatus='NEW'::StatusT, bOnSetBlue=false, >>

Re: [PERFORM] Very slow update statement on 40mio rows

2013-02-26 Thread Florian Schröck
Hello Merlin, thanks for the feedback, I forwarded this to my developer, this is an interesting approach. -- Best regards Florian Schröck On 02/19/2013 09:04 PM, Merlin Moncure wrote: > On Fri, Feb 15, 2013 at 9:32 AM, Florian Schröck wrote: >> Hello Kevin, >> not updating