Re: Tale partitioning

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Tale partitioning
Date: 2006-04-26 20:33:04
Message-ID: 1d219a6f0604261333u1e0a2c0btb7786f3c32360f27@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2006-04-26 20:37:10 Re: Postmaster log perms and line suffix
Previous Message Gregory Maxwell 2006-04-26 20:11:47 UTF-8 vs ASCII