Re: Article on MySQL vs. Postgres - Mailing list pgsql-hackers

From Michael Mayo
Subject Re: Article on MySQL vs. Postgres
Date
Msg-id 003f01bfe63c$b94200c0$cb324f0c@nobody
Whole thread Raw
In response to Article on MySQL vs. Postgres  (Tim Perdue <tperdue@valinux.com>)
List pgsql-hackers
----- Original Message -----
From: "Tim Perdue" <tperdue@valinux.com>

> Before I do that I want to confirm the major problem I had w/postgres:
> the 8K tuple limit.
   Just wanted to point out that this is not *exactly* true.  While the
default limit is 8k, all that is required to change it to 32k is to change
one line of text in config.h (blcksz from 8k to 32k).  This is pointed out
in the FAQ.  So I would really consider the *default* to be 8k and the
*limit* to be 32k.  IMHO 32k is good enough for 99% of tuples in a typical
bulletin-board-like application.  It is not unreasonable to reject posts >
32k in size.  Though you might want to evaluate performance using the 32k
tuples; might increase or decrease depending on application.
                 -Mike



pgsql-hackers by date:

Previous
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: Re: [GENERAL] Revised Copyright: is this morepalatable?
Next
From: eisentrp@csis.gvsu.edu
Date:
Subject: Re: createlang and PGLIB (was Re: [GENERAL] sequential test error)