Re: postgresql vs mysql - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: postgresql vs mysql
Date
Msg-id 738545.90712.qm@web31805.mail.mud.yahoo.com
Whole thread Raw
In response to Re: postgresql vs mysql  ("Brandon Aiken" <BAiken@winemantech.com>)
List 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.

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [HACKERS] pg_autovacuum should allow NULL values
Next
From: Gregory Stark
Date:
Subject: Re: [HACKERS] 5 Weeks till feature freeze or (do you know where your patch is?)