Re: Really strange foreign key constraint problem blocking delete

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Tim Mickelson <tim_mickelson(at)bigfoot(dot)com>, Jim Nasby <jim(dot)nasby(at)bluetreble(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Andy Colson <andy(at)squeakycode(dot)net>
Subject: Re: Really strange foreign key constraint problem blocking delete
Date: 2014-10-07 13:11:45
Message-ID: 5433E691.5090203@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emanuel Calvo 2014-10-07 13:30:03 Re: Processor usage/tuning question
Previous Message Adrian Klaver 2014-10-07 13:04:37 Re: Really strange foreign key constraint problem blocking delete