Re: Picking out the most recent row using a time stamp column

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Dave Crooke <dcrooke@xxxxxxxxx>
Subject: Re: Picking out the most recent row using a time stamp column
From: Josh Berkus <josh@xxxxxxxxxxxx>
Date: Sat, 26 Feb 2011 13:06:00 -0800
Cc: Dave Johansen <davejohansen@xxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <AANLkTi=N0LJp43Zvsyfj=Kd8f0wbF+4-ex8jy1zddWzP@xxxxxxxxxxxxxx>
References: <AANLkTinTgU-jfPOhrfteBvhAhgG_8zknpk13N9L4QMap@xxxxxxxxxxxxxx> <08B3368E-E623-4E9C-83F5-AB05B471AF4C@xxxxxxxxxxxxxxx> <4D666A0F020000250003AFCE@xxxxxxxxxxxxxxx> <AANLkTimSmjGrCqwZWRXU1_=FW0adbWdxLXMK0n=Vw+Cc@xxxxxxxxxxxxxx> <AANLkTin9K_E37QzwEN2ARbh9SHZWv5DwQ6Go7sZpzGL+@xxxxxxxxxxxxxx> <AANLkTi=N0LJp43Zvsyfj=Kd8f0wbF+4-ex8jy1zddWzP@xxxxxxxxxxxxxx>
User-agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2

Dave,

Why not test the windowing version I posted?

-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Follow-Ups:
- Re: Picking out the most recent row using a time stamp column
  - From: Dave Johansen

References:
- Picking out the most recent row using a time stamp column
  - From: Dave Crooke
- Re: Picking out the most recent row using a time stamp column
  - From: Michael Glaesemann
- Re: Picking out the most recent row using a time stamp column
  - From: Kevin Grittner
- Re: Picking out the most recent row using a time stamp column
  - From: Dave Crooke
- Re: Picking out the most recent row using a time stamp column
  - From: Dave Johansen
- Re: Picking out the most recent row using a time stamp column
  - From: Dave Crooke

Prev by Date: Re: Vacuum problem due to temp tables
Next by Date: Re: Index use difference betweer LIKE, LIKE ANY?
Previous by thread: Re: Picking out the most recent row using a time stamp column
Next by thread: Re: Picking out the most recent row using a time stamp column
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]