On 1/6/06, peter royal <peter.royal@xxxxxxxxx> wrote: > PostgreSQL 8.1.1 > > shared_buffers = 10000 # (It was higher, 50k, but didn't help any, > so brought down to free ram for disk cache) > work_mem = 8196 > random_page_cost = 3 > effective_cache_size = 250000 I have played with both disk cache settings and shared buffers and I found that if I increased the shared buffers above a certain value performance would increase dramatically. Playing with the effective cache did not have the same amount of impact. I am currently running with shared_buffers = 254288 # approx 2.1Gb and this is on a smaller dataset than yours. -- Harry http://www.hjackson.org http://www.uklug.co.uk
