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
I changed some parameters in postgres configuration
file which are as follows:
sort_mem = 16384
This I did because during earlier operations, I was
getting message "too many checkpoints. Consider
So please can someone tell me why data is not getting
inserted in table?
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
pgsql-admin by date
|Next:||From: Slobodan||Date: 2004-10-21 14:43:01|
|Subject: How to drop a database cluster?|
|Previous:||From: Iain||Date: 2004-10-21 10:32:53|
|Subject: high (or at least improved) availability and failover|