[PERFORM] Memory-olic query and Materialize

2013-09-12 Thread Souquieres Adam
Hi To all Pg performance users, we've found a strange behaviour in PostgreSQL 9.1.9. _Here' our server not default configuration :_ default_statistics_target = 100 # pgtune wizard 2011-07-06 maintenance_work_mem = 384MB # pgtune wizard 2011-07-06 constraint_exclusion = on # pgtune wizard 2011-0

[PERFORM] Query on partitioned table not using index

2014-04-22 Thread Souquieres Adam
dex on all partition on cabmnt___rfovsnide : why dont postgres use it ? We have a test environment with similar data and configuration*in version 9.1*, and the same query is under 1ms, the plan is not same, it use index on all partition and keep only one row from each. Is this behaviour quite logic in 8.4 ? Thank you for your time. Souquieres Adam