Request a Demo
Home   >   mailing lists

Re: Qual evaluation cost estimates for GIN indexes - Mailing list pgsql-hackers

From Marc Mamin
Subject Re: Qual evaluation cost estimates for GIN indexes
Date
Msg-id C4DAC901169B624F933534A26ED7DF310861B3CE@JENMAIL01.ad.intershop.net
Whole thread Raw
In response to Re: Qual evaluation cost estimates for GIN indexes  ("ktm@rice.edu" <ktm@rice.edu>)
List pgsql-hackers
Tree view 
> Hi Marc,
>
> Do you happen to know in which function, the extra time for the toast
> storage is spent -- zlib compression? I saw a mention of the LZ4
> compression
> algorithm that is BSD licensed as a Google summer of code project:
>
> http://code.google.com/p/lz4/
>
> that compresses at almost 7X than zlib (-1) and decompresses at 6X.
>
> Regards,
> Ken

Hi,

No,

and my concern is more about cost estimation for ts_queries / gin
indexes as for the detoasting issue.

regards,

Marc Mamin

pgsql-hackers by date:

Previous
From: "ktm@rice.edu"
Date:
Subject: Re: Qual evaluation cost estimates for GIN indexes
Next
From: Yeb Havinga
Date:
Subject: Re: [v9.2] Add GUC sepgsql.client_label