Paul's PostgreSQL Blog - Comments

Heath: Self Managing Partition Example

nospam@example.com (Heath) — Thu, 13 Aug 2009 09:37:38 +0300

I noticed your tables do not have constraints on them. Won't this prevent PostgreSQL from achieving optimized queries via constraint exclusion?

See: http://www.postgresql.org/docs/8.4/static/ddl-partitioning.html#DDL-PARTITIONING-CONSTRAINT-EXCLUSION

Alexander: Self Managing Partition Example

nospam@example.com (Alexander) — Sun, 09 Aug 2009 09:00:47 +0300

kjInyz comment2, wado kai karate kata, 9496, affordable rail fencing, =-((, the oaks sports center, )), nhl power rankings fox sports, 506, important sports events 1996-2008, 06081, hideaway diving, dnl, benefits of a sports drink, sdp, npr payment sports newscast, >:-), cricket sports teams, daax, sports videos for sale, wgiyo, precast concrete tennis court panels modules, rvsjd, hertiage rally, jlg, tennis camp pa, :-PP, historical fencing masks, =-O, sports illustrated swimsuit nipple, 8770, sports ides of march, 154192, round rock sports complex schedule, :DD, 10 worst sports franchises, 035552, grooves motor sports, kiuy, tennis hut, >:-(((, diving columbia, 921, soccer socks epic sports, 8-DD, flag products sensory stimulation sports, tfdm, rally dunagiri etapa 9, 216147, yours sports bar, 5495, kelso sports, >:), tennis channel espn, 707232, scuba diving lanzarote, nlboll,

utnmvvqp: Self Managing Partition Example

nospam@example.com (utnmvvqp) — Fri, 07 Aug 2009 01:31:00 +0300

PnF6wa rbwyltbgsxuy, [url=http://xjwaxcifeiec.com/]xjwaxcifeiec[/url], [link=http://erewwmgifjzq.com/]erewwmgifjzq[/link], http://lztbtqfsqmwm.com/

Designer: Self Managing Partition Example

nospam@example.com (Designer) — Fri, 07 Aug 2009 00:53:36 +0300

daytime ambulatory diastolic; cialis =-DD; lasix %-D; doxycycline >:]]; viagra =-[;

deejrandom: Self Managing Partition Example

nospam@example.com (deejrandom) — Thu, 06 Aug 2009 23:24:30 +0300

weight loss program; tramadol 063; nexium ebmkk; xanax 3468; ambien 1462;

TicTac: Self Managing Partition Example

nospam@example.com (TicTac) — Thu, 06 Aug 2009 21:56:17 +0300

modify perception concerning; alli :-PPP; meridia =D; cialis 8PPP; doxycycline :-OOO; valium 606018;

Drop: Self Managing Partition Example

nospam@example.com (Drop) — Thu, 06 Aug 2009 20:26:19 +0300

article distribution lists; nexium :[; xanax :]]; acomplia 303588; propecia =(((;

Slava: Self Managing Partition Example

nospam@example.com (Slava) — Thu, 06 Aug 2009 19:48:52 +0300

cool! looking forward!

Scribe: Self Managing Partition Example

nospam@example.com (Scribe) — Wed, 05 Aug 2009 21:46:46 +0300

For the hypochondriac this may not be the best choice.; home insurance :D; auto insurance >:PPP; health insurance 6623;

aiaetb: Self Managing Partition Example

nospam@example.com (aiaetb) — Wed, 05 Aug 2009 07:16:31 +0300

eNYPNg usaxpoihasqq, [url=http://ddaowzvtlygf.com/]ddaowzvtlygf[/url], [link=http://xengztzwkoxy.com/]xengztzwkoxy[/link], http://mfgcwevtmpyv.com/

Greg Smith: Self Managing Partition Example

nospam@example.com (Greg Smith) — Tue, 04 Aug 2009 22:02:54 +0300

Patches to handle automatic partitioning within the database are in progress; see http://archives.postgresql.org/message-id/bd8134a40906080702s96c90a9q3bbb581b9bd0d5d7@mail.gmail.com for a recent implementation and http://archives.postgresql.org/message-id/1247564358.11347.1308.camel@ebony.2ndQuadrant for some of the remaining improvements it needs before being committed. Based on its current maturity and how helpful the feature would be, I expect that work to complete before the next PostgreSQL verison (8.5 or 9.0 or whatever it ends up being) is released.

Slava: Self Managing Partition Example

nospam@example.com (Slava) — Mon, 03 Aug 2009 23:22:03 +0300

The amount of code for automated partitioning proves that we would really need to have it managed in Postgres by some sort of partition template like in Oracle.
I have also implemented something like that, but it is pretty hard to implement partitioning for someone who haven't done it or has less experience with pgsql.

Vincenzo Romano: Self Managing Partition Example

nospam@example.com (Vincenzo Romano) — Mon, 03 Aug 2009 20:59:37 +0300

instead of the ... you should have read PRE and /PRE tags.

Vincenzo Romano: Self Managing Partition Example

nospam@example.com (Vincenzo Romano) — Mon, 03 Aug 2009 20:48:54 +0300

Few remarks to the article.
I would use the ... tags to have the code shown in a better way, maybe with indenstation.
Them I would also include some example table, to show the relationship between the function code and the schema itslef.
You coul put a .sql file with all the relevant code for a simple try.
Anyway, your solutions looks very interesting, but needs some work be understood.

Cameron Eure: PostgreSQL 8.4 makes it's own fireworks in July

nospam@example.com (Cameron Eure) — Sun, 05 Jul 2009 22:12:13 +0300

I look forward to using Recursive CTEs in the future. I agree, great release, but I'm a little disappointed that Hot Standby didn't make the final cut. A lot of work has been going into it, though, hopefully it will be ready in time for the next release.