RE: Newbie Question - Mailing list pgsql-general

From Nick Fankhauser
Subject RE: Newbie Question
Date
Msg-id NEBBLAAHGLEEPCGOBHDGIEIJCEAA.nickf@ontko.com
Whole thread Raw
In response to Newbie Question  (John Pilley <jpilley@spescrow.com>)
Responses Re: Newbie Question  (Richard Poole <richard.poole@vi.net>)
List pgsql-general
John-

According to the documentation and Bruce M's book, there is no limit. I've
never hit a limit while putting some pretty large (three page) narratives in
a text field. Practically speaking, I would guess that one will take a
performance hit due to fragmentation when storing big chunks of data
comingled with smaller chunks.

-Nick Fankhauser

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of John Pilley
> Sent: Wednesday, November 01, 2000 12:10 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Newbie Question
>
>
> Is there an upper limit on the size of a "text" character field? If so,
> how can I extend it?
>
> Thanks,
>
> John
>


pgsql-general by date:

Previous
From: "Jonathan Ellis"
Date:
Subject: psql defaults file?
Next
From: "Steve Wolfe"
Date:
Subject: Re: Query caching