|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.440 2006/09/19 02:08:30 momjian Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.441 2006/09/19 02:25:13 momjian Exp $ --> |
2 | 2 | <!-- |
3 | 3 |
|
4 | 4 | Typical markup: |
@@ -340,117 +340,117 @@ For new features, add links to the documentation sections. |
340 | 340 |
|
341 | 341 | <listitem> |
342 | 342 | <para> |
343 | | -Reduce locking requirements of sequential scans (Qingqing |
344 | | -Zhou) |
| 343 | +Increase default values for <envar>shared_buffers</> and |
| 344 | +<envar>max_fsm_pages</>(Andrew) |
345 | 345 | </para> |
346 | 346 | </listitem> |
347 | 347 |
|
348 | 348 | <listitem> |
349 | 349 | <para> |
350 | | - Improve subtransaction performance (Alvaro, Itagaki Takahiro, |
351 | | - Tom) |
| 350 | + Improve sorting speed and reduce memory usage (Simon, Tom) |
352 | 351 | </para> |
353 | 352 | </listitem> |
354 | 353 |
|
355 | 354 | <listitem> |
356 | 355 | <para> |
357 | | - Improvelocking performanceby breaking locks into sections |
358 | | -(Tom) |
| 356 | + Improvesubtransaction performance(Alvaro, Itagaki Takahiro, |
| 357 | + Tom) |
359 | 358 | </para> |
| 359 | + </listitem> |
360 | 360 |
|
| 361 | + <listitem> |
361 | 362 | <para> |
362 | | - This allows locking to be more fine-grained, reducing |
363 | | - contention. |
| 363 | + Improve <command>COPY</> performance (Alon Goldshuv, Tom) |
364 | 364 | </para> |
365 | 365 | </listitem> |
366 | 366 |
|
367 | 367 | <listitem> |
368 | 368 | <para> |
369 | | -Allow the planner to re-order<literal>OUTER JOIN</>s when |
370 | | -possible (Tom) |
| 369 | +Add<literal>FILLFACTOR</> to table and index creation |
| 370 | +(ITAGAKI Takahiro) |
371 | 371 | </para> |
372 | 372 |
|
373 | 373 | <para> |
374 | | - This makes a considerable difference for queries involving |
375 | | - multiple outer joins. |
| 374 | + This adds extra free space to each heap or index page, |
| 375 | + allowing improved performance as the database grows. This |
| 376 | + is particularly valuable to maintain <command>CLUSTER</>ing. |
376 | 377 | </para> |
377 | 378 | </listitem> |
378 | 379 |
|
379 | 380 | <listitem> |
380 | 381 | <para> |
381 | | - Improve planning of joins to inherited tables and <literal>UNION |
382 | | - ALL</> views (Tom) |
| 382 | + Improve locking performance by breaking locks into sections |
| 383 | + (Tom) |
| 384 | + </para> |
| 385 | + |
| 386 | + <para> |
| 387 | + This allows locking to be more fine-grained, reducing |
| 388 | + contention. |
383 | 389 | </para> |
384 | 390 | </listitem> |
385 | 391 |
|
386 | 392 | <listitem> |
387 | 393 | <para> |
388 | | -Increase default values for <envar>shared_buffers</> and |
389 | | -<envar>max_fsm_pages</>(Andrew) |
| 394 | +Reduce locking requirements of sequential scans (Qingqing |
| 395 | +Zhou) |
390 | 396 | </para> |
391 | 397 | </listitem> |
392 | 398 |
|
393 | 399 | <listitem> |
394 | 400 | <para> |
395 | | -Improve the optimizer statistics used by <literal>LIKE</>, |
396 | | -<literal>ILIKE</>, and regular expression operations(Tom) |
| 401 | +Reduce locking required for database creation and destruction |
| 402 | + (Tom) |
397 | 403 | </para> |
398 | 404 | </listitem> |
399 | 405 |
|
400 | 406 | <listitem> |
401 | 407 | <para> |
402 | | - Allowconstraint exclusion tobe applied to inherited |
403 | | -<command>UPDATE</>/<command>DELETE</> queries (Tom) |
| 408 | + Allowthe planner tore-order <literal>OUTER JOIN</>s when |
| 409 | +possible (Tom) |
404 | 410 | </para> |
405 | 411 |
|
406 | 412 | <para> |
407 | | - <command>SELECT</> already honored constraint exclusion. |
| 413 | + This makes a considerable difference for queries involving |
| 414 | + multiple outer joins. |
408 | 415 | </para> |
409 | 416 | </listitem> |
410 | 417 |
|
411 | 418 | <listitem> |
412 | 419 | <para> |
413 | | - Improve sorting speed and reduce memory usage (Simon, Tom) |
| 420 | + Improve the optimizer statistics used by <literal>LIKE</>, |
| 421 | + <literal>ILIKE</>, and regular expression operations (Tom) |
414 | 422 | </para> |
415 | 423 | </listitem> |
416 | 424 |
|
417 | 425 | <listitem> |
418 | 426 | <para> |
419 | | -<function>MIN()</>/<function>MAX()</> can now use indexes |
420 | | -in more cases (Tom) |
| 427 | +Improve planning of joins to inherited tables and <literal>UNION |
| 428 | +ALL</> views (Tom) |
421 | 429 | </para> |
422 | 430 | </listitem> |
423 | 431 |
|
424 | 432 | <listitem> |
425 | 433 | <para> |
426 | | -Improve concurrency for database creation and destruction |
427 | | - (Tom) |
| 434 | +Allow constraint exclusion to be applied to inherited |
| 435 | +<command>UPDATE</>/<command>DELETE</> queries(Tom) |
428 | 436 | </para> |
429 | | - </listitem> |
430 | 437 |
|
431 | | - <listitem> |
432 | 438 | <para> |
433 | | - Speed up vacuuming of btree indexes (Heikki Linnakangas, |
434 | | - Tom) |
| 439 | + <command>SELECT</> already honored constraint exclusion. |
435 | 440 | </para> |
436 | 441 | </listitem> |
437 | 442 |
|
438 | 443 | <listitem> |
439 | 444 | <para> |
440 | | - Improve <command>COPY</> performance (Alon Goldshuv, Tom) |
| 445 | + <function>MIN()</>/<function>MAX()</> can now use indexes |
| 446 | + in more cases (Tom) |
441 | 447 | </para> |
442 | 448 | </listitem> |
443 | 449 |
|
444 | 450 | <listitem> |
445 | 451 | <para> |
446 | | - Add <literal>FILLFACTOR</> to table and index creation |
447 | | - (ITAGAKI Takahiro) |
448 | | - </para> |
449 | | - |
450 | | - <para> |
451 | | - This adds extra free space to each heap or index page, |
452 | | - allowing improved performance as the database grows. This |
453 | | - is particularly valuable to maintain <command>CLUSTER</>ing. |
| 452 | + Speed up vacuuming of btree indexes (Heikki Linnakangas, |
| 453 | + Tom) |
454 | 454 | </para> |
455 | 455 | </listitem> |
456 | 456 |
|
|