[PERFORM] vacuum internals and performance affect

2011-11-29 Thread MirrorX
dear all, i am trying to understand if i am missing something on how vacuum works. i ve read the manual, and did some research on the web about that but i am still not sure. to my understanding, vacuum just marks the dead rows of a table so that from that point on that space would be re-used for

Re: [PERFORM] WAL in RAM

2011-11-29 Thread Marcus Engene
On 10/29/11 10:11 , Scott Marlowe wrote: In over 10 years of using hardware RAID controllers with battery backup on many many machines, I have had exactly zero data loss due to a failed battery backup. Of course proper monitoring is important, to make sure the batteries aren't old and dead, but

Re: [PERFORM] PostgreSQL 9.1 : why is this query slow?

2011-11-29 Thread Joost Kraaijeveld
On Mon, 2011-11-28 at 11:36 -0600, Kevin Grittner wrote: > "Kevin Grittner" wrote: > > > If you really want the intersection, perhaps: > > Or maybe closer: > > with x as > ( > select > word, > count(*) as countall, > count(case when filetype = 'f' then 1 else nu