Re: [PERFORM] left join + case - how is it processed?

2009-01-18 Thread Evan Carroll
> My guess is you can exclude rows with WHERE if the the > column used is an run-time computation involving an ad-hoc CASE. * that you can't -- Evan Carroll System Lord of the Internets -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make chan

Re: [PERFORM] left join + case - how is it processed?

2009-01-18 Thread Evan Carroll
mizer *could* more easily optimize this if you had used coalesce rather than an ad-hoc method with CASE. My guess is you can exclude rows with WHERE if the the column used is an run-time computation involving an ad-hoc CASE. -- Evan Carroll System Lord of the Internets -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] Regarding COPY command from Postgres 8.2.0

2007-09-18 Thread Evan Carroll
operator elegantly; and, even then it would require you to update your code, only slightly to a lesser degree than writing the column names. Evan Carroll ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [PERFORM] 8.2 Query 10 times slower than 8.1 (view-heavy)

2007-08-29 Thread Evan Carroll
On 8/28/07, Kevin Grittner <[EMAIL PROTECTED]> wrote: > >>> On Tue, Aug 28, 2007 at 10:22 AM, in message > <[EMAIL PROTECTED]>, "Evan Carroll" > <[EMAIL PROTECTED]> wrote: > > Yes, I ran vacuum full after loading both dbs. > > Have you r

Re: [PERFORM] 8.2 Query 10 times slower than 8.1 (view-heavy)

2007-08-28 Thread Evan Carroll
From: "Evan Carroll" <[EMAIL PROTECTED]> To: "Kevin Grittner" <[EMAIL PROTECTED]>, pgsql-performance@postgresql.org Date: Tue, 28 Aug 2007 11:21:54 -0500 Subject: Re: [PERFORM] 8.2 Query 10 times slower than 8.1 (view-heavy) On 8/28/07, Kevin Grittner <[EMAIL P

Fwd: [PERFORM] 8.2 Query 10 times slower than 8.1 (view-heavy)

2007-08-28 Thread Evan Carroll
-- Forwarded message -- From: Evan Carroll <[EMAIL PROTECTED]> Date: Aug 28, 2007 11:23 AM Subject: Re: [PERFORM] 8.2 Query 10 times slower than 8.1 (view-heavy) To: Scott Marlowe <[EMAIL PROTECTED]> On 8/28/07, Scott Marlowe <[EMAIL PROTECTED]> wrote: >

[PERFORM] 8.2 Query 10 times slower than 8.1 (view-heavy)

2007-08-28 Thread Evan Carroll
resql, and can be found at all times with the nick EvanCarroll. -- Evan Carroll System Lord of the Internets [EMAIL PROTECTED] 832-445-8877 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org