Hi Tom,
Thanks for you valuable input.
>Hi,
>
>On 08/22/2015 03:55 AM, Guo, Yun wrote:
>> Hi,
>>
>> We have a query on a column with GIN index, but query plan chooses not
>> using the index but do an seq scan whichi is must slower
>>
>> CREAT
e table size is 154MB, and the index size is 180MB.
It¹s on AWS db.r3.xlarge instance with 4 virtual cores4, Memory30.5 GiB,
General purpose ssd, with shared_buffers 1048576 and work_mem 159744.
On 8/22/15, 12:36 AM, "pgsql-performance-ow...@postgresql.org on behalf of
Tomas Vond
Hi,
We have a query on a column with GIN index, but query plan chooses not using
the index but do an seq scan whichi is must slower
CREATE INDEX idx_access_grants_on_access_tokens ON access_grants USING gin
(access_tokens);
explain analyze SELECT "access_grants".* FROM "access_grants" WHERE
