The row size limit - HELP
Hi,
(Sorry if this topic is already discussed too many times...)
I am porting a discussion forum database from Access to Postgresql.
(see: http://wwwedu.oulu.fi/dialogue)
Now I am facing the problem of only 8K row limit.
The main table contains the messages and it has some 16 columns. Most
of them are short but the proper message body column is quite large.
I just checked and the average length is 9K and longest are about 25-
26K.
Now (according to faq) there seems to be four possibilities open:
1) wait for version 7.1. How long that will take???
2) configure row limit to 32K. Is this a complicated process?? Side
effects?? After all even then size could be not enough!!
3) use "large object interface": This is most interesting! But what
it means??? where I can find more practical information about this???
4) save message bodies as files. There are 1655 rows now, so I am not
very interested in this possibility...
Thank you, I am very happy if you can give me some hints and
especially advice in the 3th alternative.
Esa Pikkarainen
On Friday 5 January 2001, at 9 h 41, the keyboard of "Esa Pikkarainen"
<epikkara@ktk.oulu.fi> wrote:
3) use "large object interface": This is most interesting! But what
it means??? where I can find more practical information about this???
It means trouble: you cannot use ordinary SQL requests, you need a new API, and some utilities (like pg_dump) do not handle them so a part of the database is not treated.
You can set the max number of backends with the parameter '-N nprocs' when
you start postmaster. So 'postmaster -N 64' will let you make 64 simultaneous
connections.
The default seting is 32 backends.
Nelson
Quoting eriko <eriko@radix.com.br>:
Show quoted text
What the max number of connections in postgresql database?
Thanks
Eriko.
Import Notes
Reply to msg id not found: 3A5628F1.F4E62A1@radix.com.br
You can set the max number of backends with the parameter '-N nprocs' when
you start postmaster. So 'postmaster -N 64' will let you make 64 simultaneous
connections.
The default seting is 32 backends.
Nelson
Quoting eriko <eriko@radix.com.br>:
Show quoted text
What the max number of connections in postgresql database?
Thanks
Eriko.
Import Notes
Reply to msg id not found: 3A5628F1.F4E62A1@radix.com.br
