On Thu, Aug 16, 2012 at 12:57 PM, Strahinja Kustudić
wrote:
>
> @Jeff I'm not sure if I understand what you mean? I know that we never reuse
> key ranges. Could you be more clear, or give an example please.
If an index leaf page is completely empty because every entry on it
were deleted, it will
On Fri, Aug 17, 2012 at 10:53 AM, delongboy wrote:
>
> Josh Berkus wrote
>>
>>> We are not doing anything to postgres that would cause the rise and
>>> drop.
>>> Data base activity is pretty consistent. nor are we doing any kind
>>> of
>>> purge. This week the drop occurred after 6 days. We are
Josh Berkus wrote
>
>> We are not doing anything to postgres that would cause the rise and
>> drop.
>> Data base activity is pretty consistent. nor are we doing any kind
>> of
>> purge. This week the drop occurred after 6 days. We are thinking it
>> must
>> be some kind of internal postgres ac
> We are not doing anything to postgres that would cause the rise and
> drop.
> Data base activity is pretty consistent. nor are we doing any kind
> of
> purge. This week the drop occurred after 6 days. We are thinking it
> must
> be some kind of internal postgres activity but we can't track it
Hello again. So sorry for resurrecting such an old thread but the
problem still persists - I've just had very little to report on, until
now...
> > That latter test - won't that pretty much just read from the page
> cache?
> > 'sync' may well have forced dirty pages to disk but does it actually
>