Unix Technical Forum

Re: Altering WAL Segment File Size

This is a discussion on Re: Altering WAL Segment File Size within the pgsql Admins forums, part of the PostgreSQL category; --> 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 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Admins

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 05:19 AM
Sivakumar K
 
Posts: n/a
Default Re: Altering WAL Segment File Size

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
[mailtogsql-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.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-10-2008, 05:20 AM
Jim C. Nasby
 
Posts: n/a
Default Re: Altering WAL Segment File Size

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
> [mailtogsql-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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:32 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com