Postgres Pro
Downloads
Home   >   mailing lists

Re: PERFORMANCE and SIZE - Mailing list pgsql-performance

From Josh Berkus
Subject Re: PERFORMANCE and SIZE
Date
Msg-id 200305120849.39381.josh@agliodbs.com
Whole thread Raw
In response to PERFORMANCE and SIZE  ("Alfranio Junior" <alfranio@lsd.di.uminho.pt>)
List pgsql-performance
Tree view 
Alfranio,

> I'm a new PostgresSql user and I do not know so much about the
>  performance mechanisms currently implemented and available.
<snip>
>  Does anybody know what is happening ?

90% likely:  You haven't run VACUUM FULL ANALYZE in a while.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Adam Siegel
Date:
Subject: Re: [GENERAL] realtime data inserts
Next
From: Steve Crawford
Date:
Subject: Re: [GENERAL] realtime data inserts