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/ |
+---------------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html