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