From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: akanksha kulkarni <akanksha_kul@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: data not getting inserted into table
Date: Mon, 25 Oct 2004 11:27:58 +0530
Message-ID: <417C95E6.8060300@trade-india.com> (raw)
In-Reply-To: <20041021135156.67661.qmail@web52907.mail.yahoo.com>
References: <20041021135156.67661.qmail@web52907.mail.yahoo.com>
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 <table> (<column list>) select
><column list> from <table>).
>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/ |
+---------------------------------------------------+
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mallah@trade-india.com, akanksha_kul@yahoo.com
Subject: Re: data not getting inserted into table
In-Reply-To: <417C95E6.8060300@trade-india.com>
References: <20041021135156.67661.qmail@web52907.mail.yahoo.com> <417C95E6.8060300@trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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