Re: [GENERAL] UPDATE on two large datasets is very slow

2007-04-04 Thread Steve Gerhardt
the original method, since the concept in my head seems like they would be a lot more simple. Am I missing something huge with the way Postgres works? regards, tom lane Thanks for the help, Tom. Steve Gerhardt ---(end of broadcast

Re: [GENERAL] UPDATE on two large datasets is very slow

2007-04-04 Thread Steve Gerhardt
. Thanks for the reply. Steve Gerhardt Listmail wrote: No, he can't, I also coded a bittorrent tracker of the same kind, and the problem is : - each user has N torrents active - torrent client does N tracker requests - tracker only does 1 UDPATE to update user's stats So if you

[GENERAL] UPDATE on two large datasets is very slow

2007-04-03 Thread Steve Gerhardt
, I'll be happy to provide as much as I can if it means there's a solution on the horizon. For those of you that have actually read all of this, thank you for your patience, I know it's a huge message. Thanks much, Steve Gerhardt ---(end of broadcast