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] 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