Re: full vacuum really slows down query - Mailing list pgsql-general

From Scott Marlowe
Subject Re: full vacuum really slows down query
Date
Msg-id dcc563d10806051516n48eeda17xf3726066c42fee99@mail.gmail.com
Whole thread Raw
In response to Re: full vacuum really slows down query  (Jason Long <mailing.list@supernovasoftware.com>)
List pgsql-general
Oh, another point of attack.  Always test your queries under just
\timing.  You can wrap up like this:

\timing
select count(*) from (subselect goes here);

I've been on a few machines where the cost of explain analyze itself
threw the timing way off.

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: full vacuum really slows down query
Next
From: Vlad Kosilov
Date:
Subject: pgsql8.3.2 tentative release date