Tuesday, 3 September 2013

Setting enable_seqscan = off in a single SELECT query

Setting enable_seqscan = off in a single SELECT query

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