Re: gin index postgres 9.2

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wed, May 25, 2016 at 7:42 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Wed, May 25, 2016 at 7:38 PM, Lucas Possamai <drum.lucas@xxxxxxxxx> wrote:

yes.. I thought too.

the results r still different 

​What's the query with the revised parentheses?

​Never mind...your right I doubt that it should matter.

What I would do is remove the whole "count(DISTINCT)" part and select * - and then add a LIMIT 10 and an ORDER BY to both the before and after.  If we see the data it might help to explain the behavior.

It could be a bug...but you'd need to provide a self-contained script so that someone else can confirm.

David J.

​