Re: Large CASE-statement is pretty slow?

From: Arjen van der Meijden <acmmailing(at)vulcanus(dot)its(dot)tudelft(dot)nl>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Large CASE-statement is pretty slow?
Date: 2004-03-15 18:54:21
Message-ID: 4055FBDD.1020207@vulcanus.its.tudelft.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Stark wrote:

> Arjen van der Meijden <acmmailing(at)vulcanus(dot)its(dot)tudelft(dot)nl> writes:
>
>
> Was this the select with the CASE, or the update?

It was just the select to see how long it'd take. I already anticipated
it to be possibly a "slow query", so I only did the select first.

Best regards,

Arjen van der Meijden

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2004-03-15 20:09:31 Re: Scaling further up
Previous Message Greg Stark 2004-03-15 17:20:49 Re: Large CASE-statement is pretty slow?