Re: [GENERAL] Am I best off keeping large chunks of text in a separate table?

2011-09-19 Thread Jerry Sievers
Mike Christensen m...@kitchenpc.com writes: On Sat, Sep 17, 2011 at 6:46 PM, Mike Christensen m...@kitchenpc.com wrote: What would be really cool is if postgresql took values for body that were over a few k and compressed them and stored them out of line in another table.  Luckily for you,

Re: [GENERAL] Am I best off keeping large chunks of text in a separate table?

2011-09-17 Thread Scott Marlowe
On Sat, Sep 17, 2011 at 6:46 PM, Mike Christensen m...@kitchenpc.com wrote: I have a table that looks something like this: url - character varying(1024) date - timestamptz body - text Url is a unique primary key.  Body can potentially be a couple hundred k of text. There will at first be

Re: [GENERAL] Am I best off keeping large chunks of text in a separate table?

2011-09-17 Thread Mike Christensen
On Sat, Sep 17, 2011 at 6:46 PM, Mike Christensen m...@kitchenpc.com wrote: I have a table that looks something like this: url - character varying(1024) date - timestamptz body - text Url is a unique primary key.  Body can potentially be a couple hundred k of text. There will at first

Re: [GENERAL] Am I best off keeping large chunks of text in a separate table?

2011-09-17 Thread Scott Marlowe
On Sat, Sep 17, 2011 at 7:15 PM, Mike Christensen m...@kitchenpc.com wrote: Man I've been reading this list for years now, and I kept on seeing this TOAST thing and just figured you people liked it for sandwiches or something. I feel like the programmer who thinks he's smart using a left