pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Altering WAL Segment File Size
5+ messages / 4 participants
[nested] [flat]

* Altering WAL Segment File Size
@ 2005-10-04 09:56  dhanesh.prabha@wipro.com
  0 siblings, 0 replies; 5+ messages in thread

From: dhanesh.prabha@wipro.com @ 2005-10-04 09:56 UTC (permalink / raw)
  To: pgsql-admin


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.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Altering WAL Segment File Size
@ 2005-10-04 10:31  dhanesh.prabha@wipro.com
  0 siblings, 1 reply; 5+ messages in thread

From: dhanesh.prabha@wipro.com @ 2005-10-04 10:31 UTC (permalink / raw)
  To: pgsql-admin












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.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Altering WAL Segment File Size
@ 2005-10-04 14:13  Sivakumar K <sivakumark@pervasive-postgres.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Sivakumar K @ 2005-10-04 14:13 UTC (permalink / raw)
  To: dhanesh.prabha@wipro.com; pgsql-admin

            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.
	

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Altering WAL Segment File Size
@ 2005-10-04 16:14  Gaetano Mendola <mendola@bigfoot.com>
  parent: dhanesh.prabha@wipro.com
  0 siblings, 0 replies; 5+ messages in thread

From: Gaetano Mendola @ 2005-10-04 16:14 UTC (permalink / raw)
  To: dhanesh.prabha@wipro.com

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




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Altering WAL Segment File Size
@ 2005-10-04 16:26  Jim C. Nasby <jnasby@pervasive.com>
  parent: Sivakumar K <sivakumark@pervasive-postgres.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Jim C. Nasby @ 2005-10-04 16:26 UTC (permalink / raw)
  To: Sivakumar K <sivakumark@pervasive-postgres.com>; +Cc: dhanesh.prabha@wipro.com; pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2005-10-04 16:26 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-04 09:56 Altering WAL Segment File Size dhanesh.prabha@wipro.com
2005-10-04 10:31 Altering WAL Segment File Size dhanesh.prabha@wipro.com
2005-10-04 16:14 ` Gaetano Mendola <mendola@bigfoot.com>
2005-10-04 14:13 Re: Altering WAL Segment File Size Sivakumar K <sivakumark@pervasive-postgres.com>
2005-10-04 16:26 ` Jim C. Nasby <jnasby@pervasive.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox