| From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
|---|---|
| To: | Brandon Aiken <BAiken(at)winemantech(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postgresql vs mysql |
| Date: | 2007-02-24 00:14:55 |
| Message-ID: | 738545.90712.qm@web31805.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> That's why you make a table for every device or every measurement, and
> then use a view to consolidate it. With update-able views, there's no
> excuse not to.
I would be interested on here some of your experiences on this?
I've built and made use of table hierarchies three levels deep and about twenty classification
types wide that I rolled up into separate update-able view. However, I found the process of
cascading the updates to all three levels of each classification type using the "TID" rather
tedious.
Regards,
Richard Broersma Jr.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2007-02-24 00:39:05 | Re: [HACKERS] 5 Weeks till feature freeze or (do you know where your patch is?) |
| Previous Message | Jim C. Nasby | 2007-02-24 00:08:05 | Re: [HACKERS] pg_autovacuum should allow NULL values |