I guess not. I usually vacuum with the analyze option box checked; I must have
missed that this cycle.
It looks much better now.
Thanks!
From: bricklen [mailto:brick...@gmail.com]
Sent: Wednesday, July 17, 2013 4:12 PM
To: Ellen Rothman
Cc: pgsql-performance@postgresql.org<mailto:pg
I have the same table definition in two different databases on the same
computer. When I explain a simple query in both of them, one database uses a
sequence scan and the other uses an index scan. If I try to run the Seq Scan
version without the where clause restricting the value of uniqueid, i
