Thread: SELECT statement takes 10 minutes to answer

SELECT statement takes 10 minutes to answer

From

"Mustafa Korkmaz"

Date:

22 June 2006, 02:59:05

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

Re: SELECT statement takes 10 minutes to answer

From

"A. Kretschmer"

Date:

22 June 2006, 03:39:59

am  19.06.2006, um  5:26:54 -0700 mailte Mustafa Korkmaz folgendes:
> 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

Hey, read my answer on your question in the news, MID
<1150720704.328939.25700@f6g2000cwb.googlegroups.com> ;-)


Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===