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
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