database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
ㆍPostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
PostgreSQL News 6474 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 6474
PostgreSQL 8.1.1 Released
작성자
김상기(ioseph)
작성일
2005-12-14 12:10ⓒ
2005-12-14 12:11ⓜ
조회수
4,155

Release 8.1.1

Release date: 2005-12-12

This release contains a variety of fixes from 8.1.0.

E.1.1. Migration to version 8.1.1

A dump/restore is not required for those running 8.1.X.

E.1.2. Changes

 

  • Fix incorrect optimizations of outer-join conditions (Tom)

  • Fix problems with wrong reported column names in cases involving sub-selects flattened by the optimizer (Tom)

  • Fix update failures in scenarios involving CHECK constraints, toasted columns, and indexes (Tom)

  • Fix bgwriter problems after recovering from errors (Tom)

    The background writer was found to leak buffer pins after write errors. While not fatal in itself, this might lead to mysterious blockages of later VACUUM commands.

  • Prevent failure if client sends Bind protocol message when current transaction is already aborted

  • /contrib/tsearch2 and /contrib/ltree fixes (Teodor)

  • Fix problems with translated error messages in languages that require word reordering, such as Turkish; also problems with unexpected truncation of output strings and wrong display of the smallest possible bigint value (Andrew, Tom)

    These problems only appeared on platforms that were using our port/snprintf.c code, which includes BSD variants if --enable-nls was given, and perhaps others. In addition, a different form of the translated-error-message problem could appear on Windows depending on which version of libintl was used.

  • Re-allow AM/PM, HH, HH12, and D format specifiers for to_char(time) and to_char(interval). (to_char(interval) should probably use HH24.) (Bruce)

  • AIX, HPUX, and MSVC compile fixes (Tom, Hiroshi Saito)

  • Optimizer improvements (Tom)

  • Retry file reads and writes after Windows NO_SYSTEM_RESOURCES error (Qingqing Zhou)

  • Prevent autovacuum from crashing during ANALYZE of expression index (Alvaro)

  • Fix problems with ON COMMIT DELETE ROWS temp tables

  • Fix problems when a trigger alters the output of a SELECT DISTINCT query

  • Add 8.1.0 release note item on how to migrate invalid UTF-8 byte sequences (Paul Lindner)

이 글에 대한 댓글이 총 1건 있습니다.

복잡한 자료구조를 가지고 있는 DB에서 발생했던 몇가지 버그들이 수정되어 릴리즈 되었습니다.

 

당연히 성급히 8.1 로 옮겨가신 분은 없을 터이고,

개인적인 생각으로는 8.1.3 정도 되어야 아주 복잡한 자료구조에서도 별 문제가 없을 것같네요.

 

이곳은 8.1.2 나오면 옮겨갈 예정입니다.

 

뭐, 자료구조가 단순하다면, 8.1 로 옮겨가는 것도 괜찮을 것같습니다.

8.0에서 8.1로 바뀐 것이 새로운 기능보다, 대부분 성능 향상 쪽에 치중되었거든요.

 

김상기(ioseph)님이 2005-12-14 12:15에 작성한 댓글입니다.
[Top]
No.
제목
작성자
작성일
조회
6486Access2PostgreSQL Sync v.1.0 release
신기배
2005-12-20
3431
6483Make Your New Year's Resolution to Learn PostgreSQL 8.1 at the Big Nerd Ranch
신기배
2005-12-19
3243
6478pgAdmin v1.4.1 Released
신기배
2005-12-15
3830
6474PostgreSQL 8.1.1 Released [1]
김상기
2005-12-14
4155
6473Persasive Software contributing code to PostgreSQL Community for Sun Solaris 10 Dtrace Framework
신기배
2005-12-12
3392
6472Java Based TPC-C like tests highlight PG 8.1 Performance
신기배
2005-12-11
3447
6471AM Lightning Messenger ported from Firebird to Postgresql
신기배
2005-12-11
3403
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2020 DSN, All rights reserved.
작업시간: 0.044초, 이곳 서비스는
	PostgreSQL v13.0으로 자료를 관리합니다