Re: random_page_cost = 2.0 on Heroku Postgres

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

 



-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> You can execute several queries with the three different values provided 
> by Scott and Josh.
> - SET random_page_cost  = 2.0
> First execution of the queries with EXPLAIN ANALYZE
> - SET random_page_cost  = 1.4
> Second execution of the queries with EXPLAIN ANALYZE
> - SET random_page_cost  = 1.2
> Second execution of the queries with EXPLAIN ANALYZE

Well, such a tool would ideally be smarter than that, such that 
you would run EXPLAIN and compare to the previous plan and 
only run EXPLAIN ANALYZE if the plan changed. One could even 
decrement rpc slowly and find out at one points it changes, 
which would be more interesting than testing arbitrary numbers.
Would lead to some really sweet graphs as well. :)

- -- 
Greg Sabino Mullane greg@xxxxxxxxxxxx
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201202082338
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk8zTewACgkQvJuQZxSWSsiprACfTlYKiC4SS1UnERU+1N/2EGhJ
s9AAoIXLJk88hoNHEkWKhUTqikDBtC/B
=S65l
-----END PGP SIGNATURE-----



-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


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

  Powered by Linux