Re: [HACKERS] Check for interrupts in bf and xdes crypt()

2015-12-27 Thread Jeff Janes
On Tue, Dec 15, 2015 at 12:35 AM, Andreas Karlsson wrote: > Hi, > > Here is a patch which makes it possible to cancel a query which runs the > crypt() function with the bf or xdes hashing algorithm, e.g. crypt('foo', > gen_salt('bf', 13)). The md5 algorithm does not run for

Re: [HACKERS] pam auth - add rhost item

2015-12-27 Thread Grzegorz Sampolski
Hi there! I'm alive and working on new patch. So, I takes into account all suggestions from Tomas and I'll add additional parameter `usedns' with `yes/no' values to pass resolved hostname or ip address through rhost_item. On 12/24/2015 03:35 AM, Michael Paquier wrote: > On Wed, Dec 16, 2015 at

Re: [HACKERS] Check for interrupts in bf and xdes crypt()

2015-12-27 Thread Alvaro Herrera
Jeff Janes wrote: > On Tue, Dec 15, 2015 at 12:35 AM, Andreas Karlsson wrote: > > Here is a patch which makes it possible to cancel a query which runs the > > crypt() function with the bf or xdes hashing algorithm, e.g. crypt('foo', > > gen_salt('bf', 13)). The md5 algorithm

Re: [HACKERS] Avoid endless futile table locks in vacuuming.

2015-12-27 Thread Tom Lane
Jeff Janes writes: > If a partially-active table develops a slug of stable all-visible, > non-empty pages at the end of it, then every autovacuum of that table > will skip the end pages on the forward scan, think they might be > truncatable, and take the access exclusive

[HACKERS] Avoid endless futile table locks in vacuuming.

2015-12-27 Thread Jeff Janes
If a partially-active table develops a slug of stable all-visible, non-empty pages at the end of it, then every autovacuum of that table will skip the end pages on the forward scan, think they might be truncatable, and take the access exclusive lock to do the truncation. And then immediately fail

Re: [HACKERS] WIP: bloom filter in Hash Joins with batches

2015-12-27 Thread David Rowley
On 18 December 2015 at 04:34, Tomas Vondra wrote: > I think ultimately we'll need to measure the false positive rate, so that > we can use it to dynamically disable the bloom filter if it gets > inefficient. Also maybe put some of that into EXPLAIN ANALYZE. > I'm

[HACKERS] Minor additional changes to 9.5's INSERT documentation

2015-12-27 Thread Peter Geoghegan
Attached is a patch that makes a few additional changes to the INSERT documentation. These changes are mostly around formatting. I also point out that unique index inference is mandatory when using unique indexes and specifying a conflict target (because unique indexes are not formally

Re: [HACKERS] [PROPOSAL] VACUUM Progress Checker.

2015-12-27 Thread Amit Langote
Hi Vinayak, On 2015/12/25 21:46, Vinayak Pokale wrote: > Hi, > Please find attached patch addressing following comments. > >> The relation OID should be reported and not its name. In case of a >> relation rename that would not be cool for tracking, and most users >> are surely going to join

Re: [HACKERS] MergeAttributes type (mod) conflict error detail

2015-12-27 Thread Amit Langote
On 2015/12/27 3:11, Tom Lane wrote: > I wrote: >> Amit Langote writes: >>> Any specific reason why it doesn't spell out typmods in the above detail >>> message? > >> * There's a rough policy in the parser to prefer TypeNameToString >> when complaining about a

Re: [HACKERS] Minor code improvements to create_foreignscan_plan/ExecInitForeignScan

2015-12-27 Thread Etsuro Fujita
On 2015/12/23 2:47, Robert Haas wrote: On Tue, Dec 22, 2015 at 7:32 AM, Michael Paquier wrote: Moved to next CF because of a lack of reviews. Thanks, Michael! I just took a look at this. I think the basic idea of this patch is good, but the comments need some

Re: [HACKERS] Remove Windows crash dump support?

2015-12-27 Thread Feng Tian
On Wed, Dec 23, 2015 at 6:14 PM, Craig Ringer wrote: > On 22 December 2015 at 23:48, Alex Ignatov > wrote: > > >> I think that you can debug crash dump since windbg exists. >> > > Nobody in their right mind uses windbg though. Visual Studio is

Re: [HACKERS] Remove Windows crash dump support?

2015-12-27 Thread Amit Kapila
On Thu, Dec 24, 2015 at 7:48 AM, Craig Ringer wrote: > On 22 December 2015 at 23:46, Tom Lane wrote: > >> > In which version(s) of Windows was this improvement added? > > > Vista and Server 2008 (original, not R2). > > >