Re: [GENERAL] Large data and slow queries - Mailing list pgsql-general

From Samuel Williams
Subject Re: [GENERAL] Large data and slow queries
Date
Msg-id CAHkN8V_j=Lzgr8gbxqrF+h3EP0O-ac9-LRAB_T2muQQfPtPKJQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Large data and slow queries  ("Martijn Tonies \(Upscene Productions\)" <m.tonies@upscene.com>)
List pgsql-general
Martijn that is a good question. It's because we are only concerned
with a subset of events for this index and this particular query. The
query planner can recognise this and use the index correctly. By doing
this, we reduce the size of the index significantly. In the best case,
where we only wanted a few things, the index was reduced from 21GB to
8MB.


pgsql-general by date:

Previous
From: "Martijn Tonies \(Upscene Productions\)"
Date:
Subject: Re: [GENERAL] Large data and slow queries
Next
From: vinny
Date:
Subject: Re: [GENERAL] Large data and slow queries