Re: [PERFORM] [ADMIN] syslog slowing the database?

2004-03-13 Thread Magnus Naeslund(t)
Tom Lane wrote: Greg Spiegelberg <[EMAIL PROTECTED]> writes: I turned syslog back on and the restore slowed down again. Turned it off and it sped right back up. We have heard reports before of syslog being quite slow. What platform are you on exactly? Does Richard's suggestion of turning off

Re: [PERFORM] PostgreSQL and Linux 2.6 kernel.

2004-04-05 Thread Magnus Naeslund(t)
Gary Doades wrote: Has anyone else done any comparative testing with the 2.6 kernel? I know for a fact that certain stuff is recognized differently between 2.2, 2.4 and 2.6 kernels. For example i have one box that i installed debian stable on that used a 2.2 kernel which automatically tuned on

Re: [PERFORM] Wierd context-switching issue on Xeon

2004-04-26 Thread Magnus Naeslund(t)
Tom Lane wrote: Hmmm ... I've been able to reproduce the CS storm on a dual Athlon, which seems to pretty much let the Xeon per se off the hook. Anybody got a multiple Opteron to try? Totally non-Intel CPUs? It would be interesting to see results with non-Linux kernels, too. regards, tom lane

Re: [PERFORM] Query kills machine.

2004-08-24 Thread Magnus Naeslund(t)
Stef wrote: Christopher Kings-Lynne mentioned : => sort_mem = 4096 Reducing sort_mem to 4096 seems to make it run in a reasonable time again. Any idea why? The database does a whole lot of huge sorts every day, so I thought upping this parameter would help. A couple of queries do seem to run slower