Re: pgsql inserts problem

From: Tarhon-Onu Victor <mituc(at)iasi(dot)rdsnet(dot)ro>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: pgsql inserts problem
Date: 2003-08-28 06:29:03
Message-ID: Pine.LNX.4.55.0308280733550.10781@blackblue.iasi.rdsnet.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance

On Wed, 27 Aug 2003, Bruno Wolff III wrote:

> Did you check the error status for the records that weren't entered?
>
> My first guess is that you have some bad data you are trying to insert.

Of course, I checked the error status for every insert, there is
no error. It seems like in my case the postgres server cannot handle so
much inserts per second some of the lines are not being parsed and data
inserted into the database.
I don't know where can be the problem: in the DBD::Pg Perl DBI
driver or my postgresql server settings are not optimal.

--
Any views or opinions presented within this e-mail are solely those of
the author and do not necessarily represent those of any company, unless
otherwise expressly stated.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Shridhar Daithankar 2003-08-28 06:52:02 Re: pgsql inserts problem
Previous Message Wiseguy 2003-08-28 04:22:10 Re: Install postgresql 7.3 on Solaris 2.6 sparc

Browse pgsql-performance by date

  From Date Subject
Next Message Tomka Gergely 2003-08-28 06:38:47 Re: Hardware recommendations to scale to silly load
Previous Message Balazs Wellisch 2003-08-28 05:24:48 Re: Tests