From: Andrew Sullivan <ajs@crankycanuck.ca>
To: De Leeuw Guy <G.De_Leeuw@eurofer.be>
Cc: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-admin@postgresql.org
Subject: Re: cache problem (v2)
Date: Mon, 16 Jul 2007 16:36:41 -0400
Message-ID: <20070716203641.GF18049@phlogiston.dyndns.org> (raw)
In-Reply-To: <469BD389.4030606@eurofer.be>
References: <469B4927.9030604@eurofer.be>
<20070716170957.GV18049@phlogiston.dyndns.org>
<469BAF1D.8030108@eurofer.be>
<20070716184837.GB18049@phlogiston.dyndns.org>
<469BD389.4030606@eurofer.be>
On Mon, Jul 16, 2007 at 10:22:33PM +0200, De Leeuw Guy wrote:
> >
> Yes, but maybe the post are too big, can I send it to your address ?
> It's written in C
Well, sending it to me will do you zero good, as my C skills are
awful. Assuming it's a reasonable size, I think the list will take
it.
> > There is nothing in the cache that isn't "in the database", as it
> > were, but there are visibility rules that might be affecting you.
> >
> visibility rules ?
You can see things that happened in your own transaction, but nobody
else can. If you're working READ COMMITTED, you can also see work
that other transactions commit while you were working. Could any of
that be affecting you? Unless your own function is doing something
with some cache, I am positive there's no cache issue here as you
describe it.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
Unfortunately reformatting the Internet is a little more painful
than reformatting your hard drive when it gets out of whack.
--Scott Morris
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ajs@crankycanuck.ca, G.De_Leeuw@eurofer.be
Subject: Re: cache problem (v2)
In-Reply-To: <20070716203641.GF18049@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox