kgrittn

1,424 reputation

316

bio	website	wiki.postgresql.org/wiki/…
	location	Madison, WI
	age	58
visits	member for	1 year, 1 month
	seen	Apr 12 at 21:03
stats	profile views	70

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 that 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

	1,424 reputation	bio	website	wiki.postgresql.org/wiki/…	visits	member for	1 year, 1 month
316 badges		location	Madison, WI		seen	Apr 12 at 21:03

summary answers questions tags badges favorites bounties reputation activity

15 Revisions

suggestions reviews revisions comments badges posts accepts all

Feb 10	revised	Postgresql - Segmentation fault (core dumped) Add a paragraph to address the setfault aspect of the question.
Jan 18	revised	how to query for rows by specifying the range of row numbers in postgresql Clean up formatting to better represent quotes.
Oct 27	revised	Locking issue with concurrent DELETE / INSERT in PostgreSQL Add some additional elaborations.
Aug 2	revised	Set a column's default value to the concatenation of two other columns' values? Add information about using the field for indexed searches.
Jun 30	revised	PostgreSQL PITR restore edited tags
Jun 25	revised	Trouble recovering data from corrupted PostgreSQL tables Simplify some clumsy language (minor change).
Jun 24	revised	Syncing two (or more) PostgreSQL 9.1 clusters Add a reference to Postgres-XC, which recent hit their 1.0 production release.
May 14	revised	Partial vacuum and whole table vacuum Formated copy/paste example run to avoid messy display.
May 13	revised	Partial vacuum and whole table vacuum More directly answer the explicit question.
May 12	revised	Altering table schema takes too much time Quote the whole release notes entry, rather than just a portion, to see if the disconnect problem occurs.
Apr 26	revised	Is the CPU performance relevant for a database server? Fix typo.
Apr 20	revised	PostgreSQL 9.1 Hot Backup Error: the database system is starting up Format for readability.
Apr 15	revised	Concurrency with Select-conditional Insert/Update/Delete - PostgreSQL Try to clarify "full disclosure" credits.
Apr 15	revised	Concurrency with Select-conditional Insert/Update/Delete - PostgreSQL added 71 characters in body
Apr 12	revised	How can I write a proper query to JOIN all of these tables without duplicates? Fix errors in sampe code.