Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vn7kZ-0003kn-AI for pgsql-performance@arkaria.postgresql.org; Sun, 01 Dec 2013 14:11:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vn7kY-0007wl-9Z for pgsql-performance@arkaria.postgresql.org; Sun, 01 Dec 2013 14:11:54 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vn7kW-0007wc-4R for pgsql-performance@postgresql.org; Sun, 01 Dec 2013 14:11:52 +0000 Received: from mail-pd0-x22c.google.com ([2607:f8b0:400e:c02::22c]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vn7kT-0002Rh-0i for pgsql-performance@postgresql.org; Sun, 01 Dec 2013 14:11:51 +0000 Received: by mail-pd0-f172.google.com with SMTP id g10so16400565pdj.31 for ; Sun, 01 Dec 2013 06:11:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date :content-transfer-encoding:message-id:references:to; bh=+naGQrCROpct+tdHv3MAjn12UM9HhHA+D17Mk70qFvg=; b=JWjn88qKXW8xxJyFqqlJ2dyqPrQ19Z5t8OIJWCmdOZyhTLgOOztXNM61euwGy4K+cF IBrRkgQVA9pTuQzGZHXFIYmWjeZkcyQ91gE69242S2FMmZueiKN0NFjCaw4hHeqaam28 1touvmJXJza+JDNpYzNoj7WQMv712pkDCxxUredyESBnhavDUNMDL9ed3mrf9GlMUPSv d27mvVcIilXeTUstJtTL+e99Qgd+ZfTsmlThu8gQKRvxEjCEMkzsU8uQxmcrBk1O9jKk YiWRIgVivgeqHrtuRyCWPg7VJgkSQIXVzg1OFT6TZKl8WqmRMa+RrIS4KUA2SEfqjnQC Tp4w== X-Received: by 10.68.252.161 with SMTP id zt1mr26090780pbc.130.1385907107310; Sun, 01 Dec 2013 06:11:47 -0800 (PST) Received: from [192.168.1.111] ([110.138.251.110]) by mx.google.com with ESMTPSA id sy10sm131201835pac.15.2013.12.01.06.11.44 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Sun, 01 Dec 2013 06:11:46 -0800 (PST) Content-Type: text/plain; charset=iso-8859-1 Mime-Version: 1.0 (Apple Message framework v1084) Subject: Re: Speed up the query From: Hengky Liwandouw In-Reply-To: <20131201122947.GA26336@tux> Date: Sun, 1 Dec 2013 22:11:40 +0800 Content-Transfer-Encoding: quoted-printable Message-Id: <5765BFAB-4AF4-44AF-99BB-ECC0E04DC91B@gmail.com> References: <20131201071231.GA4780@tux> <335A179F-B1A5-4634-998F-BA30ACD84209@gmail.com> <20131201083541.GA10012@tux> <980E5A18-104B-46C8-AB98-A66A391C8272@gmail.com> <529B265B.5030206@gmx.net> <8A61AB71-AE85-40A6-B9EF-316D39DEABD8@gmail.com> <20131201122947.GA26336@tux> To: pgsql-performance@postgresql.org X-Mailer: Apple Mail (2.1084) X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org Thanks a lot Andreas :) The tbltransaksi size =3D 263MB Total database size =3D 1277MB Quite small for so many records store in it. This group really helpfull.=20 On Dec 1, 2013, at 8:29 PM, Andreas Kretschmer wrote: > Hengky Liwandouw wrote: >=20 >>=20 >> For Mat : what command i can use to show how big the tables in MB ? >=20 > http://andreas.scherbaum.la/blog/archives/282-table-size,-database-size.h= tml >=20 >=20 > Andreas > --=20 > Really, I'm not out to destroy Microsoft. That will just be a completely > unintentional side effect. (Linus Torvalds) > "If I was god, I would recompile penguin with --enable-fly." (unknown) > Kaufbach, Saxony, Germany, Europe. N 51.05082=B0, E 13.56889= =B0 >=20 >=20 > --=20 > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance