[GENERAL] disk writes within a transaction
От | 2xlp - ListSubscriptions |
---|---|
Тема | [GENERAL] disk writes within a transaction |
Дата | |
Msg-id | 81F0A30F-0912-4FD0-B496-C79167B1DD4A@2xlp.com обсуждение исходный текст |
Ответы |
Re: [GENERAL] disk writes within a transaction
Re: [GENERAL] disk writes within a transaction |
Список | pgsql-general |
Can someone enlighten me to how postgres handles disk writing? I've read some generic remarks about buffers, but that'sabout it. We have a chunk of code that calls Postgres in a less-than-optimal way within a transaction block. I'm wondering where toprioritize fixing it, as the traffic on the wire isn't an issue. Basically the code looks like this: begin; update foo set foo.a='1' where foo.bar = 1; ... update foo set foo.b='2' where foo.bar = 1; ... update foo set foo.c='3' where foo.bar = 1; commit; If the updates are likely to be a memory based operation, consolidating them can wait. If they are likely to hit the disk,I should schedule refactoring this code sooner than later.
В списке pgsql-general по дате отправления: