On Sat, Jan 6, 2018 at 2:11 AM, Luis Marin <luismarinaray@xxxxxxxxx> wrote: > I am looking for ideas, to help me, check what is happening with a possible > table corruption, I have some FK that works ok, but some stay in the state > waiting forever, however selecting the same table works fine. > > Since, I am a newbie, in PostgreSQL, what should be my firsts steps, in > order to have an idea how to fix this problem. > > I am thinking in watching my postgresql log error file during the requests > for creating our FK, > What do you suggest me There are CentOS packages for amcheck on 9.4: https://github.com/petergeoghegan/amcheck#redhatcentossles I would start there. -- Peter Geoghegan