Postgres Pro
Downloads
Home   >   mailing lists

Re: Picking out the most recent row using a time stamp column - Mailing list pgsql-performance

From Dave Johansen
Subject Re: Picking out the most recent row using a time stamp column
Date
Msg-id AANLkTikXLneQ1wsYXxS6JqTwnHQdjP54FsXL_NEdOjVF@mail.gmail.com
Whole thread Raw
In response to Re: Picking out the most recent row using a time stamp column  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Picking out the most recent row using a time stamp column
List pgsql-performance
Tree view

Unfortunately, I'm running 8.3.3 and to my knowledge the windowing stuff wasn't added til 8.4.
Dave

On Feb 26, 2011 2:06 PM, "Josh Berkus" <josh@agliodbs.com> wrote:
> Dave,
>
> Why not test the windowing version I posted?
>
> --
> -- Josh Berkus
> PostgreSQL Experts Inc.
> http://www.pgexperts.com

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Index use difference betweer LIKE, LIKE ANY?
Next
From: Florian Weimer
Date:
Subject: Re: Picking out the most recent row using a time stamp column