Postgres Pro
Downloads
Home   >   mailing lists

Re: Query planner wants to use seq scan - Mailing list pgsql-performance

From Jim Nasby
Subject Re: Query planner wants to use seq scan
Date
Msg-id 56303BFA.4010003@BlueTreble.com
Whole thread Raw
In response to Re: Query planner wants to use seq scan  (Bertrand Paquet <bertrand.paquet@doctolib.fr>)
List pgsql-performance
Tree view 
On 10/27/15 3:56 PM, Bertrand Paquet wrote:
> Tonight, the index on the three field is used, may be my yesterday
> vacuum updated stats.

BTW, you can run just ANALYZE, which is *far* faster than a VACUUM on a
large table.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Partition Constraint Exclusion Limits
Next
From: Javier Muro
Date:
Subject: Scalability to more than 64 cores With PG 9.4 and RHEL 7.1 Kernel 3.10