Postgres Pro
Downloads
Home   >   mailing lists

Vacuum Full - Questions - Mailing list pgsql-general

From Patrick B
Subject Vacuum Full - Questions
Date
Msg-id CAJNY3itdjFCr7v-uLUO=yHWj3A4L8TLFA=rtaF+wby7U0LSv5A@mail.gmail.com
Whole thread Raw
Responses Re: Vacuum Full - Questions
Re: Vacuum Full - Questions
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Nicolas Grilly
Date:
Subject: Re: Clustered index to preserve data locality in a multitenant application?
Next
From: Patrick B
Date:
Subject: Rackspace to RDS using DMS (Postgres 9.2)