Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum Full - Questions - Mailing list pgsql-general

From Adam Brusselback
Subject Re: Vacuum Full - Questions
Date
Msg-id CAMjNa7dd1WmgMkp-fMbNtyMm9dDot_7_++pPnGrT+SrANWUWew@mail.gmail.com
Whole thread Raw
In response to Vacuum Full - Questions  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
Tree view
Yes that very well could happen because the size of the table changed, as well as stats being more accurate now. Just because you have a seq scan doesn't mean the planer is making a bad choice.

pgsql-general by date:

Previous
From: Nicolas Grilly
Date:
Subject: Re: Clustered index to preserve data locality in a multitenant application?
Next
From: Venkata B Nagothi
Date:
Subject: Re: Vacuum Full - Questions