[PERFORM] Regarding facing lot of time Consumed by Socket.Poll()

getting slow down , Which i need to look . -- Thanks, Keshav Upadhyaya

[PERFORM] Regarding mulitple rows insert in one shot using ADO .net connected to postgres

ert because of this my database is poor in doing this each time for very large data. What i want here is to insert multiple rows and then executing it in one time only so that it will be faster. Please help me out in this regards . -- Thanks, Keshav Upadhyaya

[PERFORM] What is the role of #fsync and #synchronous_commit in configuration file .

synchronous_commit = off It improve the performance :) and query took less time . I want to understand more in details what exactly had happened one is made them "off" , is it dangerous to do this ? as it will not sync the data in each commit . Pls help me out . -- Thanks, Keshav Upadhyaya

[PERFORM] Regarding Sequential Scans count increase each time we press refresh .

Hi , I have one table my_test table . with on index created on one column . I have turned off the sequential scans . Now when ever i do refresh on this table or press F5 , It increase the sequential scans count and Sequential tuple read count . Pls help me to understand what exactly is happen