Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-09 Thread Tom Lane
Greg Smith <[EMAIL PROTECTED]> writes: > On Sat, 8 Sep 2007, Joshua D. Drake wrote: >> You would have to have lightning handed by God to your server to have a >> total power failure without proper shutdown in the above scenario. > Do you live somewhere without thunderstorms? This is a regular ev

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

2007-09-09 Thread Greg Smith
On Sat, 8 Sep 2007, Joshua D. Drake wrote: You would have to have lightning handed by God to your server to have a total power failure without proper shutdown in the above scenario. Do you live somewhere without thunderstorms? This is a regular event in this part of the world during the summ

Re: [PERFORM] Slow Query

2007-09-09 Thread Shawn
On Mon, 03 Sep 2007 21:10:06 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > Shawn <[EMAIL PROTECTED]> writes: > > You weren't kidding, that really made a difference. its .5 sec now > > on the run. I think the vacuuming not running for a few weeks is > > what got me. I caught an edit that had stopp