Re: 9.1 got really fast ;) - Mailing list pgsql-general

From Scott Marlowe
Subject Re: 9.1 got really fast ;)
Date
Msg-id CAOR=d=2G_hcM-vTezAVt5eKQX5d4P-TL6U-N0cb2CYmBeWtYcw@mail.gmail.com
Whole thread Raw
In response to Re: 9.1 got really fast ;)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 9.1 got really fast ;)  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
On Sun, Oct 16, 2011 at 5:24 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Scott Marlowe <scott.marlowe@gmail.com> writes:
>> On Sat, Oct 15, 2011 at 2:20 PM, Thomas Kellerer <spam_eater@gmx.net> wrote:
>>> Total runtime: -2.368 ms   <<==== this is amazing ;)
>
>> I get something similar when I do select now()-query_start from
>> pg_stat_activity on my Ubuntu 10.04 / pg 8.3 servers.
>
> Within a transaction block that's not surprising, because now() is
> defined as transaction start time not statement start time.

No transaction block.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 9.1 got really fast ;)
Next
From: Scott Marlowe
Date:
Subject: Re: index bloat question