Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
> Kevin Grittner, 08.11.2010 18:01:
>> I would add a request to see the output from `VACUUM VERBOSE
>> employee;`.
> Do you really think that VACCUM is the problem? If the OP only
> selects two columns it is apparently fast.
> If he selects all columns it's slow, so I wouldn't suspect dead
> tuples here.
>
> My bet is that there are some really large text columns in
> there...
That's something we can infer pretty well from the verbose output.
-Kevin