Re: Querying a time range across multiple partitions

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Querying a time range across multiple partitions
Date: 2014-09-05 21:17:48
Message-ID: 540A287C.4030601@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/5/2014 10:31 AM, Cal Heldenbrand wrote:
> Number of child tables: 1581

that's an insane number of children. We try and limit it to 50 or so
child tables, for instance, 6 months retention by week, of data will
millions of rows/day.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cal Heldenbrand 2014-09-05 21:45:34 Re: Querying a time range across multiple partitions
Previous Message Alban Hertroys 2014-09-05 21:14:31 Re: Querying a time range across multiple partitions