[PERFORM] PERFORMANCE ISSUE ODBC x LIBPQ C++ Application
Hi ! My company is evaluating to compatibilizate our system (developed in C++) to PostgreSQL. Our programmer made a lot of tests and he informed me that the performance using ODBC is very similar than using libpq, even with a big number of simultaneous connections/queries. Of course that for us is simpler use ODBC because will be easier to maintan as we already support a lot of other databases using ODBC (MySQL, DB2, etc). Someone already had this experience? What are the key benefits using libpq insted of ODBC ? Our application have a heavy load and around 150 concorrent users. Regards, Rodrigo Carvalhaes -- Esta mensagem foi verificada pelo sistema de antivírus e acredita-se estar livre de perigo. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[PERFORM] Improve BULK insertion
Hi ! I need to insert 500.000 records on a table frequently. It´s a bulk insertion from my applicatoin. I am with a very poor performance. PostgreSQL insert very fast until the tuple 200.000 and after it the insertion starts to be really slow. I am seeing on the log and there is a lot of transaction logs, something like : 2004-12-04 11:08:59 LOG: recycled transaction log file 00060012 2004-12-04 11:08:59 LOG: recycled transaction log file 00060013 2004-12-04 11:08:59 LOG: recycled transaction log file 00060011 2004-12-04 11:14:04 LOG: recycled transaction log file 00060015 2004-12-04 11:14:04 LOG: recycled transaction log file 00060014 2004-12-04 11:19:08 LOG: recycled transaction log file 00060016 2004-12-04 11:19:08 LOG: recycled transaction log file 00060017 2004-12-04 11:24:10 LOG: recycled transaction log file 00060018 How can I configure PostgreSQL to have a better performance on this bulk insertions ? I already increased the memory values. My data: Conectiva linux kernel 2.6.9 PostgreSQL 7.4.6 - 1,5gb memory max_connections = 30 shared_buffers = 3 sort_mem = 32768 vacuum_mem = 32768 max_fsm_pages = 3 max_fsm_relations = 1500 The other configurations are default. Cheers, Rodrigo Carvalhaes ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly