139 reputation
5
bio website
location
age
visits member for 1 year, 7 months
seen Jul 7 at 18:48

Oct
16
awarded  Popular Question
May
8
accepted Read Committed Isolation Level
Apr
30
asked Read Committed Isolation Level
Apr
16
accepted postgres deadlock without explicit locking
Apr
16
comment postgres deadlock without explicit locking
Thx, by the way, will there be a deadlock in the same situation in MySQL?
Apr
16
asked postgres deadlock without explicit locking
Apr
12
accepted Database atomic operations implementation
Apr
12
comment Database atomic operations implementation
thx Mark, things made clear. But one question about MySQL: what is autocommit is on and I wrap several queries in transaction? Wrapped transaction are not possible in MySQL as far as I'm concerned
Apr
12
asked Database atomic operations implementation
Mar
21
comment PostgreSQL 9.2: vacuum returning disk space to operating system
They say this tool does the trick, haven't tried it yet though: code.google.com/p/pgtoolkit/source/browse/trunk/bin/…
Mar
20
comment PostgreSQL 9.2: vacuum returning disk space to operating system
Thanks for comprehensive answer. Actually I thought that I can place dead rows in the end of db pages by fake updates, i.e. update table set field_1 = field_1, but vacuuming that table after that operation failed to return free space, any ideas?
Mar
20
awarded  Scholar
Mar
20
accepted PostgreSQL 9.2: vacuum returning disk space to operating system
Mar
19
awarded  Supporter
Mar
19
comment PostgreSQL 9.2: vacuum returning disk space to operating system
Erwin, sorry, I forgot to mention that I don't have enough space for vacuum full. Updated the question.
Mar
19
awarded  Editor
Mar
19
revised PostgreSQL 9.2: vacuum returning disk space to operating system
added 95 characters in body
Mar
19
awarded  Student
Mar
19
asked PostgreSQL 9.2: vacuum returning disk space to operating system