[ADMIN] Problem with inserts from subselects

2004-04-26 Thread Tyler Ward
I'm using postgres 7.3.x (the default installed on Fedora Core 1) and I'm running into a serious bug in the insert performance. When I try a query like this... INSERT INTO table_a (session, sent, data_row, direction_id, instrument, price, size) ( select tmp.session, tmp.sent, tmp.data_row,

[ADMIN] Problem with inserts from subselects

2004-04-23 Thread Tyler Ward
I'm using postgres 7.3.x (the default installed on Fedora Core 1) and I'm running into a serious bug in the insert performance. When I try a query like this... INSERT INTO table_a (session, sent, data_row, direction_id, instrument, price, size) ( select tmp.session, tmp.sent, tmp.data_row