Am 08.11.2011 13:15, schrieb Mohamed Hashim:
Hi Sam,Tomas
In my first post i have mentioned all how much shared (shared
buffers, effective cache size, work mem, etc.) and my OS and
hardware information and what are the basic settings i have
changed
and regarding Explain analyze i gave one sample query because if i
tune that particular table which has records almost 16crore i
thought my problem will solve...
Just curios, are those array items [1] and [2] just samples and you
actually use more which are performance-related (used as condition)?
If just those two are relevant I would change the schema to use real
columns instead. And you seem to use partitioning, but you have no
partition condition?
|
