-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Friday, July 11, 2014 3:43 PM
To: Huang, Suya
Cc: Andreas Kretschmer; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] GIN index not used
"Huang, Suya" writes:
> Just found out something here
> http://www.postg
"Huang, Suya" writes:
> Just found out something here
> http://www.postgresql.org/message-id/17021.1234474...@sss.pgh.pa.us
> So I dropped the index and recreate it by specifying: using gin(terms_ts
> gin__int_ops) and the index works.
Oh, you're using contrib/intarray?
Pursuant to the threa
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Friday, July 11, 2014 2:56 PM
To: Andreas Kretschmer
Cc: Huang, Suya; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] GIN index not used
Andreas Kretschmer writes:
> Huang, Suya wrote:
>> I’ve got a table with G
Tom Lane wrote:
> What PG version is this? What non-default planner parameter settings are
> you using? (Don't say "none", because I can see you've got enable_seqscan
> turned off.)
LOL, right ;-)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentio
Andreas Kretschmer writes:
> Huang, Suya wrote:
>> Iâve got a table with GIN index on integer[] type. While doing a query with
>> filter criteria on that column has GIN index created, itâs not using index
>> at
>> all, still do the full table scan. Wondering why?
> Btw.: works for me:
Yeah
Huang, Suya wrote:
> Hi,
>
>
>
> I’ve got a table with GIN index on integer[] type. While doing a query with
> filter criteria on that column has GIN index created, it’s not using index at
> all, still do the full table scan. Wondering why?
Try to add an index on the date-column.
Btw.: work
Hi,
I've got a table with GIN index on integer[] type. While doing a query with
filter criteria on that column has GIN index created, it's not using index at
all, still do the full table scan. Wondering why?
Table is analyzed.
dev=# \d+ booking_weekly
Table "booking
On 01/07/14 22:13, Andres Freund wrote:
On 2014-07-01 21:48:35 +1200, Mark Kirkwood wrote:
- cherry picking the last 5 commits into 9.4 branch and building a package
from that and retesting:
Clients | 9.4 tps 60 cores (rwlock)
+--
6 | 70189
12 | 12889
