Re: [PERFORM] Index Bloat Problem

2012-08-17 Thread Jeff Janes
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

Re: [PERFORM] Increasing WAL usage followed by sudden drop

2012-08-17 Thread Jeff Janes
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

Re: [PERFORM] Increasing WAL usage followed by sudden drop

2012-08-17 Thread delongboy
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

Re: [PERFORM] Increasing WAL usage followed by sudden drop

2012-08-17 Thread Joshua Berkus
> 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

Re: [PERFORM] Odd blocking (or massively latent) issue - even with EXPLAIN

2012-08-17 Thread Jim Vanns
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 >