Skip site navigation (1) Skip section navigation (2)

Test case for slow planning time

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Test case for slow planning time
Date: 2007-04-20 23:03:34
Message-ID: 87ps5y8x89.fsf@oxford.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-patches
I've been trying this query with and without constraint_exclusion turned on.

explain select * from a where i between 999 and 1001;


Attachment: dump3.bz2
Description: application/octet-stream (59.5 KB)

pgsql-patches by date

Next:From: Zoltan BoszormenyiDate: 2007-04-21 07:48:52
Subject: Re: [HACKERS] parser dilemma
Previous:From: Heikki LinnakangasDate: 2007-04-20 15:21:09
Subject: Re: Dead Space Map version 3 (simplified)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group