NO INHERIT and prepared statements?

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

 



We have a time-based partitioning scheme and with Postgres 8.4 on RHEL 6 we would "detach" a partition that was no longer being written to and CLUSTER it before "re-attaching" it [1]. This never seemed to have any issues, but we recently upgraded to Postgres 9.2 on RHEL 7 and we've noticed a few instances where prepared statements fail and it appears to be caused by running NO INHERIT to "detach" the partition that is no longer being written to. Is this an issue caused by the changes in the planner in regards to how prepared statements are handled [2]?

Thanks,
Dave

[1] http://www.postgresql.org/message-id/CAAcYxUcZRzfq3RPXEkuRFgqduiRaFA2RgTaHkPBTizZZhmZRwA@xxxxxxxxxxxxxx
[2] https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.2#Performance_improvements

[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