Re: [GENERAL] WIP: CoC

2016-01-12 Thread Neil Tiffin
> On Jan 12, 2016, at 12:20 AM, Tom Lane wrote: > > [ just a few comments on specific points ] > > "Greg Sabino Mullane" writes: >>> 2. The CoC is not about being offended. The act of being offended is >>> purely a recipient response and usually the offended individual is more >>> interested

Re: [GENERAL] Code of Conduct: Is it time?

2016-01-12 Thread Neil Tiffin
> On Jan 12, 2016, at 7:50 AM, Vick Khera wrote: > > On Mon, Jan 11, 2016 at 6:55 PM, Steve Litt wrote: >> All because somebody just *had* to personally insult someone else, >> repeatedly, and nobody thought that was a bad thing, and when the >> recipient finally objected, the objection was cha

Re: [GENERAL] Code of Conduct: Is it time?

2016-01-11 Thread Neil Tiffin
> On Jan 10, 2016, at 2:59 PM, Joshua D. Drake wrote: > > On 01/10/2016 10:44 AM, Regina Obe wrote: > >>> JD >> >> This may come as a big shock to many of you, but as a contributor >> I don't care if you are racist, sexist, transphobic or whatever as long as >> you > > I think this is reasona

Re: [GENERAL] PostgreSQL Developer Best Practices

2015-08-25 Thread Neil Tiffin
> On Aug 25, 2015, at 1:38 PM, Karsten Hilbert wrote: > >> In most cases developers don’t care about index, unique, foreign key, or >> primary key names (from a coding standpoint) > > Until the day they’d like to write a reliable database change script. Not sure I understand. Once the object

Re: [GENERAL] PostgreSQL Developer Best Practices

2015-08-25 Thread Neil Tiffin
> On Aug 22, 2015, at 10:15 AM, Melvin Davidson wrote: > 6. Although it is legal to use the form "column TYPE PRIMARY KEY," It is best > to specify as a CONSTRAINT, >that way YOU get to choose the name, otherwise postgres assigns a default > name which may not be to your liking. >EG: ,

Re: [GENERAL] Create Virtual Indexes on Postgres

2015-02-26 Thread Neil Tiffin
e and the execution time of query before actually creating that > Index. Is there any provision to do that in Postgres (or) suggest any way to > find that > > On Thu, Feb 26, 2015 at 7:09 PM, Neil Tiffin <mailto:ne...@neiltiffin.com>> wrote: > > > On Feb 26, 20

Re: [GENERAL] Create Virtual Indexes on Postgres

2015-02-26 Thread Neil Tiffin
> On Feb 26, 2015, at 12:47 AM, Sreerama Manoj > wrote: > > Hi, > I use Postgres 9.4 database.Now,I am optimizing the queries by using the > results of "explain" and "explain analyze",Sometimes I am creating Indexes to > optimize them. But, I was not successful sometimes as even I create

[GENERAL] Help with PostgreSQL 9.4 to expand jsonb int array into table with row numbers

2014-11-03 Thread Neil Tiffin
Trying to wrap my head around postgresql 9.4 jsonb and would like some help figuring out how to do the following. Given the following example jsonb: ‘{“name1” : value1, “name2” : value2, “name3” : [int1, int2, int3] }’::jsonb AS table1.column1 Wanted: Return the “name3” array only,

Re: [GENERAL] Postgre SQL SHA-256 Compliance

2014-09-22 Thread Neil Tiffin
On Sep 22, 2014, at 9:46 AM, Paul Jungwirth wrote: >>> Can you confirm that your software is SHA-256 Compliant? > > Postgres's SSL certificate & key live at the value of ssl_cert_file > and ssl_key_file in your postgresql.conf. Why not point it at a > SHA-256 certificate, restart, and try it ou

Re: [GENERAL] Offending My Tender Sensibilities -OR- OLTP on a Star Schema

2014-02-06 Thread Neil Tiffin
On Feb 6, 2014, at 12:44 PM, Scott Marlowe wrote: > Merlin, this reminds me of the quote from Mencken: For every complex > problem there is an answer that is clear, simple, and wrong. Or as Niklaus Wirth said. ... complexity has and will maintain a strong fascination for many people. It is t

Re: [GENERAL] Why are stored procedures looked on so negatively?

2013-07-25 Thread Neil Tiffin
On Jul 23, 2013, at 7:29 PM, Some Developer wrote: > I've done quite a bit of reading on stored procedures recently and the > consensus seems to be that you shouldn't use them unless you really must. Application architecture is a specific software engineering discipline. These types of genera

Re: [GENERAL] Postgres case insensitive searches

2013-06-29 Thread Neil Tiffin
On Jun 29, 2013, at 11:24 AM, bhanu udaya wrote: > Upper and Lower functions are not right choice when the table is > 2.5 > million and where we also have heavy insert transactions. PostgreSQL and SQL Server are completely different. Rules that apply to SQL Server do not necessarily apply to

Re: [GENERAL] Supporting SQL/MED DATALINK

2012-01-09 Thread Neil Tiffin
On Jan 9, 2012, at 5:07 AM, Alban Hertroys wrote: > On 9 January 2012 09:56, Damiano ALBANI >>> I believe DB2 is pretty much it in this area. >> >> For the record, it looks like MS SQL Server has some equivalent feature : >> FILESTREAM. > > And Oracle has BFILE. > > I've actually been thinking

Re: [GENERAL] Installation woes via Macports on Mac OS X 10.7

2011-10-08 Thread Neil Tiffin
On Oct 8, 2011, at 1:01 AM, Tom Lane wrote: > =?iso-8859-1?Q?Ren=E9_Fournier?= writes: >> I've tried installation 8.4 and 9.0 on two different machines, and at the >> end can't start Postgresql. Here's the basic story: > > No, you started it all right, because it's there in the ps output: > >

Re: [GENERAL] Mac OS X shared_buffers not same as postgresql.conf file

2011-09-25 Thread Neil Tiffin
On Sep 24, 2011, at 4:21 PM, Guillaume Lelarge wrote: > On Sat, 2011-09-24 at 14:43 -0500, Neil Tiffin wrote: >> On Sep 24, 2011, at 1:31 PM, Joe Conway wrote: >> >>> On 09/23/2011 02:33 PM, Neil Tiffin wrote: >>>> I have shared_buffers in the config file se

Re: [GENERAL] Mac OS X shared_buffers not same as postgresql.conf file

2011-09-24 Thread Neil Tiffin
On Sep 24, 2011, at 1:31 PM, Joe Conway wrote: > On 09/23/2011 02:33 PM, Neil Tiffin wrote: >> I have shared_buffers in the config file set for 32 MB and pgAdmin >> reports a value of 32 MB, but pgAdmin also says the current value is >> 4096. Can anyone point me to a

[GENERAL] Mac OS X shared_buffers not same as postgresql.conf file

2011-09-24 Thread Neil Tiffin
Hello all, I am hoping someone can help me with 9.0.4 server on 8GB Mac w/Snow Leopard and shared_buffers configuration setting. I have shared_buffers in the config file set for 32 MB and pgAdmin reports a value of 32 MB, but pgAdmin also says the current value is 4096. Can anyone point me