Skip site navigation (1) Skip section navigation (2)

Re: [SQL] 7.3 analyze & vacuum analyze problem

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>,pgsql-sql(at)postgresql(dot)org
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [SQL] 7.3 analyze & vacuum analyze problem
Date: 2003-04-30 16:03:38
Message-ID: 200304300902.37985.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performancepgsql-sql
Achilleus,

> i think i have an issue regarding the statistics that
> a) (plain) ANALYZE status and
> b) VACUUM ANALYZE status
> produce.

It's perfectly normal for a query to run faster after a VACUUM ANALYZE than 
after an ANALYZE ... after all, you just vacuumed it, didn't you?

If you're demonstrating some other kind of behavioural difference, then please 
post the results of EXPLAIN ANALYZE for the two examples.

Oh, and we should probably shift this discussion to the PGSQL-PERFORMANCE 
list.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


In response to

Responses

pgsql-performance by date

Next:From: Jean-Luc LachanceDate: 2003-04-30 16:23:11
Subject: Re: Why LIMIT after scanning the table?
Previous:From: Peter DarleyDate: 2003-04-30 15:09:12
Subject: Re: Query Plan far worse in 7.3.2 than 7.2.1

pgsql-sql by date

Next:From: Diehl, JeffreyDate: 2003-04-30 16:34:40
Subject: Like search performance.
Previous:From: Peter DarleyDate: 2003-04-30 15:09:12
Subject: Re: Query Plan far worse in 7.3.2 than 7.2.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group