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