Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id C2160B5DC09 for ; Mon, 20 Jun 2011 04:47:56 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 37470-02 for ; Mon, 20 Jun 2011 07:47:50 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id 59ECAB5DC12 for ; Mon, 20 Jun 2011 04:47:50 -0300 (ADT) Received: by iwn6 with SMTP id 6so967407iwn.19 for ; Mon, 20 Jun 2011 00:47:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc:content-type:content-transfer-encoding; bh=NKswfshORy+XynbQkII0aEnF5Eoc1aW6IUN1FbD8SB0=; b=qXed1SYpgtwDrBmAGNpOBMTUemJWaLeTgRpRQViKnR2C2flU7CWQx4eqB/sjNeHHHQ mf1FqkWk9TDosSbe3pFfZOyVPKTPj2cohLp5paqgG/AJlG9lg30ieLDos7bHqIe/N6Ba H8DHLKVcnSXDiJ4Mt1KF6uhXwwOcY9W3I5Dy0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type:content-transfer-encoding; b=vH/E0UuSBzX339a/CNgg/Nt2DMrLw5HwzQSV3ckHxaQuP50uYK+Twilkf+gbBqqNOI ptGOQ6LBKCLbXAPcjaZn6lLzj2RqCLXnwCLhOSOM1VikoW+D6qWCTz7/GX76b73RfHT5 Bj3Ow3Dw0QxW6KPGrD0+XZ4t97rF4XYmcadlA= Received: by 10.42.97.130 with SMTP id o2mr3455984icn.475.1308556068323; Mon, 20 Jun 2011 00:47:48 -0700 (PDT) MIME-Version: 1.0 Received: by 10.42.225.193 with HTTP; Mon, 20 Jun 2011 00:47:08 -0700 (PDT) In-Reply-To: <4DFEF6E9.90404@nsoft.lt> References: <4DFA5AA4.8090001@nsoft.lt> <4DFEEA70.6000009@nsoft.lt> <4DFEF6E9.90404@nsoft.lt> From: Pavel Stehule Date: Mon, 20 Jun 2011 09:47:08 +0200 Message-ID: Subject: Re: generating a large XML document To: Julius Tuskenis Cc: pgsql-performance@postgresql.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201106/173 X-Sequence-Number: 44106 2011/6/20 Julius Tuskenis : > Thank you, Pavel for your answer > > 2011.06.20 09:51, Pavel Stehule ra=C5=A1=C4=97: >> >> can you send a profile? > > Excuse me, but what do you mean by saying "profile"? I've sent content of > pg_settings in the first post. Please be more specific as I am more of a > programmer than an server administrator. > a result from oprofile profiler Regards Pavel > -- > Julius Tuskenis > Programavimo skyriaus vadovas > UAB nSoft > mob. +37068233050 > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org= ) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >