postgres array question

From: "George Kola" <kola(at)cs(dot)wisc(dot)edu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: postgres array question
Date: 2004-07-14 15:06:39
Message-ID: 200407141506.i6EF6iT25074@sabe.cs.wisc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


I am parsing log files and storing them in postgres. I find that I cannot
append an element into a null array with array_append. The only way that
appeared to me is to first query the array to find if it is null and use a
different syntax if it is null and use array_append otherwise. This was
initially OK, but I guess this would decrease the performance by a factor of
2 (because of the initial query). I am trying to load in several thousands
of log files and the process has been running overnight and did not
complete. Any suggestions on optimizing this process would be greatly
appreciated.

Thanks,
George

Browse pgsql-novice by date

  From Date Subject
Next Message Marcos Medina 2004-07-14 15:13:40 FOR-IN-EXECUTE, why fail?
Previous Message M. Bastin 2004-07-14 14:53:21 Re: Extended query: prepared statements list?