Search Postgresql Archives

Vacuum Full - Questions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Vacuum Full - Questions
From: Patrick B <patrickbakerbr@xxxxxxxxx>
Date: Thu, 1 Sep 2016 10:41:25 +1200

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Vacuum Full - Questions
  - From: Venkata B Nagothi
- Re: Vacuum Full - Questions
  - From: Adam Brusselback

Prev by Date: Re: Clustered index to preserve data locality in a multitenant application?
Next by Date: Rackspace to RDS using DMS (Postgres 9.2)
Previous by thread: postgresql.conf RH comment, and a systemd RH note
Next by thread: Re: Vacuum Full - Questions
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux