Vacuum Full - Questions

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Vacuum Full - Questions
Date: 2016-08-31 22:41:25
Message-ID: CAJNY3itdjFCr7v-uLUO=yHWj3A4L8TLFA=rtaF+wby7U0LSv5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)...

Cheers
Patrick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick B 2016-08-31 22:41:27 Rackspace to RDS using DMS (Postgres 9.2)
Previous Message Nicolas Grilly 2016-08-31 22:31:49 Re: Clustered index to preserve data locality in a multitenant application?