Re: Performance of a large array access by position (tested version 9.1.3)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> >> >>> Is that behaviour is correct?
> >> 
> >> yes - access to n position means in postgresql - skip n-1 elements
> > 
> > Hmmm...
> > 
> > how many elements to be skipped here ?
> 
> there are two independent stages:
> 
> a) detoast - loading and decompression (complete array is detoasted)
> b) access
> 
> if you has very large arrays, then @a is significant

There is a place to add PG_GETARG_ARRAY_P_SLICE. The code is just not done 
yet. 

-- 
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation

Attachment: signature.asc
Description: This is a digitally signed message part.


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux