Thomas Kellerer <[email protected]> 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
-- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
