Huge size of Data directory

From: "Anthony Presley" <anthony(at)resolution(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Huge size of Data directory
Date: 2006-01-18 22:02:27
Message-ID: 3575.192.168.5.4.1137621747.squirrel@216.63.139.110
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

Our postgresql database has been churning along just fine, albeit a little
slower than I'd like.

However, more surprising to me is that it has (over the past few years)
become HUGE. It's currently 606MB. Almost all of this space is sitting
in data/base/16556 and data/pg_xlog.

The problem I have with this space ... is that I only have about 8MB of
data stored in the database (according to pg_dump and pg_dumpall).

I'm pasting my postgresql.conf, and the dir listing, to see if you can
help me reduce the size.

tcpip_socket = true

max_connections = 128
port = 5432

shared_buffers = 8192
wal_buffers = 64
vacuum_mem = 32768
wal_files = 16

checkpoint_segments = 3 # in logfile segments (16MB each), min 1
checkpoint_timeout = 300 # in seconds, range 30-3600

syslog = 1 # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'

Dir listing:

1.7M ./base/1
1.7M ./base/16555
4.0k ./base/16556/pgsql_tmp
238M ./base/16556
2.2M ./base/666607
243M ./base
120k ./global
353M ./pg_xlog
9.5M ./pg_clog
606M .

Inside base/16556 is:
1247 16398 16419 16432 16445 16458 16475 16577 76744
1249 16400 16420 16435 16446 16460 16477 16584 76762
1255 16402 16421 16436 16447 16462 16557 16586 76763
1259 16404 16422 16437 16448 16463 16559 16599 76771
16384 16406 16423 16438 16449 16465 16561 16601 pg_internal.init
16386 16408 16424 16439 16452 16466 16562 16614 pgsql_tmp
16388 16410 16425 16440 16453 16468 16563 16616 PG_VERSION
16390 16412 16426 16441 16454 16469 16565 448685
16392 16414 16427 16442 16455 16471 16566 76733
16394 16416 16428 16443 16456 16472 16568 76735
16396 16418 16429 16444 16457 16474 16575 76743

Inside pg_xlog is:
-rw------- 1 postgres postgres 16777216 Jan 18 14:09 0000000600000081
-rw------- 1 postgres postgres 16777216 Jan 16 15:41 0000000600000082
-rw------- 1 postgres postgres 16777216 Jan 16 16:22 0000000600000083
-rw------- 1 postgres postgres 16777216 Jan 16 17:23 0000000600000084
-rw------- 1 postgres postgres 16777216 Jan 16 19:05 0000000600000085
-rw------- 1 postgres postgres 16777216 Jan 16 21:28 0000000600000086
-rw------- 1 postgres postgres 16777216 Jan 17 05:53 0000000600000087
-rw------- 1 postgres postgres 16777216 Jan 17 09:27 0000000600000088
-rw------- 1 postgres postgres 16777216 Jan 17 10:41 0000000600000089
-rw------- 1 postgres postgres 16777216 Jan 17 11:26 000000060000008A
-rw------- 1 postgres postgres 16777216 Jan 17 12:27 000000060000008B
-rw------- 1 postgres postgres 16777216 Jan 17 13:25 000000060000008C
-rw------- 1 postgres postgres 16777216 Jan 17 14:19 000000060000008D
-rw------- 1 postgres postgres 16777216 Jan 17 16:25 000000060000008E
-rw------- 1 postgres postgres 16777216 Jan 17 18:19 000000060000008F
-rw------- 1 postgres postgres 16777216 Jan 17 20:59 0000000600000090
-rw------- 1 postgres postgres 16777216 Jan 17 22:01 0000000600000091
-rw------- 1 postgres postgres 16777216 Jan 17 23:54 0000000600000092
-rw------- 1 postgres postgres 16777216 Jan 18 09:42 0000000600000093
-rw------- 1 postgres postgres 16777216 Jan 18 10:48 0000000600000094
-rw------- 1 postgres postgres 16777216 Jan 18 11:40 0000000600000095
-rw------- 1 postgres postgres 16777216 Jan 18 13:29 0000000600000096

Any ideas?

--Anthony

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Anthony Presley 2006-01-18 23:07:39 Re: Huge size of Data directory
Previous Message Michael Fuhr 2006-01-18 21:57:21 Re: Huge size of Data directory