pasman pasmański <pasman.p 'at' gmail.com> writes: > Thanks for reply. > I tested random changes and query runs fastest after: > > set seq_page_cost = 0.1; > set random_page_cost = 0.1; > cpu_operator_cost = 0.01
If I'm correct, you're basically telling postgresql that your disk is unusually fast compared to your CPU. Even if some queries will run faster from a side-effect of these settings, you're likely to create other random problems... -- Guillaume Cottenceau -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
