From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Remove "JDBC repositories merge")
(Serializable transaction isolation level)
Line 11: Line 11:
== Current Work In Process ==
== Current Work In Process ==
=== Serializable transaction isolation level ===
=== Declarative materialized views ===
A discussion of the goals, development plans, status, and issues is on the [[Serializable]] Wiki page. See that page for links to list discussion archives, papers, and a git repository.
For the 9.3 release.
== Possible Future Work ==
== Possible Future Work ==

Revision as of 17:26, 29 February 2012

Information about Kevin Grittner and his activities.




Kevin is currently employed as a database administrator with the Consolidated Court Automation Programs (CCAP) at the Wisconsin Court System. He's been making a living in the computer industry since 1972. He started a consulting company in 1980 after working in data control, operations, programming, systems analysis, and design. He was finally lured back to employee status in his current position after more than a quarter century of consulting.

Kevin has experience with many types of applications in many types of organizations, businesses, and government. In 1984 he was the architect and primary author of the PROBER database and development system, used by thousands of corrections agencies, health departments, hospitals, and fire departments around the world. (The last known use was a statewide health department which converted off the product in 2006.) He has also developed application development platforms used by clients to speed development, improve standardization, and provide portability.

Current Work In Process

Declarative materialized views

For the 9.3 release.

Possible Future Work

Rewrite tsearch parser to use regular expressions

In reviewing a patch to fix some performance problems in the current parser, I became interested in the possibility of rewriting the current state machine implementation with a regular expression implementation.

Re: tsearch parser inefficiency if text includes urls or emails - new version

tsearch parser overhaul

Deleted WAL files held open by backends in Linux

I wasted some time tracking down an oddity which is more of an annoyance in system administration than a real problem, but might look at cleaning it up to save others the bother of investigating the issue.

Deleted WAL files held open by backends in Linux

Temporal data improvements

Temporal data handling is weak in SQL in general, and the PostgreSQL implementation seems skewed toward scientific or engineering applications, leaving it weaker than some databases on business applications. (One example would be clean handling of monthy payment schedules.) Enhancements to this area might be interesting.

Proposal - temporal contrib module

Re: Timezones (in 8.5?)

LSB script compliance

I came up with a pretty LSB compliant script for Linux; however, the community feels that most of the logic handled in the shell in this script should be moved into pg_ctl. There's a pretty long and winding thread on the topic. The last version of the script might be useful to identify what issues need to be covered in the current pg_ctl code.

We should Axe /contrib/start-scripts

Linux LSB init script

TOAST improvements

There have been a few posts to the lists about specific use cases where TOAST defaults are far from optimal. Allowing some tuning here might be helpful.

Higher TOAST compression

Literal and NULL handling anomalies

There are a few corner cases where differences between standard and PostgreSQL behaviors with string literals or NULLs astonish those new to PostgreSQL. These aren't easily solved, but might be worth the effort.

README files

Language is not always as readable as it could be, and some files still largely read like proposals for features which are now implemented.

Personal tools