References
Reference NO 1
http://stackoverflow.com/questions/15165550/setting-enable-seqscan-off-in-a-single-select-query
Reference NO 2
http://www.postgresql.org/message-id/3D280073.5010809@cybertec.at
Reference NO 3
http://www.greenplum.com/communities/forums/showthread.php?742-Out-of-memory-while-select-count(1)-with-SET-ENABLE_SEQSCAN-OFF
Reference NO 4
http://www.postgresonline.com/journal/archives/149-Forcing-the-planners-hand-with-set-enable_seqscan-off-WTF.html
Reference NO 5
http://linuxfinances.info/info/sqlqueries.html
Reference NO 6
http://www.revsys.com/writings/postgresql-performance.html
Reference NO 7
http://postgis.net/docs/ch07.html
Reference NO 8
http://revenant.ca/www/postgis/workshop/advanced_performance.html
No comments:
Post a Comment