Re: Faster array_length()

Поиск
Список
Период
Сортировка
От Hadi Moshayedi
Тема Re: Faster array_length()
Дата
Msg-id CAK=1=WqGCTh-VaTP1Wr637ABNKxjDEBG=SaUGJBnHfZK=51=gw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Faster array_length()  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Faster array_length()
Следующее
От: Abhijit Menon-Sen
Дата:
Сообщение: Re: pgaudit - an auditing extension for PostgreSQL