On 01.05.2015 13:06, David Osborne wrote:
Simple... that did it... thanks! dev=> create index on table(code,row_id); CREATE INDEX Time: 38088.482 ms dev=> explain (analyse,buffers) select row_id as last_row_id from table where code='XX' order by row_id desc limit 1;
Just out of curiosity: Is there a particular reason why you do not use select max(row_id) as last_row_id from table where code='XX' ? Kind regards robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
