Alter table set statistics with partitioned tables
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: Alter table set statistics with partitioned tables
- From: Kevin Keith <kkeith@xxxxxxxxxxxxxx>
- Date: Mon, 24 Jul 2006 12:27:25 -0400
- User-agent: Thunderbird 1.5 (X11/20051201)
I have had to bump the stats on a partitioned table in order to get the
planner to use an index over a seqscan. This has worked well in making
the system perform where it needs to as it reduced one query's execution
from > 45 seconds to < 1 second.
The one problem I have run into is that when I create a new child table
/ table partition, the stats value (attstattarget in pg_attribute) does
not get carried over from the parent - instead the system default (-1)
is set. Is it supposed to behave this way - meaning that I need to
explicitly define the custom value for each child table? Or is there a
way for this to be implicitly copied when the child table is created?
I prefer not to change the system default on all the tables in the
database because the value needs to be increased for one case.
Thanks,
Kevin
[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]