Skip site navigation (1) Skip section navigation (2)

data not getting inserted into table

From: akanksha kulkarni <akanksha_kul(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: data not getting inserted into table
Date: 2004-10-21 13:51:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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
increasing checkpoints_segments"

So please can someone tell me why data is not getting
inserted in table?

Akanksha Kulkarni

Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 


pgsql-admin by date

Next:From: SlobodanDate: 2004-10-21 14:43:01
Subject: How to drop a database cluster?
Previous:From: IainDate: 2004-10-21 10:32:53
Subject: high (or at least improved) availability and failover

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group