| Commit message (Collapse) | Author | Age | |
|---|---|---|---|
| * | Move some system includes into c.h, and remove duplicates. | Bruce Momjian | 1999-07-17 |
| | | |||
| * | Add config.h as needed. | Bruce Momjian | 1999-07-17 |
| | | |||
| * | Final cleanup. | Bruce Momjian | 1999-07-16 |
| | | |||
| * | Update #include cleanups | Bruce Momjian | 1999-07-16 |
| | | |||
| * | Add var defines for no testandset | Bruce Momjian | 1999-06-26 |
| | | |||
| * | Move default NBuffers setting into config.h, and rename it | Tom Lane | 1999-06-12 |
| | | | | | | to DEF_NBUFFERS for readability. Make sure the default value is OK according to postmaster.c's new sanity check for -B values. | ||
| * | pgindent run over code. | Bruce Momjian | 1999-05-25 |
| | | |||
| * | Repair some pretty serious problems in dynahash.c and | Tom Lane | 1999-02-22 |
| | | | | | | | shared memory space allocation. It's a wonder we have not seen bug reports traceable to this area ... it's quite clear that the routine dir_realloc() has never worked correctly, for example. | ||
| * | Change my-function-name-- to my_function_name, and optimizer renames. | Bruce Momjian | 1999-02-13 |
| | | |||
| * | Initial MVCC code. | Vadim B. Mikheev | 1998-12-15 |
| | | | | | New code for locking buffer' context. | ||
| * | OK, folks, here is the pgindent output. | Bruce Momjian | 1998-09-01 |
| | | |||
| * | Rename BindingTable to ShmemIndex. | Bruce Momjian | 1998-06-27 |
| | | |||
| * | Goodbye ABORT. Hello ERROR for all errors. | Bruce Momjian | 1998-01-07 |
| | | |||
| * | Change elog(WARN) to elog(ERROR) and elog(ABORT). | Bruce Momjian | 1998-01-05 |
| | | |||
| * | Good Bye, Time Travel! | Vadim B. Mikheev | 1997-11-02 |
| | | |||
| * | Inline memset() as MemSet(). | Bruce Momjian | 1997-09-18 |
| | | |||
| * | Inline frequently called functions. | Bruce Momjian | 1997-09-18 |
| | | |||
| * | Another PGINDENT run that changes variable indenting and case label ↵ | Bruce Momjian | 1997-09-08 |
| | | | | | indenting. Also static variable indenting. | ||
| * | Massive commit to run PGINDENT on all *.c and *.h files. | Bruce Momjian | 1997-09-07 |
| | | |||
| * | Added SCO support, from Daniel Harris. | Bruce Momjian | 1997-07-28 |
| | | |||
| * | PrintBufferUsage() changed to report about shared, local and direct | Vadim B. Mikheev | 1997-04-18 |
| | | | | | blocks transfferes. | ||
| * | From: Dan McGuirk <mcguirk@indirect.com> | Marc G. Fournier | 1997-03-28 |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Reply-To: hackers@hub.org, Dan McGuirk <mcguirk@indirect.com> To: hackers@hub.org Subject: [HACKERS] tmin writeback optimization I was doing some profiling of the backend, and noticed that during a certain benchmark I was running somewhere between 30% and 75% of the backend's CPU time was being spent in calls to TransactionIdDidCommit() from HeapTupleSatisfiesNow() or HeapTupleSatisfiesItself() to determine that changed rows' transactions had in fact been committed even though the rows' tmin values had not yet been set. When a query looks at a given row, it needs to figure out whether the transaction that changed the row has been committed and hence it should pay attention to the row, or whether on the other hand the transaction is still in progress or has been aborted and hence the row should be ignored. If a tmin value is set, it is known definitively that the row's transaction has been committed. However, if tmin is not set, the transaction referred to in xmin must be looked up in pg_log, and this is what the backend was spending a lot of time doing during my benchmark. So, implementing a method suggested by Vadim, I created the following patch that, the first time a query finds a committed row whose tmin value is not set, sets it, and marks the buffer where the row is stored as dirty. (It works for tmax, too.) This doesn't result in the boost in real time performance I was hoping for, however it does decrease backend CPU usage by up to two-thirds in certain situations, so it could be rather beneficial in high-concurrency settings. | ||
| * | Fix typo in struct name. | Bruce Momjian | 1997-01-26 |
| | | |||
| * | More autosize structure error checks. | Bruce Momjian | 1997-01-25 |
| | | |||
| * | Remove SB_PAD. Compute padding at compile time. | Bruce Momjian | 1997-01-23 |
| | | |||
| * | No more LateWrite. | Vadim B. Mikheev | 1997-01-16 |
| | | |||
| * | Compile and warning cleanup | Bruce Momjian | 1996-11-08 |
| | | |||
| * | Clean up Makefile | Marc G. Fournier | 1996-11-03 |
| | | | | | | | Add #include "postgres.h" as required Remove #include "utils/elog.h" | ||
| * | Postgres95 1.01 Distribution - Virgin SourcesPG95-1_01 | Marc G. Fournier | 1996-07-09 |
 |
index : postgresql | |
| postgresql mirror |
| aboutsummaryrefslogtreecommitdiff |