| From: | "Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com> |
|---|---|
| To: | "Erik Jones" <erik(at)myemma(dot)com>, "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
| Cc: | <arnaulist(at)andromeiberica(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Partitioning |
| Date: | 2007-01-11 12:59:20 |
| Message-ID: | 7F10D26ECFA1FB458B89C5B4B0D72C2B82CFCF@sesrv12.wirelesscar.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> On Fri, Jan 05, 2007 at 12:47:08PM +0100, Mikael Carneholm wrote:
> >> Take a look at the set of partitioning functions I wrote shortly
after
> >> the 8.1 release:
> >>
> >> http://www.studenter.hb.se/~arch/files/part_functions.sql
> >>
> >> You could probably work something out using those functions (as-is,
or
> >> as inspiration) together with pgAgent
> >> (http://www.pgadmin.org/docs/1.4/pgagent.html)
> >>
> >> /Mikael
> >>
> Those are some great functions.
>
Well, they're less than optimal in one aspect: they add one rule per
partition, making them unsuitable for OLTP type applications (actually:
any application where insert performance is crucial). Someone with time
and/or energy could probably fix that, I guess...patches are welcome :)
/Mikael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Haile | 2007-01-11 14:02:01 | Re: Partitioning |
| Previous Message | Bernd Helmle | 2007-01-11 12:51:12 | Re: Partitioning |