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

Re: Database Statistics???

From: Ansgar -59cobalt- Wiechers <lists(at)planetcobalt(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Database Statistics???
Date: 2007-07-13 17:52:49
Message-ID: 20070713175249.GA25103@mail.planetcobalt.net (view raw or flat)
Thread:
Lists: pgsql-performance
On 2007-07-13 smiley2211 wrote:
> I am a bit confused...I have a database which was performing very
> POORLY selecting from a view (posted earlier) on one server but
> extremely fast on another server...

EXPLAIN ANALYZE'ing the query will show you the planner's estimates. The
query plans should give you an idea of what the problem actually is. Did
you already run ANALYZE on the database?

> I just backed up the database from the FAST server and loaded to the
> SLOW server and it ran just as fast as it originally did...my
> questions are:
> 
> Are STATISTICS some how saved with the database??

Not with the database, but in the pg_statistic catalog, AFAIK.

> if so, how do I UPDATE view or update them?

You collect statistics by ANALYZE'ing either particular tables or the
entire database. They can be viewed in the pg_catalog.pg_statistic
table. However, viewing the query plans for your queries will probably
be more telling.

Regards
Ansgar Wiechers
-- 
"The Mac OS X kernel should never panic because, when it does, it
seriously inconveniences the user."
--http://developer.apple.com/technotes/tn2004/tn2118.html

In response to

pgsql-performance by date

Next:From: Mario WeilguniDate: 2007-07-13 18:19:51
Subject: Re: Database Statistics???
Previous:From: Tom ArthursDate: 2007-07-13 17:39:19
Subject: Re: Database Statistics???

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