Re: Faster array_length() - Mailing list pgsql-hackers

From Hadi Moshayedi
Subject Re: Faster array_length()
Date
Msg-id CAK=1=WqGCTh-VaTP1Wr637ABNKxjDEBG=SaUGJBnHfZK=51=gw@mail.gmail.com
Whole thread Raw
In response to Re: Faster array_length()  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Thanks for looking into this.
 
With that in mind, I was surprised that your test case showed any
improvement at all --- it looks like the arrays aren't getting compressed
for some reason.

 
You are right, it seems that they were not getting compressed, probably because the arrays were "seq 10000" which seems to not get compressed by pglz. When I changed the test data to an array containing 10000 ones, there were no speed improvement anymore.

I'll look into how to improve the compressed case and other issues you raised.

Thanks,
   -- Hadi

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Faster array_length()
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: pgaudit - an auditing extension for PostgreSQL