Hello,
I have noticed that in 9.0.2 EXPLAIN ANALYZE takes considerably longer time to
return than the actual query. I never noticed this in 8.3.
Example:
In 9.0.2 i get
dynacom=# EXPLAIN ANALYZE SELECT count(ms.id) from marinerstates ms,mariner m
where ms.endtime IS NOT NULL AND ms.marinerid=m.id
Achilleas Mantzios writes:
> I have noticed that in 9.0.2 EXPLAIN ANALYZE takes considerably longer time
> to return than the actual query. I never noticed this in 8.3.
Same hardware? What it sounds like is you're running 9.0 on a machine
with slow gettimeofday().
regar
On Mon, Jan 10, 2011 at 10:55 PM, somnathzankar wrote:
>
> $ sudo su - postgres
> No directory, logging in with HOME=/
>
> so when I'm trying to install postgresql then above warning got to me and it
> install.
> but when I'm trying to login by postgres user then above error it shows.
This just m
"Daniel J. Summers" writes:
> On Mon, Jan 10, 2011 at 10:55 PM, somnathzankar
> wrote:
>>
>> $ sudo su - postgres
>> No directory, logging in with HOME=/
>>
>> so when I'm trying to install postgresql then above warning got to me and it
>> install.
>> but when I'm trying to login by postgres u
On Sat, Dec 25, 2010 at 2:09 PM, Maxim Boguk wrote:
> While I trying create reproducible test case for BUG #5798 I
> encountered very strange effect on two of my servers (both servers
> have same hardware platform/OS (freebsd 7.2) and PostgreSQL 8.4.4).
>
> Very simple test table created as:
> CRE