[GENERAL] (solved) R: Very strange problem on index

Поиск
Список
Период
Сортировка
От Job
Тема [GENERAL] (solved) R: Very strange problem on index
Дата
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EACC4FF@W2008DC01.ColliniConsulting.lan
обсуждение исходный текст
Ответ на [GENERAL] Very strange problem on index  (Job <Job@colliniconsulting.it>)
Ответы Re: [GENERAL] (solved) R: Very strange problem on index  (Raymond O'Donnell <rod@iol.ie>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Job
Дата:
Сообщение: [GENERAL] Very strange problem on index
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: [GENERAL] (solved) R: Very strange problem on index