limit order by performance issue - Mailing list pgsql-performance

From Pedro Jiménez
Subject limit order by performance issue
Date
Msg-id 507C4B8E.3010806@ismsolar.com
Whole thread Raw
Responses Re: limit order by performance issue
Re: limit order by performance issue
Re: limit order by performance issue
List pgsql-performance
Hello,
   I'm trying to do a simple SQL query over Postgresl 9.0 running on Ubuntu.

I have a large table (over 100 million records) with three fields,
id_signal (bigint), time_stamp (timestamp) and var_value (float).

My query looks like this:

select var_value from ism_floatvalues where id_signal = 29660 order by
time_stamp desc limit 1;

So I want to select the last value from a determinated ID (is_signal).

This query runs FOREVER, while if I delete "limit 1" it runs instantly....

Any help?

Regards.




pgsql-performance by date:

Previous
From: "Sam Wong"
Date:
Subject: LIKE op with B-Tree Index?
Next
From: Pavel Stehule
Date:
Subject: Re: limit order by performance issue