Thread: toast examples.
hey. i've used postgresql for a while and i have been waiting for 7.1. now that school is out i have time to mess around with it a bit. after i installed it i started poking at the docs, but i havent found an example of how toast is implemented. could someone point me to an example? also would anyone care to comment on effectively using toast with php? thanks john
On Mon, May 21, 2001 at 10:01:26PM -0400, harrold@sage.che.pitt.edu wrote: > i've used postgresql for a while and i have been waiting for 7.1. now that > school is out i have time to mess around with it a bit. after i installed > it i started poking at the docs, but i havent found an example of how > toast is implemented. could someone point me to an example? also would > anyone care to comment on effectively using toast with php? Do you mean source-code level implementation (i.e. changes to Postgres internals), or the user-level stuff you need to know (i.e. how to use the 'TOAST' feature in your apps). If the former, the source code, I guess. -HACKERS would be a better list to ask on. If the later, you don't need to know anything. Just use a 'TEXT' storage type and Postgres will let you store as much as you want in there (I think there is still a 1GB/row limit, but that doesn't include the automatic compression TOAST does). So as a 'normal' developer, you don't need to worry about it, the 8K limit has just gone away. As for PHP, TOAST really doesn't have anything to do with it. Cheers, Neil
On 21 May 2001 22:55:17 -0400, Neil Conway wrote: > If the later, you don't need to know anything. Just use a 'TEXT' storage > type and Postgres will let you store as much as you want in there > (I think there is still a 1GB/row limit, but that doesn't include the > automatic compression TOAST does). Do you have any tips/examples on BLOBs (using libpq++)? -- Nabil Sayegh
On 22 May 2001, Nabil Sayegh wrote: > On 21 May 2001 22:55:17 -0400, Neil Conway wrote: > > If the later, you don't need to know anything. Just use a 'TEXT' storage > > type and Postgres will let you store as much as you want in there > > (I think there is still a 1GB/row limit, but that doesn't include the > > automatic compression TOAST does). > > Do you have any tips/examples on BLOBs (using libpq++)? > does toast only work on text? would it be easier to convert the BLOBS into text and insert that into a text field? -- john Give a man a fish, he owes you one fish. Teach a man to fish, you give up your monopoly on fisheries.
Neil Conway wrote: > If the later, you don't need to know anything. Just use a 'TEXT' storage > type and Postgres will let you store as much as you want in there > (I think there is still a 1GB/row limit, but that doesn't include the > automatic compression TOAST does). Do you have any tips/examples on BLOBs (using libpq++)? -- Nabil Sayegh