Re: Why does a normally fast query run so slow when the table is in a partition?

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Bill Thoen <bthoen(at)gisnet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why does a normally fast query run so slow when the table is in a partition?
Date: 2011-02-02 21:08:57
Message-ID: 4D49C7E9.4060802@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/02/2011 12:17 PM, Bill Thoen wrote:
> I've got a large (and growing) database set up as a partitioned
> database....
What is the setting of contstraint_exclusion?
http://www.postgresql.org/docs/9.0/static/runtime-config-query.html#GUC-CONSTRAINT-EXCLUSION

Cheers,
Steve

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yves Weißig 2011-02-02 21:16:42 effective_io_concurrency
Previous Message Bosco Rama 2011-02-02 20:49:32 Re: redirecting query statement and output to a marked up file, using psql