2010/2/5 Wojtek :
> Most of my queries will have where conditions on timedate and sys_device_id,
> but a lot of them will have additional clause: where usefields is not null.
> Some of the queries will be limited on timedate only.
What about a partial index on (timedate) WHERE usefields IS NOT N
2010/2/5 Wojtek
>
> partitions are will typically have from 200k to 300k rows, i have 52
> partitions per year and I'm keeping around 4-5 years of history. However,
> they will query last 3-4 months most often.
>
Do you mean 12 partitions a year or weekly partitions?
> Most of my queries will ha
