Re: [OT] Very strange postgresql behaviour

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: arnaulist(at)andromeiberica(dot)com
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [OT] Very strange postgresql behaviour
Date: 2007-01-29 13:35:41
Message-ID: 45BDF82D.8010106@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Arnau wrote:
> Hi all,
>
> I have postgresql 7.4.2 running on debian and I have the oddest
> postgresql behaviour I've ever seen.

You should upgrade. The latest 7.2 release is 7.4.15

> I do the following queries:
> ...

At first glance this looks like a bug in PostgreSQL, but..

> Rules:
>
> A lot of rules that I don't paste as matter of length.

Is there any SELECT rules by chance that might explain this?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2007-01-29 14:53:56 Re: work-mem how do I identify the proper size
Previous Message Bill Moran 2007-01-29 13:27:06 Re: [OT] Very strange postgresql behaviour