Re: Slow query and indexes... - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Slow query and indexes...
Date
Msg-id 200705071622.55868.peter_e@gmx.net
Whole thread Raw
In response to Slow query and indexes...  ("Jonas Henriksen" <jonas.f.henriksen@gmail.com>)
Responses Re: Slow query and indexes...
List 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/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: shmget fails on OS X with proper settings
Next
From: Peter Eisentraut
Date:
Subject: Re: Any "guide to indexes" exists?