Re: [ADMIN] Vacuum wait time problem

2009-02-15 Thread Kevin Grittner
>>> Scott Marlowe wrote: > On Fri, Feb 13, 2009 at 7:02 PM, Tom Lane wrote: >> Scott Marlowe writes: >>> On Fri, Feb 13, 2009 at 5:02 PM, Michael Monnerie >>> wrote: vacuum_cost_delay = 0 That was the trick for me. It was set to 250(ms), where it took 5 hours for a vacuum to run

Re: [ADMIN] Vacuum wait time problem

2009-02-15 Thread Tom Lane
"Kevin Grittner" writes: > I don't know what other people have found useful, but when I > experimented with this in our environment, it seemed like I should > just treat vacuum_cost_delay as a boolean, where 0 meant off and 10 > meant on, and tune it by adjusting vacuum_cost_limit. The granularit

[ADMIN] initdb causes Segmentation fault

2009-02-15 Thread Haluk Durmus
I'm running ubuntu 8.04 on a Linux 2.6.24-22-generic #1 SMP Mon Nov 24 19:35:06 UTC 2008 x86_64 GNU/Linux machine. there was same porblem with preinstalation of progres and superuser. So I tried to solve it by reinstall postgres 8.3 with apt-get after removing it with sudo apt-get --purge r