Partitions and prepared statements?

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

 



I'm working with a large database using 8.4 that's partitioned on 4 week boundaries and when I use a prepared statement that limits by time as one of the bind parameters the planner seems to not select just the partitions of interest but wants to scan all of them. From reading the documentation of 9.3 ( http://www.postgresql.org/docs/9.3/static/sql-prepare.html ), it seems that this sort of limitation has been fixed. Is that a correct interpretation of the documentation?
Thanks,
Dave

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux