Postgres Pro
Downloads
Home   >   mailing lists

Re: Large arrays give long lag on server side before command executes - Mailing list pgsql-general

From Tom Lane
Subject Re: Large arrays give long lag on server side before command executes
Date
Msg-id 3834.1096212346@sss.pgh.pa.us
Whole thread Raw
In response to Re: Large arrays give long lag on server side before command executes  (David Helgason <david@uti.is>)
Responses Re: Large arrays give long lag on server side before command executes  (David Helgason <david@uti.is>)
List pgsql-general
Tree view 
David Helgason <david@uti.is> writes:
> On 25. sep 2004, at 01:42, Tom Lane wrote:
>> No, it's not the same --- David sent me some results off-list and it
>> seems ReadArrayStr is the culprit.  I'm not completely sure why yet.

> After playing around, I found the culprit.

I suspected as much but couldn't be sure without seeing your test data.
I take it you have lots of quotes and/or backslashes in your big array
values?

            regards, tom lane

pgsql-general by date:

Previous
From: Mage
Date:
Subject: Re: Use of 'interval'
Next
From: "Patrick Hatcher"
Date:
Subject: Pg8.0 beta2 psql error