Re: [PERFORM] Update is more affected( taking more time) than Select

Hemant Pandey wrote: Operation A:6 Fetch + 1 Update Operation B:9 Fetch Operation C:5 Fetch + 3 Update ( Tables has 140 records) I have run these operations while Auto Vacumm is running and observed the time taken in thse operations. I found that Operation C

[PERFORM] Update is more affected( taking more time) than Select ( if Auto vacuum is not running)

Hi All, I have an ODBC application( using postgres database) which has three different operations. Each operation is having combination of SELECT and UPDATE. For example: Operation A:6 Fetch + 1 Update Operation B:9 Fetch Operation C:5 Fetch + 3 Updat