Обсуждение: Altering WAL Segment File Size

Поиск
Список
Период
Сортировка

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.

Re: Altering WAL Segment File Size

От
"Sivakumar K"
Дата:

            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.

Re: Altering WAL Segment File Size

От
Gaetano Mendola
Дата:
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


Re: Altering WAL Segment File Size

От
"Jim C. Nasby"
Дата:
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