On 24 April 2017 at 15:17, Tomas Vondra wrote:
> On 04/24/2017 08:48 AM, Johann Spies wrote:
>>
>>
>> Why would the planner prefer the use the gin index and not the btree
>> index in this case?
>>
>
> You'll need to show what queries are you running - that's a quite important
> piece of informatio
Hi,
I've lately seen more and more installations where the generation of
write-ahead-log (WAL) is one of the primary bottlenecks. I'm curious
whether that's primarily a "sampling error" of mine, or whether that's
indeed more common.
The primary reason I'm curious is that I'm pondering a few pote
On 04/24/2017 08:48 AM, Johann Spies wrote:
Why would the planner prefer the use the gin index and not the btree
index in this case?
You'll need to show what queries are you running - that's a quite
important piece of information, and I don't see it anywhere in this
thread. Seeing explain p