well that's interesting because they claim to be doing exactly the same amount of I/O in terms of pages.
In the first case it's reading 3/4 of the table so it's effectively doing a sequential scan. In the second case it's
onlyscanning 7.5% so you would expect it to be slower but not that much slower.
If as you say the rows are very wide then the other part of the equation will be TOAST table I/O though. I'm not sure
whatit would look like but I bet analyze isn't optimized to handle well -- not much of postgres really knows about
TOAST.It'll be accessing the same number of TOAST records but out of a much bigger TOAST table.
--
greg