Re: Tale partitioning - Mailing list pgsql-admin

From Chris Hoover
Subject Re: Tale partitioning
Date
Msg-id 1d219a6f0604261333u1e0a2c0btb7786f3c32360f27@mail.gmail.com
Whole thread Raw
In response to Tale partitioning  ("Benjamin Krajmalnik" <kraj@illumen.com>)
Responses Re: Tale partitioning
List pgsql-admin
Each of the partition tables needs it's own set of indexes.  Build them, and see if the does not fix your performance issues.  Also, be sure you turned on the constraint_exclusion parameter, and each table (other than the "master") has an constraint on it that is unique.

HTH,

Chris



pgsql-admin by date:

Previous
From: "Gregory Maxwell"
Date:
Subject: UTF-8 vs ASCII
Next
From: "Chris Hoover"
Date:
Subject: Re: Postmaster log perms and line suffix