Re: what's the slowest part in the SQL - Mailing list pgsql-performance

From Claudio Freire
Subject Re: what's the slowest part in the SQL
Date
Msg-id CAGTBQpb5B3FYdV1M=gHkFZjb2HQQzuEDtDBC92g7eSVg_yHfew@mail.gmail.com
Whole thread Raw
In response to Re: what's the slowest part in the SQL  (Suya Huang <shuang@connexity.com>)
List pgsql-performance
On Tue, Aug 9, 2016 at 10:46 PM, Suya Huang <shuang@connexity.com> wrote:
> Hi Claudio,
>
> Here is the index definition
>     "idx_data_3" gin (name gin_trgm_ops), tablespace "tbs_data"
>     "idx_data_4" gin (displayname gin_trgm_ops), tablespace "tbs_data"


GIN indexes are quite big, they can be bigger than the data. Check
their size, it's possible that you can't fit data + indexes on those
2GB.

But if prod is going to be bigger, prehaps it's a non-issue for you?


pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Logging queries using sequential scans
Next
From: Andrey Zhidenkov
Date:
Subject: Planner do seq scan on empty master partitioned table