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

2013-06-01 Thread Jeff Janes
On Thursday, May 30, 2013, wrote: > The following bug has been logged on the website: > > Bug reference: 8192 > Logged by: Federico Campoli > Email address: feder...@brandwatch.com > PostgreSQL version: 9.2.4 > Operating system: Debian 6.0 > Description: > > /* > > Descriptio

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

2013-06-01 Thread Simon Riggs
On 30 May 2013 17:43, wrote: > It seems on very large tables the concurrent update with vacuum (or > autovacuum), > when the slave is in hot standby mode, generates long loops in read on a > single wal segment during the recovery process. Not all aspects of hot standby are optimally tuned, as y

Re: [HACKERS] [BUGS] COPY .... (FORMAT binary) syntax doesn't work

2013-06-01 Thread Simon Riggs
On 27 May 2013 15:31, Tom Lane wrote: > Simon Riggs writes: >> On 26 May 2013 17:10, Tom Lane wrote: >>> More readable would be to invent an intermediate nonterminal falling >>> between ColId and ColLabel, whose expansion would be "IDENT | >>> unreserved_keyword | col_name_keyword | type_func_na

Re: [BUGS] BUG #8197: Error Message When trying to install PS8.1

2013-06-01 Thread Kevin Grittner
Michael Paquier wrote: > wrote: > >> initdb: removing contents of data directory "C:/Program Files >> (x86)/PostgreSQL/8.1/data" > > Only Postgres 8.1 is not supported anymore by the community for a > couple of years. More than that. Note that this seems to be on Windows.  While support of 8.1

Re: [BUGS] BUG #8193: A few cosmetic misspell fixes.

2013-06-01 Thread Stephen Frost
* Michael Paquier (michael.paqu...@gmail.com) wrote: > Please attach patches directly with the mails you send. +1. > For the patch, yes OK there are some spell mistakes. However this patch > should only apply on master branch, and not 9.2 as referenced above. Agreed. > Also, > changing the stru

Re: [BUGS] BUG #8197: Error Message When trying to install PS8.1

2013-06-01 Thread Michael Paquier
On Sat, Jun 1, 2013 at 3:34 AM, wrote: > initdb: removing contents of data directory "C:/Program Files > (x86)/PostgreSQL/8.1/data" > Only Postgres 8.1 is not supported anymore by the community for a couple of years. You should use a newer version. -- Michael

Re: [BUGS] BUG #8193: A few cosmetic misspell fixes.

2013-06-01 Thread Michael Paquier
On Fri, May 31, 2013 at 1:51 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 8193 > Logged by: Lajos Veres > Email address: vla...@gmail.com > PostgreSQL version: 9.2.4 > Operating system: Linux > Description: > > Found a few small misspell w