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
Dear Postgres Community,
I'm running postgres 8.3
I have a table, partitioned by month
-- Table: datadump
-- DROP TABLE datadump;
CREATE TABLE datadump
(
sys_timestamp timestamp without time zone,
sys_device_id integer,
usefields integer,
timedate timestamp without time zone,
digital
