Program lose the connection to backend - Mailing list pgsql-general

From Ricardo Vaz Mannrich
Subject Program lose the connection to backend
Date
Msg-id 200203111411.g2BEBLH20381@guarapuava.silcom.int.br
Whole thread Raw
Responses Re: Program lose the connection to backend  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I have a program thar reads a file with a lot of rows (10000) and, sometimes,
my program can't insert new rows to the database because it lost the
connection to the backend. The problem is random and I don't know what
happens.

This occurs also sometimes when I run a big query or  VACUUM. SOMETIMES.

I'm using Postgres 7.1.2 and 7.2.

I think that postgres 7.2 slower than 7.1.2. My program processed 650 files 4
times faster in 7.1.2 using the same database structure (created by pg_dump
-s). Is this true? Is 7.2 slower?

Thank a lot,

--
Ricardo Vaz Mannrich
Linux user: #158685

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: ERROR: DefineIndex: index function must be marked iscachable
Next
From: "Dave"
Date:
Subject: pg_hba.conf settings (was: Postgres not starting at boot...)