Postgres Pro
Downloads
Home   >   mailing lists

Thread: The row size limit - HELP

The row size limit - HELP

From
"Esa Pikkarainen"
Date:
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

Re: The row size limit - HELP

From
Stephane Bortzmeyer
Date:
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
handlethem so a part of the database is not treated.

Max connections

From
eriko
Date:
What the max number of connections in postgresql database?

Thanks

Eriko.

Re: Max connections

From
nelson@radix.com.br
Date:
    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>:

> What the max number of connections in postgresql database?
>
> Thanks
>
> Eriko.
>
>

Re: Max connections

From
nfj@radix.com
Date:
    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>:

> What the max number of connections in postgresql database?
>
> Thanks
>
> Eriko.
>
>