Jason Long <mailing.list@xxxxxxxxxxxxxxxxxxxxx> writes: > I have a query that takes 2 sec if I run it from a freshly restored > dump. If I run a full vacuum on the database it then takes 30 seconds. > Would someone please comment as to why I would see a 15x slow down by > only vacuuming the DB? EXPLAIN ANALYZE of both cases might yield some insight. regards, tom lane
