Re: Tale partitioning

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Tale partitioning
From: "Chris Hoover" <revoohc@xxxxxxxxx>
Date: Wed, 26 Apr 2006 16:33:04 -0400
Cc: pgsql-admin@xxxxxxxxxxxxxx
In-reply-to: <8511B4970E0D124898E973DF496F9B432515C3@xxxxxxxxxxxxxxxxxxxxx>
References: <8511B4970E0D124898E973DF496F9B432515C3@xxxxxxxxxxxxxxxxxxxxx>

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

Follow-Ups:
- Re: Tale partitioning
  - From: Jim C. Nasby

References:
- Tale partitioning
  - From: Benjamin Krajmalnik

Prev by Date: UTF-8 vs ASCII
Next by Date: Re: Postmaster log perms and line suffix
Previous by thread: Tale partitioning
Next by thread: Re: Tale partitioning
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux