Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime - Mailing list pgsql-general

From Piotr Gasidło
Subject Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime
Date
Msg-id AANLkTikGTcSiPnvUVeOA1hdu1mhc581gJPSZFecBJez3@mail.gmail.com
Whole thread Raw
In response to Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime  (Piotr Gasidło <quaker@barbara.eu.org>)
List pgsql-general
2010/7/23 A. Kretschmer <andreas.kretschmer@schollglas.com>:
> Maybe cheaply or virtuell hardware?

Cheap - probably, I known processor, but don't know mainboard. It's
dedicated server. Maybe it has silent problems with time keeping.
Virtual - also yes. Postgresql run in separate vserver, but I've
executed psql also from that vserver, so there should be no
differences. But I'll try to test it without vserver.

> There are some issues with functions
> like gettimoofday(), see here:
>
> http://archives.postgresql.org/pgsql-general/2007-01/msg01653.php
> (and the whole thread)

Thanks, i will look at it.

--
Piotr Gasidło

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: Finding last checkpoint time
Next
From: "Machiel Richards"
Date:
Subject: Data dumps to files - best methods?