big pg 6.5 and 7.1 problem in simple application 
Author Message
 big pg 6.5 and 7.1 problem in simple application

We have a simple ad tracking application, which has a (mostly) fixed
table size where each row represents a particular ad. We have about 70
rows in the database and use php scripts in apache which connect over
odbc, read a single row, increment a counter, and update that
row. We're performing about 30 updates a second and after a few
minutes the postmaster either hangs or dumps core.

We've tried this scenario on both pg 6.5 and 7.1 on redhat linux, from
redhat's rpms and built from source with the same results. We launch
256 backends with a reasonable shared buffer size. We're using the
unixodbc's odbc driver version 2.0.5. I don't think we're doing row
locks for the query, but that shouldn't crash it - it should just give
us bad data.

The tables, selects, and update calls are all pretty simple, so I'm
baffled by this behavior. Has anyone else seen this problem, or have a
solution?

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Mon, 20 Oct 2003 04:23:23 GMT
 big pg 6.5 and 7.1 problem in simple application

Quote:

> We have a simple ad tracking application, which has a (mostly) fixed
> table size where each row represents a particular ad. We have about 70
> rows in the database and use php scripts in apache which connect over
> odbc, read a single row, increment a counter, and update that
> row. We're performing about 30 updates a second and after a few
> minutes the postmaster either hangs or dumps core.

I'd try compiling 7.1 with debugging enabled, and do a GDB backtrace
on your core dumps.  Otherwise it's hard to help you.

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it {*filter*}d up my mind,
Now people just get uglier, and I got no sense of time...          --Dylan

---------------------------(end of broadcast)---------------------------



Mon, 20 Oct 2003 04:39:05 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. HOWTO for pg 7.1 installation from cvs

2. Authentication type 5 fails in PG 7.1 to 7.3 connect

3. PG 7.1 pre-beta bug ...

4. HOWTO for pg 7.1 installation from cvs

5. PG 7.1 pre-beta bug ...

6. Too Many Open Files PG 7.1

7. DB2 7.1 EEE Install problem on Win 2000 - _INS5576_MP-Application Error

8. DB2 PDE 7.1 on RedHat 7.1 problem

9. HELP on HANDLE Chinese BIG-5 in Informix 7.1 Online

10. Migration from Oracle 7.1 to SQL server 6.5

11. Building perl mods pg:PG or DBD:PG on non-PostgreSQLable machines

12. Building perl mods pg:PG or DBD:PG on non


 
Powered by phpBB® Forum Software