Re: [HACKERS] alternative compression algorithms?

2015-04-19 Thread Michael Paquier
On Mon, Apr 20, 2015 at 5:51 AM, Tomas Vondra wrote: I'm a bit confused though, because I've noticed various other FOSS projects adopting lz4 over the past few years and I'm yet to find a project voicing the same concerns about patents. So either they're reckless or we're excessively paranoid.

Re: [HACKERS] Bug with specific-schema extensions

2015-04-19 Thread Tom Lane
Jim Nasby jim.na...@bluetreble.com writes: If we're going to magically create the schema (which at least for a fully non-relocatable extension is fine), then I think we should also mark the schema as being part of the extension. If we do that, what happens to other objects that were added to

[HACKERS] optimizing vacuum truncation scans

2015-04-19 Thread Jeff Janes
After a large bulk load aborted near the end, I decided to vacuum the main table so as to not leave a huge chunk of free space in the middle of it, before re-running the bulk load. This vacuum took a frustratingly long time, as the backwards scan over the table to truncate the space did not

Re: [HACKERS] alternative compression algorithms?

2015-04-19 Thread Andres Freund
Hi, On 2015-04-19 22:51:53 +0200, Tomas Vondra wrote: The reason why I'm asking about this is the multivariate statistics patch - while optimizing the planning overhead, I realized that considerable amount of time is spent decompressing the statistics (serialized as bytea), and using an

Re: [HACKERS] alternative compression algorithms?

2015-04-19 Thread Stephen Frost
* Michael Paquier (michael.paqu...@gmail.com) wrote: On Mon, Apr 20, 2015 at 5:51 AM, Tomas Vondra wrote: I'm a bit confused though, because I've noticed various other FOSS projects adopting lz4 over the past few years and I'm yet to find a project voicing the same concerns about patents.

Re: [HACKERS] Improve sleep processing of pg_rewind TAP tests

2015-04-19 Thread Michael Paquier
On Thu, Apr 16, 2015 at 1:00 PM, Michael Paquier wrote: Visibly that's not the case for this test case, the timing issues that we saw happened not because of the standby not catching up, but because of the promotion not taking effect in a timely fashion. And that's as well something I saw on

Re: [HACKERS] PATCH: adaptive ndistinct estimator v4

2015-04-19 Thread Jeff Janes
On Tue, Apr 14, 2015 at 11:45 PM, Jeff Janes jeff.ja...@gmail.com wrote: On Tue, Mar 31, 2015 at 12:02 PM, Tomas Vondra tomas.von...@2ndquadrant.com wrote: Hi all, attached is v4 of the patch implementing adaptive ndistinct estimator. Hi Tomas, I have a case here where the adaptive

Re: [HACKERS] optimizing vacuum truncation scans

2015-04-19 Thread Jim Nasby
On 4/19/15 9:09 PM, Jeff Janes wrote: I did literally the simplest thing I could think of as a proof of concept patch, to see if it would actually fix things. I just jumped back a certain number of blocks occasionally and prefetched them forward, then resumed the regular backward scan. The