> I understand tuning PG is almost an art form, yet it should be based on
> actual usage patterns, not just by system dimensions, don't you agree?
Well, it's both.   It's more that available RAM determines your *upper* limit; 
that is, on Linux, you don't really want to have more than 20% allocated to 
the shared_buffers or you'll be taking memory away from the kernel.   

Within that limit, data size, query complexity and volume, and whether or not 
you have long-running procedures tell you whether you're at the low end or 
the high end.

To futher complicate things, these calculations are all going to change with 

-Josh Berkus
 Aglio Database Solutions
 San Francisco

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to