> > I've encountered a strange behavior of the VACUUM ANALYZE command.
> > It seems that this command works only if the size of a text field
> > does not exceed approximately 4050 bytes! So the real limit on
> > tuple size is a half of the max tuple size. I've checked this effect
> > on Postgres 6.4.2 (Sparc Solaris 2.5.1) and Postgres 6.5 (SUSE 6.1
> > Linux, kernel 2.2.5). Is this a bug or known feature?
> > The python script used to reproduce this problem and results for
> > v6.4.2 and v6.5 are follows.
> >
>
OK, I have again written the code to allow tuples to take up a while
block, rather than the 1/2 block limit you were seeing. It consists of
a bunch of patches, so I can't send them to you, but it will be in
6.5.1, due out July 15th.
Also, the snapshot on ftp.postgresql.org has the changes too.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026