[ADMIN] Problem with JDBC transactions

2001-02-07 Thread Rainer Mager
Hi all, We're having some pretty serious problems with transactions via JDBC. We're running on Linux with PG 7.0.3 and Sun's 1.2.2 Java VM. The issue is that we have a reasonably large number of connections to our database (as much as 80 simultaneously although the problem happen

[ADMIN] cocurrent access

2001-02-07 Thread a
When stress test Postgres, It can only hold about 200 cocurrent connection while keep calling DriverManager.getConnection() Is this number configurable? Or it is the limitation of postgres? Any suggestion? Thanks Feng

Re: [ADMIN] PostgreSQL client libraries only.

2001-02-07 Thread Peter Eisentraut
C. Bensend writes: > Can anyone point me to a tarball of the PostgreSQL libraries only, or > a ./configure option that will allow me to only install the libraries > needed for Apache/PHP to access a remote PostgreSQL database? configure as normal. Then 'gmake -C src/interfaces/libpq all|install

Re: [ADMIN] Create index problem ( _bt_sort )

2001-02-07 Thread Yasuo Ohgaki
> > raslog=# create index user2000 on log2000(username); > > FATAL 1: btree: failed to add item to the page in _bt_sort (2) > >> > >> How long are the usernames? IIRC, 7.0.* has some edge cases that might > >> fail when items approach the maximum allowed size of 1/3 page (~ 2700 > >> bytes). > >