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 Files 3776 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 3776
PostgreSQL Hardware Performance Tuning
작성자
정재익(advance)
작성일
2001-12-25 20:23
조회수
4,657
첨부파일: hw_performance.pdf (73,620bytes)

POSTGRESQL is an object-relational database developed on the Internet by a group of developers spread across the globe. It is an open-source alternative to commercial databases like Oracle and Informix.

POSTGRESQL was originally developed at the University of California at Berkeley. In 1996, a group began development of the database on the Internet. They use email to share ideas and file servers to share code. POSTGRESQL is now comparable to commercial databases in terms of features, performance, and reliability. It has transactions, views, stored procedures, and referential integrity constraints. It supports a large number of programming interfaces, including ODBC, Java (JDBC), TCL/TK, PHP, Perl, and Python. POSTGRESQL continues to improve at a tremendous pace thanks to a talented pool of Internet developers.

 

 

 

 

Performance Concepts

Keeping Information Near the CPU

POSTGRESQL Shared Buffer Cache

How Big Is Too Big?

Effects of Cache Size

Proper Sizing of Shared Buffer Cache

Sort Memory Batch Size

Cache Size and Sort Size

Disk Locality

Multiple Disk Spindles

Conclusion

 

 

Bruce Momjian

2001-12-17

[Top]
No.
제목
작성자
작성일
조회
3784PostgreSQL Session Handler for PHP v1.7
정재익
2001-12-25
4390
3779PostgreSQL AutoDoc v0.31
정재익
2001-12-25
4395
3777PostgreSQL : Introduction and Concepts
정재익
2001-12-25
4181
3776PostgreSQL Hardware Performance Tuning
정재익
2001-12-25
4657
3774AuthPG v1.3
정재익
2001-12-25
4100
3740MySQL PHP code 를 PostgreSQL 로 바꾸어 주는 프로그램
정재익
2001-12-15
4571
3736mod_auth_pgsql
정재익
2001-12-15
4383
3737┕>Re: mod_auth_pgsql php3-pgsql-3.0.12
정재익
2001-12-15 11:29:56
4341
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.018초, 이곳 서비스는
	PostgreSQL v16.4로 자료를 관리합니다