Re: Select * is very slow - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Select * is very slow
Date
Msg-id 4CD7DBEC02000025000373E2@gw.wicourts.gov
Whole thread Raw
In response to Re: Select * is very slow  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-performance
Thomas Kellerer <spam_eater@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

pgsql-performance by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Select * is very slow
Next
From: Scott Carey
Date:
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?