Thanks for the feedback guys.
The database will grow in size. This first client
years worth of data was 85mb (test to proof of
concept). The 05 datasets I expect to be much larger.
I think I may increase the work_mem and
maintenance_work_mem a bit more as suggested to.
I'm a bit still confused
> 1.) shared_buffers I see lot of reference to making
> this the size of available ram (for the DB). However,
> I also read to make it the size of pgdata directory.
> 2.) effective_cache_size - from what I read this is
> the 'total' allowed memory for postgresql to use
> correct? So, if I am w
Puddle wrote:
Hello, I'm a Sun Solaris sys admin for a start-up
company. I've got the UNIX background, but now I'm
having to learn PostgreSQL to support it on our
servers :)
Server Background:
Solaris 10 x86
PostgreSQL 8.0.3
Dell PowerEdge 2650 w/4gb ram.
This is running JBoss/Apache as well