Re: Slow query and indexes...

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: "Jonas Henriksen" <jonas(dot)f(dot)henriksen(at)gmail(dot)com>
Subject: Re: Slow query and indexes...
Date: 2007-05-07 14:22:55
Message-ID: 200705071622.55868.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Montag, 7. Mai 2007 15:53 schrieb Jonas Henriksen:
> while if I add a GROUP BY data_logger  the query uses a seq scan and a
>
> lot of time:
> >> explain analyze SELECT max(date_time) FROM data_values GROUP BY
> data_logger_id;

I don't think there is anything you can do about this.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2007-05-07 14:26:06 Re: Any "guide to indexes" exists?
Previous Message Tom Lane 2007-05-07 14:11:29 Re: shmget fails on OS X with proper settings