SELECT statement takes 10 minutes to answer

From: "Mustafa Korkmaz" <Musti(dot)de(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: SELECT statement takes 10 minutes to answer
Date: 2006-06-19 12:26:54
Message-ID: 1150720014.786026.107210@h76g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wes 2006-06-19 12:44:23 Re: Adding foreign key constraints without integrity
Previous Message Daniel 2006-06-19 12:17:33 BackUp