Re: [GENERAL] Question about Vacuum and Replication failures in 9.3.5

2014-09-22 Thread Joel Avni
might be visible at the slave¹s last replayed transaction? I didn¹t think the master was aware of the slave¹s state, and why locks can¹t be coordinated between the master and slave. On 9/22/14, 4:04 PM, "Adrian Klaver" wrote: >On 09/22/2014 01:42 PM, Joel Avni wrote: >> I notice

Re: [GENERAL] Question about Vacuum and Replication failures in 9.3.5

2014-09-22 Thread Joel Avni
It 9.3.5 and I did the manual vacuum to try to see where the problem might be. On 9/22/14, 4:04 PM, "Adrian Klaver" wrote: >On 09/22/2014 01:42 PM, Joel Avni wrote: >> I noticed that tables on my master PostgreSQL server were growing, and >> running vacuum full anal

[GENERAL] Question about Vacuum and Replication failures in 9.3.5

2014-09-22 Thread Joel Avni
. Thank you, Joel Avni

[GENERAL] High Disk Utilization on Master with Streaming Replication Running 9.2.4

2014-07-18 Thread Joel Avni
Hello, What is the disk overhead for streaming replication? I have noticed that PostgreSQL’s disk utilization goes up by 3x on the master when a slave is connected. The setup only uses streaming replication, i.e. archive is off, there is no archive command. I see with iotop that the wal writer p