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 better

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

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

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

2006-04-24 Thread Greg Stumph
We are experiencing gradually worsening performance in PostgreSQL 7.4.7, on a system with the following specs: Linux OS (Fedora Core 1, 2.4 kernal) Flash file system (2 Gig, about 80% full) 256 Meg RAM 566 MHz Celeron CPU We use Orbit 2.9.8 to access PostGres. The database contains 62 tables.