X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0115D3A40D7 for ; Mon, 25 Oct 2004 06:56:40 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51015-05 for ; Mon, 25 Oct 2004 05:56:37 +0000 (GMT) Received: from trade-india.com (unknown [203.101.29.41]) by svr1.postgresql.org (Postfix) with SMTP id 801333A40BB for ; Mon, 25 Oct 2004 06:56:36 +0100 (BST) Received: (qmail 5479 invoked from network); 25 Oct 2004 05:50:55 -0000 Received: from valium.trade-india-local.com (HELO ?192.168.0.100?) (192.168.0.100) by system66.trade-india-local.com with SMTP; 25 Oct 2004 05:50:55 -0000 Message-ID: <417C95E6.8060300@trade-india.com> Date: Mon, 25 Oct 2004 11:27:58 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla Thunderbird 0.7.3 (X11/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: akanksha kulkarni Cc: pgsql-admin@postgresql.org Subject: Re: data not getting inserted into table References: <20041021135156.67661.qmail@web52907.mail.yahoo.com> In-Reply-To: <20041021135156.67661.qmail@web52907.mail.yahoo.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE, HTML_TAG_BALANCE_TABLE X-Spam-Level: X-Archive-Number: 200410/319 X-Sequence-Number: 15312 Are all the insert operations inside a transaction? ie do you notice a begin ; or begin work; line in the initial part of the .sql file then there shud be a commit; line in the end of the sql file otherwise the transaction will rollback. in case you are inserting from a program you must send commit instruction to the server. in DBI/perl eg its $dbh -> commit() regds mallah. akanksha kulkarni wrote: >Hi, > >I am trying a simple insert command with select >statement (Insert into () select > from
). >The data to be inserted is around 1 GB. >The problem is that at the end of the insert >operation, data is NOT inserted. > >I was monitoring target table file size and it was >getting increased during the operation. However at the >end of insert operation, the size has returned to old >size. >I changed some parameters in postgres configuration >file which are as follows: >checkpoint_segments=20 >sort_mem = 16384 >checkpoint_timeout=500 >This I did because during earlier operations, I was >getting message "too many checkpoints. Consider >increasing checkpoints_segments" > >So please can someone tell me why data is not getting >inserted in table? > >Thanks, >Akanksha Kulkarni > > > > > > > > >__________________________________________________ >Do You Yahoo!? >Tired of spam? Yahoo! Mail has the best spam protection around >http://mail.yahoo.com > >---------------------------(end of broadcast)--------------------------- >TIP 8: explain analyze is your friend > > > -- regds Mallah. Rajesh Kumar Mallah +---------------------------------------------------+ | Tradeindia.com (3,11,246) Registered Users | | Indias' Leading B2B eMarketPlace | | http://www.tradeindia.com/ | +---------------------------------------------------+