Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] (solved) R: Very strange problem on index - Mailing list pgsql-general

From Job
Subject [GENERAL] (solved) R: Very strange problem on index
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EACC4FF@W2008DC01.ColliniConsulting.lan
Whole thread Raw
In response to [GENERAL] Very strange problem on index  (Job <Job@colliniconsulting.it>)
Responses Re: [GENERAL] (solved) R: Very strange problem on index  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Job
Date:
Subject: [GENERAL] Very strange problem on index
Next
From: Raymond O'Donnell
Date:
Subject: Re: [GENERAL] (solved) R: Very strange problem on index