Re: postgres limitation -what does it mean? (8k row limit)
От | Mitch Vincent |
---|---|
Тема | Re: postgres limitation -what does it mean? (8k row limit) |
Дата | |
Msg-id | 00a501c08882$c83d4b00$0200000a@windows обсуждение исходный текст |
Ответ на | Re: postgres limitation (The Hermit Hacker <scrappy@hub.org>) |
Список | pgsql-general |
In your src/include directory of the PostgreSQL tree (pre 7.1 of course) -- edit config.h (after you run configure or config.h.in before) and look for the line(s) : /* * Size of a disk block --- currently, this limits the size of a tuple. * You can set it bigger if you need bigger tuples. */ /* currently must be <= 32k bjm */ #define BLCKSZ 32768 There I have mine to 32k, the upper limit. Change it, save it, recompile PG, you will have to initdb and import all your data too.. Viola! Remember. Just because I haven't had any problems doesn't mena you won't. Check the mailing list archives, I there was a thread on the possible dangers of BLCKSZ. Depending on what you're doing, you might want to check out 7.1 Beta (4 is the latest I think), I've been running various beta versions for a month (not in production) but it seems pretty stable and there is no limit on tuple size :-) -Mitch ----- Original Message ----- From: "Matt Friedman" <matt@daart.ca> To: "Mitch Vincent" <mitch@venux.net>; <pgsql-general@postgresql.org> Sent: Friday, January 26, 2001 11:32 PM Subject: Re: postgres limitation -what does it mean? (8k row limit) > I've been following this thread but it's not clear to me what an 8k row > limit means exactly. > > Does it mean that the size of all the data in that row must not be greater > than 8k? That seems very small to me. > > Also, how does one change BLCKSZ? > > Some more detail on the subject would be great. thank you. > > Matt Friedman > > > > > ----- Original Message ----- > From: "Mitch Vincent" <mitch@venux.net> > To: <pgsql-general@postgresql.org> > Sent: Friday, January 26, 2001 7:28 PM > Subject: Re: postgres limitation > > > > > > the max size of a row... > > > > > > 8k in pre v7.1, no limit in v7.1 an dlater ... > > > > 32k really... BLCKSZ can be changed.. I've had no trouble running a > > production database with BLCKSZ set to 32k though there might be issues > I'm > > not aware of.. > > > > -Mitch > > > > > > > >
В списке pgsql-general по дате отправления: