X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id A72DAD1C4E3 for ; Mon, 21 Jul 2003 13:45:44 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 02637-03 for ; Mon, 21 Jul 2003 13:45:33 +0000 (GMT) Received: from pos_pdc.posportal.com (unknown [12.158.169.100]) by svr1.postgresql.org (Postfix) with ESMTP id 3722FD1C4F1 for ; Mon, 21 Jul 2003 10:45:33 -0300 (ADT) X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Subject: Re: Tuning PostgreSQL Date: Mon, 21 Jul 2003 06:45:32 -0700 Message-ID: <9B1C77393DED0D4B9DAA1AA1742942DA3BCCB1@pos_pdc.posportal.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] Tuning PostgreSQL Thread-Index: AcNPh0qASfeb+tsNSVKzYBPz8kcOFwABbenK From: "Roman Fail" To: "Alexander Priem" , , X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/333 X-Sequence-Number: 2626 PiBXaGF0IHdvdWxkIHlvdSBndXlzIHRoaW5rIG9mIG5vdCB1c2luZyBSQUlE NSBpbiB0aGF0IGNhc2UsIGJ1dCBqdXN0IGEgcmVhbGx5DQo+IGZhc3QgMTUu MDAwIHJwbSBTQ1NJLTMyMCBkaXNrPw0KDQogDQpJJ2Qgc2F5IHlvdSBtdXN0 IGJlIGFibGUgdG8gdG9sZXJhdGUgbG9zaW5nIGFsbCB0aGUgZGF0YSBzaW5j ZSB5b3VyIGxhc3QgZGF0YWJhc2UgYmFja3VwLiAgWW91ciBiYXR0ZXJ5IGJh Y2tlZCBjYWNoZSwgcm90YXRpb25hbCBzcGVlZCwgYW5kIHRyYW5zZmVyIHJh dGUgYXJlbid0IGdvaW5nIHRvIGhlbHAgYXQgYWxsIHdoZW4gdGhlIGRyaXZl IGl0c2VsZiBkZWdyYWRlcyBhbmQgY29ycnVwdHMgZGF0YS4gIElmIHlvdSBj YW4gcmVhbGx5IG9ubHkgYWZmb3JkIDMgZHJpdmVzLCBJJ2QgaGF2ZSBhIHNp bmdsZSBkcml2ZSB3aXRoIHRoZSBPUyAmIFdBTCBvbiBpdCwgYW5kIHRoZSBk YXRhIG9uIGEgUkFJRC0xIG1pcnJvciBzZXQgdXNpbmcgdGhlIG90aGVyIDIg ZHJpdmVzLiAgSWYgeW91IG5lZWQgbW9yZSBzcGFjZSBmb3IgZGF0YSwgb3Ig d2FudCB5b3VyIE9TIGRyaXZlcyB0byBiZSBtaXJyb3JlZCAtIGl0J3MgZ29p bmcgdG8gY29zdCBtb3JlLiAgU2VlIGlmIHlvdSBjYW4gZ2V0IDJ4MThHQiBk cml2ZXMgZm9yIHRoZSBPUyBhbmQgMng3M0dCIGRyaXZlcyBmb3IgdGhlIGRh dGEuICAgIA0KIA0KWW91IGhhdmUgdG8gY29uc2lkZXIgaG93IG11Y2ggaGVh ZGFjaGUgdGhhdCBzbWFsbCBhbW91bnQgb2YgYWRkaXRpb25hbCBtb25leSBp cyBnb2luZyB0byBzYXZlIHlvdSAoYW5kIHlvdXIgdXNlcnMpIGRvd24gdGhl IHJvYWQuDQogDQpSb21hbg0KDQoJLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0t LS0gDQoJRnJvbTogQWxleGFuZGVyIFByaWVtIFttYWlsdG86YXBAY2ljdC5u bF0gDQoJU2VudDogTW9uIDcvMjEvMjAwMyA1OjQzIEFNIA0KCVRvOiBzaHJp ZGhhcl9kYWl0aGFua2FyQHBlcnNpc3RlbnQuY28uaW47IHBnc3FsLXBlcmZv cm1hbmNlQHBvc3RncmVzcWwub3JnIA0KCUNjOiANCglTdWJqZWN0OiBSZTog W1BFUkZPUk1dIFR1bmluZyBQb3N0Z3JlU1FMDQoJDQoJDQoNCglUaGFua3Ms IGknbGwgbG9vayBmdXJ0aGVyIGludG8gdGhlc2UgbW91bnQgc2V0dGluZy4N CgkNCglJIHdhcyBqdXN0IHRoaW5raW5nLCB0aGUgc2VydmVyIHdpbGwgaGF2 ZSBhIChSQUlEKSBjb250cm9sbGVyIGNvbnRhaW5pbmcNCgkxMjhNYiBvZiBi YXR0ZXJ5LWJhY2tlZCBjYWNoZSBtZW1vcnkuIFRoaXMgd291bGQgcmVhbGx5 IHNwZWVkIHVwIGluc2VydHMgdG8NCgl0aGUgZGlzayBhbmQgd291bGQgcHJl dmVudCBkYXRhIGxvc3MgaW4gY2FzZSBvZiBhIHBvd2VyLWRvd24gYWxzby4N CgkNCglXaGF0IHdvdWxkIHlvdSBndXlzIHRoaW5rIG9mIG5vdCB1c2luZyBS QUlENSBpbiB0aGF0IGNhc2UsIGJ1dCBqdXN0IGEgcmVhbGx5DQoJZmFzdCAx NS4wMDAgcnBtIFNDU0ktMzIwIGRpc2s/DQoJDQoJS2luZCByZWdhcmRzLA0K CUFsZXhhbmRlci4NCgkNCgkNCgktLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0t LS0tDQoJRnJvbTogIlNocmlkaGFyIERhaXRoYW5rYXIiIDxzaHJpZGhhcl9k YWl0aGFua2FyQHBlcnNpc3RlbnQuY28uaW4+DQoJVG86IDxwZ3NxbC1wZXJm b3JtYW5jZUBwb3N0Z3Jlc3FsLm9yZz4NCglTZW50OiBNb25kYXksIEp1bHkg MjEsIDIwMDMgMjowNSBQTQ0KCVN1YmplY3Q6IFJlOiBbUEVSRk9STV0gVHVu aW5nIFBvc3RncmVTUUwNCgkNCgkNCgk+IE9uIDIxIEp1bCAyMDAzIGF0IDEz OjQ1LCBBbGV4YW5kZXIgUHJpZW0gd3JvdGU6DQoJPg0KCT4gPiBTbyB3aGVy ZSBjYW4gSSBzZXQgdGhlIG5vYXRpbWUgJiBkYXRhPXdyaXRlYmFjayB2YXJp YWJsZXM/IFRoZXkgYXJlIG5vdA0KCT4gPiBQb3N0Z3JlU1FMIHNldHRpbmdz LCBidXQgcmF0aGVyIExpbnV4IHNldHRpbmdzLCByaWdodD8gV2hlcmUgY2Fu IEkgZmluZA0KCT4gPiB0aGVzZT8NCgk+DQoJPiBUaGVzZSBhcmUgdHlwaWNh bHkgc2V0IGluIC9ldGMvZnN0YWIuY29uZi4gVGhlc2UgYXJlIG1vdW50IHNl dHRpbmdzLiBtYW4NCgltb3VudA0KCT4gZm9yIG1vcmUgZGV0YWlscy4NCgk+ DQoJPiBUaGUgc2Vjb25kIHNldHRpbmcgZGF0YT13cml0ZWJhY2sgaXMgZXh0 MyBzcGVjaWZpYywgSUlSQy4NCgk+DQoJPiBIVEgNCgk+DQoJPiBCeWUNCgk+ ICBTaHJpZGhhcg0KCT4NCgk+IC0tDQoJPiBIaXN0b3J5IHRlbmRzIHRvIGV4 YWdnZXJhdGUuIC0tIENvbC4gR3JlZW4sICJUaGUgU2F2YWdlIEN1cnRhaW4i LCBzdGFyZGF0ZQ0KCT4gNTkwNi40DQoJPg0KCT4NCgk+IC0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLShlbmQgb2YgYnJvYWRjYXN0KS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLQ0KCT4gVElQIDE6IHN1YnNjcmliZSBhbmQgdW5z dWJzY3JpYmUgY29tbWFuZHMgZ28gdG8gbWFqb3Jkb21vQHBvc3RncmVzcWwu b3JnDQoJDQoJDQoJLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKGVuZCBv ZiBicm9hZGNhc3QpLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoJVElQ IDQ6IERvbid0ICdraWxsIC05JyB0aGUgcG9zdG1hc3Rlcg0KCQ0KDQo=