Hmmm. I was thinking of a more comprehensive solution or document resource. I would like to know what does what. Why tweak that or why not to ya know? Searching gets me such fragmented results I chose to ask the ones whom are more familiar with this fabulous piece of software and used it in real world situations. Does anyone know of a some good docs on the subject of dedicated db optimization for postgresql 8.0.3? Is 8.1 to early to use in a production environment? With just the regular old 8.0.3 stuff? Thanks for the tips too. I always appreciate tips. :) Thanks again, Matthew A. Peter --- "Jim C. Nasby" <jnasby@xxxxxxxxxxxxx> wrote: > On Tue, Aug 30, 2005 at 09:43:19PM -0700, Ian > Harding wrote: > > Mine in similar, and the only thing I have changed > from defaults is > > work_mem. It made certain complex queries go from > taking forever to > > taking seconds. I have a database connection pool > limited to 10 > > connections, so I set it to 10MB. That means (to > me, anyway) that > > work_mem will never gobble more then 100MB. Seems > OK since I have > > 1GB. > > That's not totally true. A single query can use > work_mem for multiple > steps, so if work_mem is 10MB a single query could > end up using 20MB, > 30MB, or even more. > -- > Jim C. Nasby, Sr. Engineering Consultant > jnasby@xxxxxxxxxxxxx > Pervasive Software http://pervasive.com > 512-569-9461 > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please > send an appropriate > subscribe-nomail command to > majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list > cleanly > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
