Re: Qual evaluation cost estimates for GIN indexes

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: <ktm(at)rice(dot)edu>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>, "Teodor Sigaev" <teodor(at)sigaev(dot)ru>, <pgsql-hackers(at)postgreSQL(dot)org>, <jesper(at)krogh(dot)cc>
Subject: Re: Qual evaluation cost estimates for GIN indexes
Date: 2012-02-20 14:32:11
Message-ID: C4DAC901169B624F933534A26ED7DF310861B3CE@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Yeb Havinga 2012-02-20 14:35:13 Re: [v9.2] Add GUC sepgsql.client_label
Previous Message ktm@rice.edu 2012-02-20 14:24:11 Re: Qual evaluation cost estimates for GIN indexes