User:Kgrittn

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Serializable transaction isolation level)
(Bio: Replace with new bio based on job at EDB)
Line 5: Line 5:
 
== Bio ==
 
== Bio ==
  
Kevin is currently employed as a database administrator with the [http://www.wicourts.gov/about/organization/offices/ccap.htm Consolidated Court Automation Programs (CCAP)] at the [http://www.wicourts.gov 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.
+
I've been making my living working with computers since 1972. In 1980 I founded a consulting company I ran until 2005; during that time I worked with a wide variety of applications, organizations, and technical environments. I'm now with EnterpriseDB as a database architect. I'm a committer for the free, open source version of PostgreSQL, and an active member of the community.
  
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.
+
By far the largest patch I've worked on for PostgreSQL has been the Serializable Snapshot Isolation (SSI) implementation which went into PostgreSQL version 9.1. This was a joint project with Dan R.K. Ports of MIT, with helpful input and support from many in the PostgreSQL community. Our paper on that effort can be found here:
 +
 
 +
http://vldb.org/pvldb/vol5/p1850_danrkports_vldb2012.pdf
 +
 
 +
For the PostgreSQL docs on the feature, see:
 +
 
 +
http://www.postgresql.org/docs/current/interactive/transaction-iso.html
 +
 
 +
For a number of examples see:
 +
 
 +
http://wiki.postgresql.org/wiki/SSI
  
 
== Current Work In Process ==
 
== Current Work In Process ==

Revision as of 20:29, 31 January 2013

Information about Kevin Grittner and his activities.

Kevin-Grittner.jpg

Contents

Bio

I've been making my living working with computers since 1972. In 1980 I founded a consulting company I ran until 2005; during that time I worked with a wide variety of applications, organizations, and technical environments. I'm now with EnterpriseDB as a database architect. I'm a committer for the free, open source version of PostgreSQL, and an active member of the community.

By far the largest patch I've worked on for PostgreSQL has been the Serializable Snapshot Isolation (SSI) implementation which went into PostgreSQL version 9.1. This was a joint project with Dan R.K. Ports of MIT, with helpful input and support from many in the PostgreSQL community. Our paper on that effort can be found here:

http://vldb.org/pvldb/vol5/p1850_danrkports_vldb2012.pdf

For the PostgreSQL docs on the feature, see:

http://www.postgresql.org/docs/current/interactive/transaction-iso.html

For a number of examples see:

http://wiki.postgresql.org/wiki/SSI

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