Обсуждение: Partitions and prepared statements?

Поиск
Список
Период
Сортировка

Partitions and prepared statements?

От
Dave Johansen
Дата:
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