Re: [PERFORM] Worsening performance with 7.4 on flash-based system

2006-05-01 Thread Scott Marlowe
On Fri, 2006-04-28 at 13:36, Greg Stumph wrote: > Well, since I got no response at all to this message, I can only assume that > I've asked the question in an insufficient way, or else that no one has > anything to offer on our problem. > > This was my first post to the list, so if there's a bet

Re: [PERFORM] Worsening performance with 7.4 on flash-based system

2006-04-29 Thread chris smith
On 4/29/06, Greg Stumph <[EMAIL PROTECTED]> wrote: Well, since I got no response at all to this message, I can only assume that I've asked the question in an insufficient way, or else that no one has anything to offer on our problem. This was my first post to the list, so if there's a better way

Re: [PERFORM] Worsening performance with 7.4 on flash-based system

2006-04-29 Thread William Yu
Usually when simple queries take a long time to run, it's the system tables (pg_*) that have become bloated and need vacuuming. But that's just random guess on my part w/o my detailed info. Greg Stumph wrote: Well, since I got no response at all to this message, I can only assume that I've as

Re: [PERFORM] Worsening performance with 7.4 on flash-based system

2006-04-29 Thread Greg Stumph
Well, since I got no response at all to this message, I can only assume that I've asked the question in an insufficient way, or else that no one has anything to offer on our problem. This was my first post to the list, so if there's a better way I should be asking this, or different data I shou