Re: [HACKERS] B-Tree support function number 3 (strxfrm() optimization)

2014-08-03 Thread Peter Geoghegan
Consider the cities table I've played around with throughout the development of this patch: postgres=# select tablename, attname, n_distinct, correlation from pg_stats where attname in ('country', 'province', 'city'); tablename | attname | n_distinct | correlation

Re: [HACKERS] Proposed changing the definition of decade for date_trunc and extract

2014-08-03 Thread Mike Swanson
On Fri, 2014-08-01 at 22:28 -0700, Mike Swanson wrote: I'd also argue that the current function basing the logic from definition #2 has limited use even when you want to use it for such. If you want to generate text for '(decades)s' you'd have to do: SELECT extract('year' from

Re: [HACKERS] Proposed changing the definition of decade for date_trunc and extract

2014-08-03 Thread Bruce Momjian
On Sat, Aug 2, 2014 at 11:53:06PM -0700, Mike Swanson wrote: On Fri, 2014-08-01 at 22:28 -0700, Mike Swanson wrote: I'd also argue that the current function basing the logic from definition #2 has limited use even when you want to use it for such. If you want to generate text for

Re: [HACKERS] KNN-GiST with recheck

2014-08-03 Thread Emre Hasegeli
1. This patch introduces a new polygon - point operator. That seems useful on its own, with or without this patch. Yeah, but exact-knn cant come with no one implementation. But it would better come in a separate patch. I tried to split them. Separated patches are attached. I changed the

Re: [HACKERS] Usability improvements for pg_stop_backup()

2014-08-03 Thread Kevin Grittner
Josh Berkus j...@agliodbs.com wrote: Currently, if archive_command is failing, pg_stop_backup() will hang forever.  The only way to figure out what's wrong with pg_stop_backup() is to tail the PostgreSQL logs.  This is difficult for users to troubleshoot, and strongly resists any kind of

Re: [HACKERS] Proposed changing the definition of decade for date_trunc and extract

2014-08-03 Thread Gavin Flower
On 04/08/14 01:27, Bruce Momjian wrote: On Sat, Aug 2, 2014 at 11:53:06PM -0700, Mike Swanson wrote: On Fri, 2014-08-01 at 22:28 -0700, Mike Swanson wrote: I'd also argue that the current function basing the logic from definition #2 has limited use even when you want to use it for such. If

Re: [HACKERS] [BUGS] BUG #9652: inet types don't support min/max

2014-08-03 Thread Asif Naeem
Thank you Haribabu. Please see my comments inlined below i.e. On Sun, Jul 27, 2014 at 11:42 AM, Haribabu Kommi kommi.harib...@gmail.com wrote: On Thu, Jul 24, 2014 at 5:59 PM, Asif Naeem anaeem...@gmail.com wrote: Sorry for being late. Thank you for sharing updated patch, sgml changes seems