File tree Expand file tree Collapse file tree 3 files changed +24
-5
lines changed Expand file tree Collapse file tree 3 files changed +24
-5
lines changed Original file line number Diff line number Diff line change 1
1
#! /bin/sh
2
2
# -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- #
3
- # Package : reindexdb Version : $Revision: 1.1 $
3
+ # Package : reindexdb Version : $Revision: 1.2 $
4
4
# Date : 05/08/2002 Author : Shaun Thomas
5
5
# Req : psql, sh, perl, sed Type : Utility
6
6
#
10
10
# Function Definitions
11
11
# -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- #
12
12
13
- function usage()
13
+ usage ()
14
14
{
15
15
echo " $CMDNAME reindexes a PostgreSQL database."
16
16
echo
Original file line number Diff line number Diff line change 1
1
<!--
2
- $Header: /cvsroot/pgsql/doc/src/sgml/maintenance.sgml,v 1.14 2002/06/13 05:15:22 momjian Exp $
2
+ $Header: /cvsroot/pgsql/doc/src/sgml/maintenance.sgml,v 1.15 2002/06/22 04:08:07 momjian Exp $
3
3
-->
4
4
5
5
<chapter id="maintenance">
@@ -367,6 +367,25 @@ VACUUM
367
367
</sect1>
368
368
369
369
370
+ <sect1 id="routine-reindex">
371
+ <title>Routine Reindexing</title>
372
+
373
+ <indexterm zone="routine-reindex">
374
+ <primary>reindex</primary>
375
+ </indexterm>
376
+
377
+ <para>
378
+ <productname>PostgreSQL</productname> is unable to reuse index pages
379
+ in some cases. The problem is that if indexed rows are deleted, those
380
+ indexes pages can only be reused by rows with similar values. In
381
+ cases where low indexed rows are deleted and newly inserted rows have
382
+ high values, disk space used by the index will grow indefinately, even
383
+ if <command>VACUUM</> is run frequently.
384
+ TO BE COMPLETED 2002-06-22 bjm
385
+ </para>
386
+ </sect1>
387
+
388
+
370
389
<sect1 id="logfile-maintenance">
371
390
<title>Log File Maintenance</title>
372
391
Original file line number Diff line number Diff line change @@ -66,10 +66,10 @@ typedef struct
66
66
typedef struct
67
67
{
68
68
/* Number of times we've been called before */
69
- uint call_cntr ;
69
+ uint32 call_cntr ;
70
70
71
71
/* Maximum number of calls */
72
- uint max_calls ;
72
+ uint32 max_calls ;
73
73
74
74
/* pointer to result slot */
75
75
TupleTableSlot * slot ;
You can’t perform that action at this time.
0 commit comments