Re: [BUGS] BUG #8163: simultaneous nearly identical update queries execute extremely slowly

2013-05-15 Thread Todd A. Cook
On 05/15/13 16:10, Tom Lane wrote: "Todd A. Cook" writes: On 05/15/13 13:27, tc...@blackducksoftware.com wrote: When nearly identical update queries arrive simultaneously, the first one to execute runs normally, but subsequent executions run _extremely_ slowly. We've seen th

Re: [BUGS] BUG #8163: simultaneous nearly identical update queries execute extremely slowly

2013-05-15 Thread Todd A. Cook
On 05/15/13 13:27, tc...@blackducksoftware.com wrote: The following bug has been logged on the website: Bug reference: 8163 Logged by: Todd Cook Email address: tc...@blackducksoftware.com PostgreSQL version: 8.4.16 Operating system: Fedora 14 Description: When nearly identi

Re: [BUGS] BUG #4377: casting result of timeofday() to timestamp fails in some timezones

2008-08-27 Thread Todd A. Cook
Tom Lane wrote: In the meantime, why aren't you just using clock_timestamp()? timeofday() is deprecated. I am using clock_timestamp() now. The use of timeofday() was from the era when 8.0 was hot stuff. BTW, the word "deprecated" does not appear on the docs page where timeofday() is listed (