Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Luke Lonergan wrote:
Should be a lot higher, something like 10-15 is approximating accurate.
In my own case, I have a much smaller database that I normally work with, where everything should fit in memory (100 Mbytes?), and reducing it to 3.0 has resulted in consistently better timings for me. I think this means that the planner doesn't understand my database size : effective memory size ratio. :-)

Anyways - my point is that if you change the default to 10 you may hurt people like me.

Cheers,
mark

--
Mark Mielke <mark@xxxxxxxxx>

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux