Re: [GENERAL] slow SELECT ... LIMIT query

2001-07-18 Thread Tom Lane
What query plans are you getting for these various combinations? regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[GENERAL] slow SELECT ... LIMIT query

2001-07-18 Thread Simon Stanlake
Hi, I have a fairly large table (1 million records) with the following structure... sampleid int4 unitid int4 datetimestamp timestamp data1 float8 data2 float8 btree indexes on sampleid, unitid, and datetimestamp. I want to be able to pull out the most recent record for a certain unit. the qu