Postgres Pro
Downloads
Home   >   mailing lists

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

From Venkata B Nagothi
Subject Re: Vacuum Full - Questions
Date
Msg-id CAEyp7J-qYvquD3TrQEBNsJ0TDJPSvS7WYv-qyUCEhFinN_bnrQ@mail.gmail.com
Whole thread Raw
In response to Vacuum Full - Questions  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: Vacuum Full - Questions  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
Tree view

On Thu, Sep 1, 2016 at 8:41 AM, Patrick B <patrickbakerbr@gmail.com> wrote:
Hi guys,

A dev has ran a VACUUM FULL command into our test database running PostgreSQL 9.5 (I know... goddamn!!!!)...

... after the Vacuum Full, some queries start using SEQ scans instead of indexes...

Does that happen because of the size of the table? The table that I'm referring to is 150MB big after the vacuum (Before was 1G)...

Yes, it is possible that sequential scans after vacuum full are cheaper than Index scans before vacuum full ? do you see improvement in query response times ? 
How does the cost differ ?

Regards,
Venkata B N

Fujitsu Australia

pgsql-general by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: Vacuum Full - Questions
Next
From: Patrick B
Date:
Subject: Re: Vacuum Full - Questions