Re: My is degraded after two weeks

On Wed, 17 Apr 2002, Fernando Carvalho wrote:

> Postgresql 7.2.1 - Redhat 7.2
>
> My table have 600.000 rows and 10 indices.
>
> Speed is recycled after recreating this is index.
>
> This is nomal ?

You haven't given us alot of information here, but...
What's the rate of insert/update to the table?  Are you
running vacuum analyze on it frequently?  What kind
of queries are you running on the table?