Обсуждение: Status of COPY support patch
Hello all, I'm going to refactor a bit my old app where I used a lot of INSERT's instead of COPY 'cause of it being unsupported. Recently I've searched mailing lists and found that thread - http://archives.postgresql.org/pgsql-jdbc/2005-08/msg00133.php, which gives me some hope. COPY support is still in ToDO list, though. So I'd like to ask about status of this feature - will it be included in the near future so I should wait a while or I better off using patched one from http://download.postgresintl.com/ ? I really want to rewrite app since COPY would improve performance considerably. Thanks, Sergey Pariev.
This is certainly on the TODO list. Dave On 3-Nov-05, at 10:59 AM, Sergey Pariev wrote: > Hello all, > I'm going to refactor a bit my old app where I used a lot of > INSERT's instead of COPY 'cause of it being unsupported. > Recently I've searched mailing lists and found that thread - http:// > archives.postgresql.org/pgsql-jdbc/2005-08/msg00133.php, which > gives me some hope. COPY support is still in ToDO list, though. So > I'd like to ask about status of this feature - will it be included > in the near future so I should wait a while or I better off using > patched one from http://download.postgresintl.com/ ? I really want > to rewrite app since COPY would improve performance considerably. > > Thanks, Sergey Pariev. > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend > >
Ok, thanks. So I'll go with this one as for now - http://download.postgresintl.com/copy.tar.gz Thanks, Sergey. Dave Cramer пишет: > This is certainly on the TODO list. > > Dave > On 3-Nov-05, at 10:59 AM, Sergey Pariev wrote: > >> Hello all, >> I'm going to refactor a bit my old app where I used a lot of >> INSERT's instead of COPY 'cause of it being unsupported. >> Recently I've searched mailing lists and found that thread - http:// >> archives.postgresql.org/pgsql-jdbc/2005-08/msg00133.php, which gives >> me some hope. COPY support is still in ToDO list, though. So I'd >> like to ask about status of this feature - will it be included in >> the near future so I should wait a while or I better off using >> patched one from http://download.postgresintl.com/ ? I really want >> to rewrite app since COPY would improve performance considerably. >> >> Thanks, Sergey Pariev. >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 6: explain analyze is your friend >> >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings