Home > mailing lists

SELECT statement takes 10 minutes to answer - Mailing list pgsql-general

From	Mustafa Korkmaz
Subject	SELECT statement takes 10 minutes to answer
Date	June 22, 2006 02:59:05
Msg-id	1150720014.786026.107210@h76g2000cwa.googlegroups.com Whole thread Raw
Responses	Re: SELECT statement takes 10 minutes to answer
List	pgsql-general

Tree view

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

pgsql-general by date:

From: "Daniel"
Date: 22 June 2006, 02:59:02
Subject: BackUp

From: "Chris Golden"
Date: 22 June 2006, 02:59:09
Subject: Interface Guidance and Opinions Needed

SELECT statement takes 10 minutes to answer - Mailing list pgsql-general

Previous

Next