On 10/29/07, Campbell, Lance <[EMAIL PROTECTED]> wrote:
> Thanks for all of your help. The problem was that the result_entry table
> had some constraints that pointed to a third table. When I removed
> those constraints the performance was amazing. The update took less
> than seven minutes to exe
Gregory
Stark
Sent: Friday, October 26, 2007 9:05 PM
To: Joshua D. Drake
Cc: Campbell, Lance; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Suggestions on an update query
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> On Fri, 26 Oct 2007 15:31:44 -0500
> "Campbel
On Sat, 27 Oct 2007 03:04:47 +0100
Gregory Stark <[EMAIL PROTECTED]> wrote:
> > O.k. first you might be grinding through your 20 checkpoint segments
> > but in reality what I think is happening is you are doing foreign
> > key checks against all of it and slowing things down.
>
> If you're going
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> On Fri, 26 Oct 2007 15:31:44 -0500
> "Campbell, Lance" <[EMAIL PROTECTED]> wrote:
>
>> I forgot to include an additional parameter I am using in
>> Postgresql.conf:
>>
>
> O.k. first, just to get it out of the way (and then I will try and
> help).
On Fri, 26 Oct 2007 15:31:44 -0500
"Campbell, Lance" <[EMAIL PROTECTED]> wrote:
> I forgot to include an additional parameter I am using in
> Postgresql.conf:
>
O.k. first, just to get it out of the way (and then I will try and
help). Please do not top post, it makes replying contextually very
"Campbell, Lance" <[EMAIL PROTECTED]> writes:
>QUERY PLAN
>
>
>
>
> Hash Join (cost=1437.71..1046983.94 rows=17333178 width=32)
>Hash Cond: (result_entry.fk_question_id = question_num
I forgot to include an additional parameter I am using in
Postgresql.conf:
checkpoint_segments = 30
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
