Re: Can I use PostgreSQL to develop a self-organizing database system?

"Rada Chirkova" <chirkova@csc.ncsu.edu> writes:
> at NC State University, my students and I are working on a project called
> "self-organizing databases," please see description below. I would like to
> use an open-source database system for implementation and would really
> appreciate your opinion on whether PostgreSQL is suitable for the project.

FWIW, I think Postgres will do very well as a base for your project.
But some might say I'm biased ;-)

Postgres was originally designed and built as a research tool, and it
still bears obvious traces of that heritage, even though the current
developers are almost single-mindedly focused on turning it into a
production tool.  You might find this entertaining:
http://archives.postgresql.org/pgsql-hackers/2002-06/msg00085.php

I'm not personally convinced that materialized views would be a great
thing to add to Postgres, but I look forward to being proven wrong.
Please keep us posted on your results.

            regards, tom lane

PS: BTW, pgsql-hackers is probably a better list than pgsql-general for
discussing research work with Postgres.