Postgres Pro
Downloads
Home   >   mailing lists

Re: [OT] Very strange postgresql behaviour - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: [OT] Very strange postgresql behaviour
Date
Msg-id 45BDF82D.8010106@enterprisedb.com
Whole thread Raw
In response to [OT] Very strange postgresql behaviour  (Arnau <arnaulist@andromeiberica.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Bill Moran
Date:
Subject: Re: [OT] Very strange postgresql behaviour
Next
From: Bill Moran
Date:
Subject: Re: work-mem how do I identify the proper size