Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 4889D475876 for ; Wed, 17 Apr 2002 12:27:27 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 77BB6D600; Wed, 17 Apr 2002 09:27:29 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 6B6895C01; Wed, 17 Apr 2002 09:27:29 -0700 (PDT) Date: Wed, 17 Apr 2002 09:27:29 -0700 (PDT) From: Stephan Szabo To: Fernando Carvalho Cc: Subject: Re: My is degraded after two weeks In-Reply-To: <3CBD581E.9070200@ig.com.br> Message-ID: <20020417092622.Y62182-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200204/216 X-Sequence-Number: 7480 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?