On Thu, 23 Oct 2008 23:41:49 -0600
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> On Thu, Oct 23, 2008 at 8:48 PM, Scott Carey <[EMAIL PROTECTED]> wrote:
> > If you are doing batch inserts of data, and want to have reporting queries
> > concurrently running, make sure you have the pg_xlogs on a diff
"Scott Marlowe" wrote:
> I second this. Partitioning in time in past reporting databases
> resulted in huge performance improvements for select queries.
Most statements will load data from a single year, but multiple monthes.
I have a integer field containing the year and will use it for
partit
