X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CB5225288D for ; Fri, 24 Jun 2005 10:55:33 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50780-06 for ; Fri, 24 Jun 2005 13:55:28 +0000 (GMT) Received: from mta2.corp.terralycos.com (mta2.corp.terralycos.com [209.202.200.16]) by svr1.postgresql.org (Postfix) with ESMTP id CE21F5280C for ; Fri, 24 Jun 2005 10:55:26 -0300 (ADT) Received: from usmail06.ma.lycos.com (usmail06.ma.lycos.com [10.124.1.203]) by mta2.corp.terralycos.com (Switch-3.1.7/Switch-3.1.7) with ESMTP id j5ODnlCW002707 for ; Fri, 24 Jun 2005 06:49:48 -0700 Subject: Re: symlinking pg_xlog To: pgsql-admin@postgresql.org X-Mailer: Lotus Notes Release 5.0.7 March 21, 2001 Message-ID: From: Tim.Shenton@corp.terralycos.com Date: Fri, 24 Jun 2005 09:54:27 -0400 X-MIMETrack: Serialize by Router on USMail06/Lycos(Release 5.0.12 |February 13, 2003) at 06/24/2005 09:54:28 AM MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.028 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_WHOIS, NO_REAL_NAME X-Spam-Level: * X-Archive-Number: 200506/196 X-Sequence-Number: 17951 Last week I was testing PG under different RAID configurations and I mo= ved pg_xlog to other drives and set up the symlink in the data directory (pg_xlog -> /home/test/pg-log). PG worked fine and there were no probl= ems Tim ---------------------- Timothy Shenton Lycos, Inc. (781) 370-2876 |---------+--------------------------------> | | Michael Fuhr | | | | | | Sent by: | | | pgsql-admin-owner@pos| | | tgresql.org | | | | | | | | | 06/24/2005 09:40 AM | | | | |---------+--------------------------------> >--------------------------------------------------------------------= --------------------------------------| | = | | To: K=D6PFERL Robert = | | cc: "[ADMIN]" = | | Subject: Re: [ADMIN] symlinking pg_xlog = | >--------------------------------------------------------------------= --------------------------------------| On Fri, Jun 24, 2005 at 03:18:12PM +0200, K=D6PFERL Robert wrote: > > due to I/O-bottle necks I think of making a symlink from pg_xlog to another > physical disk. > This is a modification inside the cluster dir. What kind of idea is t= hat? > bad one? See the "Write-Ahead Logging (WAL)" chapter in the documentation: http://www.postgresql.org/docs/8.0/static/wal-internals.html "It is of advantage if the log is located on another disk than the main database files. This may be achieved by moving the directory pg_xlog to another location (while the server is shut down, of course) and creating a symbolic link from the original location in the main data directory to the new location." Several third-party performance-tuning documents make the same recommendation. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------= - TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org= ) =