Postgres Pro
Downloads
Home   >   mailing lists

Re: Why does a normally fast query run so slow when the table is in a partition? - Mailing list pgsql-general

From Steve Crawford
Subject Re: Why does a normally fast query run so slow when the table is in a partition?
Date
Msg-id 4D49C7E9.4060802@pinpointresearch.com
Whole thread Raw
In response to Why does a normally fast query run so slow when the table is in a partition?  (Bill Thoen <bthoen@gisnet.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Yves Weißig
Date:
Subject: effective_io_concurrency
Next
From: Steve Crawford
Date:
Subject: Re: Why does a normally fast query run so slow when the table is in a partition?