Re: My honours project - databases using dynamically attached entity-properties

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>
Cc: postgres hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: My honours project - databases using dynamically attached entity-properties
Date: 2007-03-15 16:25:19
Message-ID: 1173975919.9058.177.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 2007-03-15 at 17:01, A.M. wrote:
> It seems to me that postgresql is especially well-suited to run DDL
> at runtime, so what's the issue?

The issue is that some applications are not well suited to run DDL at
runtime :-)

As I already mentioned in another post in this thread, our application
also has a requirement of user defined fields in one table. Problem is,
that table is so accessed in peak hours, that it is simply impossible to
take an exclusive lock on it without causing an extended perceived
downtime of the application. And guess what, users will always want to
add new fields in peak hours...

We did solve this in our case with some application logic, but a generic
solution would be nice ;-)

Cheers,
Csaba.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-03-15 16:33:45 Re: My honours project - databases using dynamically attached entity-properties
Previous Message Teodor Sigaev 2007-03-15 16:17:54 tsearch_core for inclusion