Re: cache problem (v2) - Mailing list pgsql-admin

From De Leeuw Guy
Subject Re: cache problem (v2)
Date
Msg-id 469BDA05.9010701@eurofer.be
Whole thread Raw
In response to Re: cache problem (v2)  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-admin
> 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.
No the complete example need also db schema and data.
I try to reproduce with a small program.
>
>
>
>>> 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
>
>
I check that tomorrow (I'm tired, 22h49h in Belgium) :-)
thanks for your help
Guy

pgsql-admin by date:

Previous
From: De Leeuw Guy
Date:
Subject: Re: cache problem (v2)
Next
From: "Vishal Arora"
Date:
Subject: Re: PgAgent Job Scheduling-Backup