Sophie: postgresql8.3-docs-8.3.6-2mdv2008.1 x86

postgresql8.3-docs-8.3.6-2mdv2008.1.x86_64.rpm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Performance Tips</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 8.3.6 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="The SQL Language"
HREF="sql.html"><LINK
REL="PREVIOUS"
TITLE="Locking and Indexes"
HREF="locking-indexes.html"><LINK
REL="NEXT"
TITLE="Using EXPLAIN"
HREF="using-explain.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2009-02-03T04:34:16"></HEAD
><BODY
CLASS="CHAPTER"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
>PostgreSQL 8.3.6 Documentation</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="locking-indexes.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="mvcc.html"
>Fast Backward</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
HREF="admin.html"
>Fast Forward</A
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
HREF="using-explain.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="CHAPTER"
><H1
><A
NAME="PERFORMANCE-TIPS"
></A
>Chapter 14. Performance Tips</H1
><DIV
CLASS="TOC"
><DL
><DT
><B
>Table of Contents</B
></DT
><DT
>14.1. <A
HREF="using-explain.html"
>Using <TT
CLASS="COMMAND"
>EXPLAIN</TT
></A
></DT
><DT
>14.2. <A
HREF="planner-stats.html"
>Statistics Used by the Planner</A
></DT
><DT
>14.3. <A
HREF="explicit-joins.html"
>Controlling the Planner with Explicit <TT
CLASS="LITERAL"
>JOIN</TT
> Clauses</A
></DT
><DT
>14.4. <A
HREF="populate.html"
>Populating a Database</A
></DT
><DD
><DL
><DT
>14.4.1. <A
HREF="populate.html#DISABLE-AUTOCOMMIT"
>Disable Autocommit</A
></DT
><DT
>14.4.2. <A
HREF="populate.html#POPULATE-COPY-FROM"
>Use <TT
CLASS="COMMAND"
>COPY</TT
></A
></DT
><DT
>14.4.3. <A
HREF="populate.html#POPULATE-RM-INDEXES"
>Remove Indexes</A
></DT
><DT
>14.4.4. <A
HREF="populate.html#POPULATE-RM-FKEYS"
>Remove Foreign Key Constraints</A
></DT
><DT
>14.4.5. <A
HREF="populate.html#POPULATE-WORK-MEM"
>Increase <TT
CLASS="VARNAME"
>maintenance_work_mem</TT
></A
></DT
><DT
>14.4.6. <A
HREF="populate.html#POPULATE-CHECKPOINT-SEGMENTS"
>Increase <TT
CLASS="VARNAME"
>checkpoint_segments</TT
></A
></DT
><DT
>14.4.7. <A
HREF="populate.html#POPULATE-PITR"
>Turn off <TT
CLASS="VARNAME"
>archive_mode</TT
></A
></DT
><DT
>14.4.8. <A
HREF="populate.html#POPULATE-ANALYZE"
>Run <TT
CLASS="COMMAND"
>ANALYZE</TT
> Afterwards</A
></DT
><DT
>14.4.9. <A
HREF="populate.html#POPULATE-PG-DUMP"
>Some Notes About <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
></A
></DT
></DL
></DD
></DL
></DIV
><A
NAME="AEN20000"
></A
><P
>   Query performance can be affected by many things. Some of these can
   be manipulated by the user, while others are fundamental to the underlying
   design of the system.  This chapter provides some hints about understanding
   and tuning <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> performance.
  </P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="locking-indexes.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="using-explain.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Locking and Indexes</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="sql.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Using <TT
CLASS="COMMAND"
>EXPLAIN</TT
></TD
></TR
></TABLE
></DIV
></BODY
></HTML
>