Re: [HACKERS] \conninfo and SSL

2012-06-03 Thread Alastair Turner
On Thu, May 31, 2012 at 9:11 PM, Magnus Hagander mag...@hagander.net wrote: On Thu, May 31, 2012 at 9:04 PM, Bruce Momjian br...@momjian.us wrote: On startup, psql shows the SSL information:        $ psql 'sslmode=require host=localhost'        psql (9.2beta1)        SSL connection (cipher:

Re: [HACKERS] Visual Studio 2012 RC

2012-06-03 Thread Magnus Hagander
On Sat, Jun 2, 2012 at 11:26 PM, Brar Piening b...@gmx.de wrote: The attached patch makes postgres build with Visual Studio 2012 RC. Looks good in principle - please add it to the next commitfest (https://commitfest.postgresql.org/action/commitfest_view?id=14). We're definitely not adding a new

Re: [HACKERS] Visual Studio 2012 RC

2012-06-03 Thread Dave Page
On Sun, Jun 3, 2012 at 11:22 AM, Magnus Hagander mag...@hagander.net wrote: On Sat, Jun 2, 2012 at 11:26 PM, Brar Piening b...@gmx.de wrote: The attached patch makes postgres build with Visual Studio 2012 RC. Looks good in principle - please add it to the next commitfest

Re: [HACKERS] Visual Studio 2012 RC

2012-06-03 Thread Magnus Hagander
On Sun, Jun 3, 2012 at 12:37 PM, Dave Page dp...@pgadmin.org wrote: On Sun, Jun 3, 2012 at 11:22 AM, Magnus Hagander mag...@hagander.net wrote: On Sat, Jun 2, 2012 at 11:26 PM, Brar Piening b...@gmx.de wrote: The attached patch makes postgres build with Visual Studio 2012 RC. Looks good in

Re: [HACKERS] Visual Studio 2012 RC

2012-06-03 Thread Dave Page
On Sun, Jun 3, 2012 at 11:38 AM, Magnus Hagander mag...@hagander.net wrote: We might also want to think twice about producing the installers with 2012, and just stick to 2010 pro for that. Because once we go 2012 on that, it's no longer going ot be possible to build addons without either

Re: [HACKERS] slow dropping of tables, DropRelFileNodeBuffers, tas

2012-06-03 Thread Jeff Janes
On Thu, May 31, 2012 at 5:04 AM, Simon Riggs si...@2ndquadrant.com wrote: On 30 May 2012 12:10, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: Hmm, we do this in smgrDoPendingDeletes: for (i = 0; i = MAX_FORKNUM; i++) {        smgrdounlink(srel, i, false); } So we drop

Re: [HACKERS] Add primary key/unique constraint using prefix columns of an index

2012-06-03 Thread Jeff Janes
On Wed, May 23, 2012 at 11:05 AM, Robert Haas robertmh...@gmail.com wrote: On Wed, May 23, 2012 at 2:00 PM, Jeff Janes jeff.ja...@gmail.com wrote: I'm running some tests where I mix the work load of pgbench by doing TPC-B (sort of) transaction mixed in with a variable number of SELECT-only