Обсуждение: Altering WAL Segment File Size
Dear Sir,
How can I altered the WAL segment file size when building the server. The default size was 16 MB.
I want only 1 MB size…
Waiting for your kind reply
Regards
Dhanesh
Dhanesh Prabha P.V
WIPRO Technologies,
Sarjapur Road,
Bangalore.
Phone : +91-80-25056768 (Direct)
Voice Net : 805-4736
mailto:dhanesh.prabha@wipro.com
Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or Mailadmin@wipro.com immediately and destroy all copies of this message and any attachments. |
I believe the parameter which needs to be changed is XLOG_SEG_SIZE inside src/include/pg_config_manual.h.
Also go through the comments embedded in the file.
Please feel free to correct me.
Regards,
Siva Kumar.K
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of dhanesh.prabha@wipro.com
Sent: Tuesday, October 04, 2005 4:01 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Altering WAL Segment File Size
Dear Sir,
How can I altered the WAL segment file size when building the server. The default size was 16 MB.
I want only 1 MB size...
Waiting for your kind reply
Regards
Dhanesh
Dhanesh Prabha P.V
WIPRO Technologies,
Sarjapur Road,
Bangalore.
Phone : +91-80-25056768 (Direct)
Voice Net : 805-4736
mailto:dhanesh.prabha@wipro.com
Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or Mailadmin@wipro.com immediately and destroy all copies of this message and any attachments. |
dhanesh.prabha@wipro.com wrote: > > > Dear Sir, > How can I altered the WAL segment file size when building > the server. The default size was 16 MB. > > I want only 1 MB size… > What are you trying to achieve? May be you are looking in the wrong direction. Regards Gaetano Mendola
Out of curiosity, why do you feel the need to change this? On Tue, Oct 04, 2005 at 07:43:02PM +0530, Sivakumar K wrote: > I believe the parameter which needs to be changed is > XLOG_SEG_SIZE inside src/include/pg_config_manual.h. > > Also go through the comments embedded in the file. > > > > Please feel free to correct me. > > > > > > Regards, > > Siva Kumar.K > > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of > dhanesh.prabha@wipro.com > Sent: Tuesday, October 04, 2005 4:01 PM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Altering WAL Segment File Size > > > > > > > > > > > > > > Dear Sir, > > > > > > How can I altered the WAL segment file size when building > the server. The default size was 16 MB. > > I want only 1 MB size... > > > > Waiting for your kind reply > > > > Regards > > Dhanesh > > > > > > Dhanesh Prabha P.V > > WIPRO Technologies, > > Sarjapur Road, > > Bangalore. > > Phone : +91-80-25056768 (Direct) > > Voice Net : 805-4736 > > mailto:dhanesh.prabha@wipro.com > > > > > > Confidentiality Notice > > The information contained in this electronic message and any attachments > to this message are intended > for the exclusive use of the addressee(s) and may contain confidential > or privileged information. If > you are not the intended recipient, please notify the sender at Wipro or > Mailadmin@wipro.com immediately > and destroy all copies of this message and any attachments. > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461