Poor Performance on a table - Mailing list pgsql-performance

From Pallav Kalva
Subject Poor Performance on a table
Date
Msg-id 41AF68F2.1050206@deg.cc
Whole thread Raw
Responses Re: Poor Performance on a table
Re: Poor Performance on a table
List pgsql-performance
Hi ,

    I have a table in my production database which has 500k rows and
from the pg_class it shows the number of "relpages" of
around 750K for this table, the same table copied to a test database
shows "relpages" as 35k. I run vacuumdb on the whole
database (not on the table individually but the whole database) daily.
I think because of this most of queries are slowing down which used to
run much faster before.
  Is there any way to fix this problem ?

Thanks!
Pallav


pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Alternatives to Dell?
Next
From: Frank Wiles
Date:
Subject: Re: Poor Performance on a table