pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAltering 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