Re: Large arrays give long lag on server side before command executes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Helgason <david(at)uti(dot)is>
Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>, postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Large arrays give long lag on server side before command executes
Date: 2004-09-26 15:25:46
Message-ID: 3834.1096212346@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Helgason <david(at)uti(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Hatcher 2004-09-26 15:43:44 Pg8.0 beta2 psql error
Previous Message Mage 2004-09-26 14:43:26 Re: Use of 'interval'