[PERFORM] update 600000 rows

Hello i have a python script to update 60 rows to one table from a csv file in my postgres database and it takes me 5 hours to do the transaction... I'm on debian etch with 8.1 postgres server on a 64 bits quad bi opteron. I have desactived all index except the primary key who is not update

Re: [PERFORM] determining maxsize for character varying

Thanks if i understand well that means that if i choose character varying(3) or character varying(8) or character varying(32) or character varying with no max length the fields will take the same place in the disk (8kb) except for fields too long to take place in the 8kb whose are stored in anothe

[PERFORM] determining maxsize for character varying

Hello i would like to know if not determining a max size value for a character varying's fields decrease the perfomance (perhaps size of stockage ? or something else ?) If not it is a good way to not specify a max size value ? If it has an importance is it possible to have a general environnment v