Gaetano Mendola <[EMAIL PROTECTED]> writes:
> Pavel Veretennikov wrote:
> | What could be a problem? About 3G of shared memory is allocated to PG,
> | 85 shared_buffers.
> I don't know what you problem can be but are you sure you need that
> *very huge* ammount of shared memory ?
Conventional
Roberto De Shong wrote:
> Actually I got it solved, I recompiled the kernel adding the options below:
> optionsSYSVSHM
> optionsSYSVSEM
> optionsSYSVMSG
> optionsSHMMAXPGS=65536
> optionsSEMMNI=40
> optionsSEMMNS=240
> optionsSEMUME=40
> optio
Actually I got it solved, I recompiled the kernel adding the options below:
options SYSVSHM
options SYSVSEM
options SYSVMSG
options SHMMAXPGS=65536
optionsSEMMNI=40
options SEMMNS=240
options SEMUME=40
options SEMMNU=120
And I made the fol
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pavel Veretennikov wrote:
| What could be a problem? About 3G of shared memory is allocated to PG,
| 85 shared_buffers.
I don't know what you problem can be but are you sure you need that
*very huge* ammount of shared memory ? Let us know your tipic
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Roberto De Shong wrote:
| I have installed PostgreSQL 7.3 on FreeBSD 4.10 Stable, and have been
| trying to increase the max connections. the most I'm able to is 40, if I
| increase it any higher I'm unable to start the database. Is there any
| tip, s h
Roberto De Shong wrote:
> I have installed PostgreSQL 7.3 on FreeBSD 4.10 Stable, and have been
> trying to increase the max connections. the most I'm able to is 40,
> if I increase it any higher I'm unable to start the database.
You need to show the error message if you want relevant help.
--
P
Hi
How import an oracle (Win) table data to postgres (linux)
Radhakrishnan
Reply to [EMAIL PROTECTED]
I have installed PostgreSQL 7.3 on FreeBSD 4.10 Stable, and have been trying to increase the max connections. the most I'm able to is 40, if I increase it any higher I'm unable to start the database. Is there any tip, s hte any guide where I can get an idea of the other values to set in postgresql.
I ran into this error running 2 user connection executing consecutive
selects in a loop.
What could be a problem? About 3G of shared memory is allocated to PG,
85 shared_buffers.
TopMemoryContext: 32768 total in 3 blocks; 20024 free (22 chunks); 12744
used
TopTransactionContext: 8192 tot
On Fri, 2004-07-23 at 12:23, Werner vd Merwe wrote:
> We are running a PG7.4 database, being accessed through jspâs called
> through Tomcat. The problem is, that sometimes the database comes to a
> complete standstill, sometimes because of deadlocks, but I would
> venture to say that most times it
10 matches
Mail list logo