Re: [GENERAL] strange hot_standby behaviour

2012-10-06 Thread Jan Nielsen
On Mon, Oct 1, 2012 at 11:43 AM, Andreas Pfotenhauer wrote: > OS is debian squeeze, pg installed is the latest 9.2.1 from > pgapt.debian.net. Logs where checked, no errors/warnings at all. Query plans > have been checked, no changes before/after. The changed behavior only > manifested in the drop

Re: [GENERAL] strange hot_standby behaviour

2012-10-01 Thread Andreas Pfotenhauer
This could be just about anything. Which OS are you running? Did you check any logs when everything went crazy? Sorry, should have been more verbose. OS is debian squeeze, pg installed is the latest 9.2.1 from pgapt.debian.net. Logs where checked, no errors/warnings at all. Query plans have

Re: [GENERAL] strange hot_standby behaviour

2012-10-01 Thread Lonni J Friedman
On Mon, Oct 1, 2012 at 7:28 AM, pfote wrote: > Hi, > > I had a very strange effect on the weekend that smells like a bug, so i'd > like so share it. > > Setup: > machine A: 16 CPU Cores (modern), 128GB RAM, nice 6-drive SAS Raid-10 > machines B, C: 8 Cores (substantially older than A), 48GB Ram, s

[GENERAL] strange hot_standby behaviour

2012-10-01 Thread pfote
Hi, I had a very strange effect on the weekend that smells like a bug, so i'd like so share it. Setup: machine A: 16 CPU Cores (modern), 128GB RAM, nice 6-drive SAS Raid-10 machines B, C: 8 Cores (substantially older than A), 48GB Ram, some scsi Raid, substantially slower than A The workloa