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 wrote: > On Wed, May 23, 2012 at 2:00 PM, Jeff Janes 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 transactions, at a ratio varying

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 wrote: > On 30 May 2012 12:10, Heikki Linnakangas > wrote: > >> Hmm, we do this in smgrDoPendingDeletes: >> >> for (i = 0; i <= MAX_FORKNUM; i++) >> { >>        smgrdounlink(srel, i, false); >> } >> >> So we drop the buffers for each relation fork sepa

Re: [HACKERS] Visual Studio 2012 RC

2012-06-03 Thread Dave Page
On Sun, Jun 3, 2012 at 11:38 AM, Magnus Hagander 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 having the pro vers

Re: [HACKERS] Visual Studio 2012 RC

2012-06-03 Thread Magnus Hagander
On Sun, Jun 3, 2012 at 12:37 PM, Dave Page wrote: > On Sun, Jun 3, 2012 at 11:22 AM, Magnus Hagander wrote: >> On Sat, Jun 2, 2012 at 11:26 PM, Brar Piening wrote: >>> The attached patch makes postgres build with Visual Studio 2012 RC. >> >> Looks good in principle - please add it to the next co

Re: [HACKERS] Visual Studio 2012 RC

2012-06-03 Thread Dave Page
On Sun, Jun 3, 2012 at 11:22 AM, Magnus Hagander wrote: > On Sat, Jun 2, 2012 at 11:26 PM, Brar Piening 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/comm

Re: [HACKERS] Visual Studio 2012 RC

2012-06-03 Thread Magnus Hagander
On Sat, Jun 2, 2012 at 11:26 PM, Brar Piening 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 build targe

Re: [HACKERS] \conninfo and SSL

2012-06-03 Thread Alastair Turner
On Thu, May 31, 2012 at 9:11 PM, Magnus Hagander wrote: > On Thu, May 31, 2012 at 9:04 PM, Bruce Momjian wrote: >> On startup, psql shows the SSL information: >> >>        $ psql 'sslmode=require host=localhost' >>        psql (9.2beta1) >>        SSL connection (cipher: DHE-RSA-AES256-SHA, bits: