From: Robert Haas <robertmhaas@gmail.com>
To: Wojtek <foo@twine.pl>
Cc: pgsql-performance@postgresql.org
Subject: Re: index on partitioned table
Date: Fri, 5 Feb 2010 13:23:17 -0500
Message-ID: <603c8f071002051023s3101e1f6r5d330b98b491d4bf@mail.gmail.com> (raw)
In-Reply-To: <15213497474b6c0fe595df07.79488231.Active.mail@starapoczta.nazwa.pl>
References: <15213497474b6c0fe595df07.79488231.Active.mail@starapoczta.nazwa.pl>
2010/2/5 Wojtek <foo@twine.pl>:
> 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 NULL;
or maybe on (timedate, sys_device_id) WHERE usefields IS NOT NULL?
...Robert
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: robertmhaas@gmail.com, foo@twine.pl
Subject: Re: index on partitioned table
In-Reply-To: <603c8f071002051023s3101e1f6r5d330b98b491d4bf@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox