Partitions and prepared statements?

Поиск
Список
Период
Сортировка
От Dave Johansen
Тема Partitions and prepared statements?
Дата
Msg-id CAAcYxUfdcCKWw1+hA_gV3OUgZggBqpv1O4YER8Wa--_1DXt4wQ@mail.gmail.com
обсуждение исходный текст
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Gudmundsson Martin (mg)"
Дата:
Сообщение: Re: Stalls on PGSemaphoreLock
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Connection pooling - Number of connections