On 10/06/2014 11:29 PM, Tim Mickelson wrote:
What should I disable? Corrupt index sounds like a possible case, but
how do I fix this?
http://www.postgresql.org/docs/9.1/static/runtime-config-query.html
enable_indexscan (boolean)
Enables or disables the query planner's use of index-scan plan
types. The default is on.
SET enable_indexscan=off;
EXPLAIN ANALYZE DELETE query
SET enable_indexscan=on;
EXPLAIN ANALYZE
select * from cubesocialnetwork.tmp_autenticazionesocial where
idautenticazionesocial = 1622
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
