Обсуждение: Partitioned tables, rules, triggers
Hi, I have two questions on the above: 1. I found in some postings recommended to use triggers instead of rules. Is this documented somewhere? 2. When using trigger, any examples on how to update the trigger dynamically when tables are added or deleted from the partitioned? Thanks, Amin
On 10/3/07, Goboxe <hadzramin.ar@gmail.com> wrote: > Hi, > > I have two questions on the above: > > 1. I found in some postings recommended to use triggers instead of > rules. Is this documented somewhere? A howto is available at http://images.omniti.net/omniti.com/talks/partitions-public.pdf - Josh/eggyknap
On 10/5/07, Josh Tolley <eggyknap@gmail.com> wrote: > On 10/3/07, Goboxe <hadzramin.ar@gmail.com> wrote: > > Hi, > > > > I have two questions on the above: > > > > 1. I found in some postings recommended to use triggers instead of > > rules. Is this documented somewhere? > > A howto is available at > http://images.omniti.net/omniti.com/talks/partitions-public.pdf Wow, that is a great presentation. I now feel like I'll be missing out on not going to the pgsql conference this year.
On Oct 5, 2007, at 10:53 AM, Scott Marlowe wrote: > On 10/5/07, Josh Tolley <eggyknap@gmail.com> wrote: >> On 10/3/07, Goboxe <hadzramin.ar@gmail.com> wrote: >>> Hi, >>> >>> I have two questions on the above: >>> >>> 1. I found in some postings recommended to use triggers instead of >>> rules. Is this documented somewhere? >> >> A howto is available at >> http://images.omniti.net/omniti.com/talks/partitions-public.pdf > > Wow, that is a great presentation. I now feel like I'll be missing > out on not going to the pgsql conference this year. I'm with you on that. Since I went to Portland for the mini-Postgres Day and OSCON just a couple of months ago I couldn't really ask my company to cover another trip to the same place so soon. But, there's always PGCon next May! Erik Jones Software Developer | Emma® erik@myemma.com 800.595.4401 or 615.292.5888 615.292.0777 (fax) Emma helps organizations everywhere communicate & market in style. Visit us online at http://www.myemma.com
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Erik Jones wrote: > On Oct 5, 2007, at 10:53 AM, Scott Marlowe wrote: > >> On 10/5/07, Josh Tolley <eggyknap@gmail.com> wrote: >>> On 10/3/07, Goboxe <hadzramin.ar@gmail.com> wrote: >>>> Hi, >>>> >>>> I have two questions on the above: >>>> >>>> 1. I found in some postings recommended to use triggers instead of >>>> rules. Is this documented somewhere? >>> >>> A howto is available at >>> http://images.omniti.net/omniti.com/talks/partitions-public.pdf >> >> Wow, that is a great presentation. I now feel like I'll be missing >> out on not going to the pgsql conference this year. > > I'm with you on that. Since I went to Portland for the mini-Postgres > Day and OSCON just a couple of months ago I couldn't really ask my > company to cover another trip to the same place so soon. But, there's > always PGCon next May! And: PostgreSQL Conference Winter (Los Angeles) PostgreSQL Conference Spring (East cost somewhere undecided) Sincerely, Joshua D. Drake > > Erik Jones > > Software Developer | Emma® > erik@myemma.com > 800.595.4401 or 615.292.5888 > 615.292.0777 (fax) > > Emma helps organizations everywhere communicate & market in style. > Visit us online at http://www.myemma.com > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHBm1wATb/zqfZUUQRAuwjAJ9b7E0fyY2E2FfngrkI+Seifjvu5wCfSQ7T TQG1OGww3urR+fN+TQ95X/A= =OWRg -----END PGP SIGNATURE-----
Josh, Thanks for sharing a very good info on partitioning. On Oct 5, 10:08 pm, eggyk...@gmail.com ("Josh Tolley") wrote: > On 10/3/07, Goboxe <hadzramin...@gmail.com> wrote: > > > Hi, > > > I have two questions on the above: > > > 1. I found in some postings recommended to use triggers instead of > > rules. Is this documented somewhere? > > A howto is available athttp://images.omniti.net/omniti.com/talks/partitions-public.pdf > > - Josh/eggyknap > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match
On 10/6/07, Goboxe <hadzramin.ar@gmail.com> wrote: > Josh, > > Thanks for sharing a very good info on partitioning. > Don't thank me -- this comes from Robert Treat. I'm just the messenger :) -Josh/eggyknap