Search Postgresql Archives

SELECT statement takes 10 minutes to answer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

Iam using PostgreSQL 7.4.5 on a linux machine, and have the problem
that an easy "SELECT field1, field2, field3 FROM a_table"-statement
takes 10 minutes to give an answer. The table has 750.000 datarows. I
also made an VACUUM a_table before the statement, but it doesnt help at
all. The table has an index to a timestamp field..
What could be the problem, or is it normal that postgresql cant handle
with so many data in an acceptable response-time?

Regards,
M.Korkmaz



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux