Why is postgresql slow ?

[nxrt2004]

Hi there , At first my english isn't good :-(

Well, I am using postgresql7.3.4 and i hava a table in this database. There are 480.000 records and 25 column in this table. When i run a select statement, datas are coming very slow (about after 6-7 minutes). I am using index.

But select statement was working good, at first. ? did a update in a column after that my queries slowed.

Can i do for fast queries ?

 

[ceco]

do you run VACUUM ANALYZE from time to time?

try using

EXPLAIN and paste the results here
or even EXPLAIN ANALYZE