On Sat, Oct 15, 2011 at 1:33 PM, Grzegorz Jaskiewicz <gryzman@xxxxxxxxx> wrote:> This is with 9.1.1 on a Windows XP machine
On 15 Oct 2011, at 21:20, Thomas Kellerer wrote:
>
> Total runtime: -2.368 ms <<==== this is amazing ;)
>
Are you saying that Windows XP is the ultimate server OS for high performance PostgreSQL installations? Are there optimizations that this platform can take advantage of, perhaps extending Pg timelines into actual time travel that are not available on other platforms?
In some way, time travel is possible - system clock can be adjusted, think: ntpd
That triggers another question:
Is PostgreSQL internal timing somehow immune to system clock backward "step" ("slew" should be safe) issued by ntpd?
Can it be "fixed" so it at least does not return nagative time deltas?
For definition of "step" vs "slew", see http://osr507doc.sco.com/en/NetAdminG/ntpC.ntp_terms.html
