132 reputation
9
bio website linkedin.com/in/bhavikambani
location Ahmadabad, India
age 26
visits member for 2 years, 9 months
seen Nov 7 at 9:06

Working as a Software Engineer at eLitecore Technologies Pvt. Ltd., Ahmedabad Gujarat since July, 2011

profile for Bhavik Ambani on Stack Exchange, a network of free, community-driven Q&A sites "Choose a job you love, and you will never have to work a day in your life"


Oct
8
awarded  Popular Question
Jan
4
accepted Postgresql revert back database value
Dec
16
awarded  Critic
May
13
accepted Performance degradation while updating tables having 10s of millions of records
May
12
awarded  Peer Pressure
May
10
comment Performance degradation while updating tables having 10s of millions of records
For that will I have to create one another user then assign memory to him ?
May
10
comment Performance degradation while updating tables having 10s of millions of records
I do not have index on customer name.
May
9
awarded  Commentator
May
9
comment Performance degradation while updating tables having 10s of millions of records
I have just named as temp but actual name is different
May
9
comment Performance degradation while updating tables having 10s of millions of records
Because it is main server and it is live machine if the CPU usage gets higher then its performance will be degraded and it will not be able to do other tasks for which it is made.
May
9
comment Performance degradation while updating tables having 10s of millions of records
Where should I place index on temp table or user table ?
May
9
awarded  Editor
May
9
revised Performance degradation while updating tables having 10s of millions of records
added 153 characters in body
May
9
comment Performance degradation while updating tables having 10s of millions of records
I am just executing the update query in the table. For example UPDATE TEMP SET CUSTOMERNAME = ( select customername from user where user.customerid = temp.customerid ) ;
May
9
asked Performance degradation while updating tables having 10s of millions of records
Apr
12
awarded  Supporter
Apr
12
awarded  Student
Apr
12
awarded  Scholar
Apr
12
awarded  Autobiographer
Feb
8
accepted Tables accessed during last periods in postgresql