On Tue, 18 Oct 2005 00:25:25 +0100 Simon Riggs <[EMAIL PROTECTED]> wrote: > > Please try this patch and see if it reduces the CS storm: > > http://archives.postgresql.org/pgsql-patches/2005-10/msg00091.php
Yes, I will. I'd been trying to figure out what triggered it, as I was unable to reproduce it for a while, but it gets there eventually. I had just re-started with auto vacuum off, as that might be the trigger? I'll apply the patch, re-build and re-start with auto vacuum back on, they way I'm running when I know I'll see it. > > Do you have access to another similar machine to do comparative testing? > Do you have access to another machine with different CPU arch? It would > be good to firmly isolate this to a CPU architecture interaction issue. I do have access to a windows version of the DL-380 but it's only a single CPU. I've a dual AMD server at home, but I cannot run against the db there (reverse VPN?). I'd need that reproducibility Tom wanted that I have not gotten to yet. > > Are the Xeons particularly old models? How new is the server? It is a HP Proliant (post Compaq merger) DL-380. A couple years old. Thanks, Rob ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq