How to save the postgres array? What is the access mode?

Whether is as follows:
Array field holds A pointer to A,
A point to an array of data in the page?

Query the array size, will only array information page is copied into memory?

Query some element array B, will only B page is copied into memory?

CodePudding user response:

Learn
To rub points

CodePudding user response:

What you said is an array type?

CodePudding user response:

Yes, I want to ask is how the layout of this type of data is stored on the hard drive!

CodePudding user response:

refer to the second floor of the yellow cedar reply:

what you said is an array type?

Yes, I want to ask is how the layout of this type of data is stored on the hard drive!

CodePudding user response:

reference 4 floor zjkem response:

Quote: refer to the second floor of the yellow cedar reply:

what you said is an array type?

Yes, I want to ask is how the layout of this type of data is stored on the hard drive!

You want is a Java code or pl/SQL?

CodePudding user response:

yellow cedar reference 5 floor response:

Quote: refer to 4th floor zjkem response:

Quote: refer to the second floor of the yellow cedar reply:

what you said is an array type?

Yes, I want to ask is how the layout of this type of data is stored on the hard drive!

You want is a Java code or pl/SQL?

I check the array using toast save content, want to ask if the array is less than 100 bytes, then the array will be saved in the table into the toast?