(solved) R: Very strange problem on index

From: Job <Job(at)colliniconsulting(dot)it>
To: Job <Job(at)colliniconsulting(dot)it>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: (solved) R: Very strange problem on index
Date: 2017-02-02 12:53:58
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A08054EACC4FF@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I create a table copy, with indexes, and it worked perfecly.
Then i dropped the original table and recreated it back by a copy of the newest.

Same problems, lack during searches and indexes not used.

I restart Postgresql 9.6.1 engine and now index is working perfectly!

Maybe a cache or something other problems?

I am really curious to understand why!

Thank you!
/F

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2017-02-02 13:47:05 Re: (solved) R: Very strange problem on index
Previous Message Job 2017-02-02 12:18:05 Very strange problem on index