Program lose the connection to backend

Поиск
Список
Период
Сортировка
От Ricardo Vaz Mannrich
Тема Program lose the connection to backend
Дата
Msg-id 200203111411.g2BEBLH20381@guarapuava.silcom.int.br
обсуждение исходный текст
Ответы Re: Program lose the connection to backend  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: ERROR: DefineIndex: index function must be marked iscachable
Следующее
От: "Dave"
Дата:
Сообщение: pg_hba.conf settings (was: Postgres not starting at boot...)