Re: [BUGS] BUG #8192: On very large tables the concurrent update with vacuum lag the hot_standby replica

2013-06-07 Thread Federico Campoli
On 06/06/13 21:22, Jeff Janes wrote: On Tue, Jun 4, 2013 at 8:36 AM, Federico Campoli mailto:feder...@brandwatch.com>> wrote: This is the gprof output for the profile. This looks to me like the gprof of a process that is either idle, or completely IO bound. I'd probably approach this wit

Re: [BUGS] BUG #8216: TO_DATE does not support th format provided

2013-06-07 Thread Tom Lane
sunitha.mudu...@blss.com.au writes: > To_date does not throw an error when an invalid date is provided to it > select to_date('10-30-2012','dd-MM-'); That's not a bug; it's operating as designed. If you want more error checking, don't use to_date() --- just cast the string to date. regressio

Re: [BUGS] BUG #8215: pg_dump includes table out of order in SQL dump

2013-06-07 Thread Isaac Morland
On Thu, 6 Jun 2013, Tom Lane wrote: ijmor...@uwaterloo.ca writes: My understanding is that pg_dump is supposed to include tables in SQL dumps in alphabetical order by table name. That's the default behavior as long as there are no ordering constraints that would dictate doing something else.