147 reputation
8
bio website
location
age
visits member for 2 years, 7 months
seen Oct 7 at 14:05

Mar
23
awarded  Popular Question
Feb
2
accepted Why is autovacuum using so much IO when running on a partition's master table after upgrading PosgreSQL from 8.4 to 9.1?
Feb
1
comment Why is autovacuum using so much IO when running on a partition's master table after upgrading PosgreSQL from 8.4 to 9.1?
@voretaq7 Thanks for the suggestion, they were very helpful!
Feb
1
answered Why is autovacuum using so much IO when running on a partition's master table after upgrading PosgreSQL from 8.4 to 9.1?
Jan
31
comment Strange high CPU I/O wait on postgresql server
Did you manage to find what was happening. We're experiencing a similar situation (higher than normal cpu-wait and io activity). Using iotop we traced it to autovacuum but still don't know what's going on serverfault.com/questions/474227/…
Jan
31
revised Why is autovacuum using so much IO when running on a partition's master table after upgrading PosgreSQL from 8.4 to 9.1?
Fix title
Jan
31
revised Why is autovacuum using so much IO when running on a partition's master table after upgrading PosgreSQL from 8.4 to 9.1?
Better explanation of triggers
Jan
31
asked Why is autovacuum using so much IO when running on a partition's master table after upgrading PosgreSQL from 8.4 to 9.1?
Dec
13
comment PostgreSQL server: 10k RPM SAS or Intel 520 Series SSD drives?
@CraigRinger Data is being streamed to a slave server and we can afford a small loss.
Oct
22
awarded  Critic
Oct
15
awarded  Excavator
Oct
15
revised PostgreSQL 9.0 HA load balancing between servers
Updated URL
Oct
15
suggested suggested edit on PostgreSQL 9.0 HA load balancing between servers
Oct
15
awarded  Scholar
Oct
15
accepted When using RAID10 + BBWC why is it better to separate PostgreSQL data files from OS and transaction logs than to keep them all on the same array?
Oct
15
accepted PostgreSQL server: 10k RPM SAS or Intel 520 Series SSD drives?
Oct
2
comment When using RAID10 + BBWC why is it better to separate PostgreSQL data files from OS and transaction logs than to keep them all on the same array?
@voretaq7 It probably makes some sense to have them in different arrays in case one of the arrays crashes completely. If they're logical partitions and the array crashes then all partitions will be broken.
Oct
2
comment When using RAID10 + BBWC why is it better to separate PostgreSQL data files from OS and transaction logs than to keep them all on the same array?
Great link, however I don't understand what Never run SSD's in SA ZMR mode (no cache module) means. Care to clarify? Thanks!
Oct
1
asked When using RAID10 + BBWC why is it better to separate PostgreSQL data files from OS and transaction logs than to keep them all on the same array?
Oct
1
awarded  Student