Re: [HACKERS] LSN as a recovery target

On 06/09/2016 02:33 PM, Michael Paquier wrote: > On Wed, May 25, 2016 at 1:32 AM, Michael Paquier > wrote: >> On Tue, May 24, 2016 at 9:29 AM, Alvaro Herrera >> wrote: >>> Christoph Berg wrote: Re: Michael Paquier 2016-05-24

Re: [HACKERS] LSN as a recovery target

On 08/20/2016 04:16 PM, Michael Paquier wrote: > On Sat, Aug 20, 2016 at 10:44 AM, Petr Jelinek <p...@2ndquadrant.com> wrote: >> On 20/08/16 02:13, Michael Paquier wrote: >>> On Fri, Aug 19, 2016 at 10:47 PM, Adrien Nayrat >>> <adrien.nay...@dalibo.com>

Re: [HACKERS] LSN as a recovery target

> wrote: >>>> On Mon, Aug 22, 2016 at 7:12 PM, Adrien Nayrat >>>> <adrien.nay...@dalibo.com> wrote: >>>>> As Julien said, there is nothing to notice that error comes from >>>>> recovery.conf. >>>>> My fear would be that

Re: [HACKERS] New design for FK-based join selectivity estimation

d by Filter: 91 Planning time: 0.247 ms Execution time: 235.295 ms (10 rows) Estimated row is 10x larger since 100340e2d Regards, -- Adrien NAYRAT http://dalibo.com - http://dalibo.org signature.asc Description: OpenPGP digital signature

Re: [HACKERS] On How To Shorten the Steep Learning Curve Towards PG Hacking...

a hands-on manner explaining step by step every > technical > detail. Hi, Bruce Momjian has made several presentations about Postgres Internal : http://momjian.us/main/presentations/internals.html Regards -- Adrien NAYRAT signature.asc Description: OpenPGP digital signature

Re: [HACKERS] [PATCH v3] pg_progress() SQL function to monitor progression of long running SQL queries/utilities

On 08/01/2017 06:35 PM, Remi Colinet wrote: > Does anyone use these formats (XML, JSON, YAML) for EXPLAIN output? Yes : http://tatiyants.com/pev/#/plans :) -- Adrien NAYRAT http://dalibo.com - http://dalibo.org signature.asc Description: OpenPGP digital signature

Re: [HACKERS] PATCH: multivariate histograms and MCV lists

oth crashes. Unfotunately, I don't have the knowledge to produce a patch :/ Small fix in documentation, patch attached. Thanks! -- Adrien NAYRAT http://dalibo.com - http://dalibo.org diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 3a86577b0a..a4ab48cc81 100644 ---

Re: [HACKERS] PG 10 release notes

0, tuplesort external sort run merging became much faster > following commit 24598337c8d. It might be noticeable if such a machine > were using Postgres 10 [...] Should-we mention this improvement in release notes? Regards, -- Adrien NAYRAT http://dalibo.com - http://dalibo.org signatu

Re: [HACKERS] PG 10 release notes

On 07/13/2017 04:36 PM, Adrien Nayrat wrote: > Hello hackers, > > From: Peter Geoghegan <p...@bowt.ie> >> Date: Wed, 5 Jul 2017 15:19:57 -0700 >> Subject: Re: [BUGS] BUG #14722: Segfault in tuplesort_heap_siftup, 32 bit >> overflow >> On pgsql-b...@pos

Re: [HACKERS] Dumping database creation options and ACLs

pg_dumpall? Is it the role of pg_dumpall?". Regards, -- Adrien NAYRAT http://dalibo.com - http://dalibo.org signature.asc Description: OpenPGP digital signature

Re: [HACKERS] Dumping database creation options and ACLs

pall -g and what the dumpCreateDB() function outputs. What do you think about adding an option like --createdb-only (as suggested by Ronan) for this? I'm not fully satisfied with this name though, I'll be happy if you have a better suggestion. Attached a naive patch. -- Adrien NAYRAT http://

Re: [HACKERS] Improving DISTINCT with LooseScan node

, -- Adrien NAYRAT http://dalibo.com - http://dalibo.org signature.asc Description: OpenPGP digital signature

Re: [HACKERS] PG 10 release notes

On 07/13/2017 04:36 PM, Adrien Nayrat wrote: > Hello hackers, > > From: Peter Geoghegan <p...@bowt.ie> >> Date: Wed, 5 Jul 2017 15:19:57 -0700 >> Subject: Re: [BUGS] BUG #14722: Segfault in tuplesort_heap_siftup, 32 bit >> overflow >> On pgsql-b...@pos

Re: [HACKERS] PG 10 release notes

us releases, I understand we do not mention in v10's releases notes. Regards, -- Adrien NAYRAT signature.asc Description: OpenPGP digital signature

Re: [HACKERS] Possible SSL improvements for a newcomer to tackle

that's why you have to use DNSSEC. 1: https://en.wikipedia.org/wiki/DNS-based_Authentication_of_Named_Entities 2: https://en.wikipedia.org/wiki/Domain_Name_System_Security_Extensions -- Adrien NAYRAT signature.asc Description: OpenPGP digital signature

Re: [HACKERS] Possible SSL improvements for a newcomer to tackle

:). I do not pretend to work on this feature, I really do not have sufficient knowledge :/. -- Adrien NAYRAT signature.asc Description: OpenPGP digital signature

[HACKERS] auto_explain : log queries with wrong estimation

plain. So my patch works only with explain (and segfault without). Is there a simple way to get ntuples? Attached a naive patch. Thanks :) -- Adrien NAYRAT http://dalibo.com - http://dalibo.org diff --git a/contrib/auto_explain/auto_explain.c b/contrib/auto_explain/auto_explain.c index edcb

Re: [HACKERS] auto_explain : log queries with wrong estimation

e lines and it works : if (auto_explain_log_estimate_ratio || auto_explain_log_estimate_min_rows) { queryDesc->instrument_options |= INSTRUMENT_ROWS; } But I need to undestand how instrumentation works. Thanks for your answer. I will continue my work, actually my patch is not functionnal. -- Adrien NAYRAT signature.asc Description: OpenPGP digital signature

Re: [HACKERS] ALTER INDEX .. SET STATISTICS ... behaviour

On 09/04/2017 06:16 PM, Alexander Korotkov wrote: > Looks good for me.  I've integrated those changes in the patch. > New revision is attached. Thanks, I changed status to "ready for commiter". -- Adrien NAYRAT http://dalibo.com - http://dalibo.org signature.asc Description:

Re: [HACKERS] ALTER INDEX .. SET STATISTICS ... behaviour

le precision | (d + e)| plain | 1000 b | cstring | b | plain | btree, for table "public.tmp" * psql completion is missing (added to previous patch) Regards, -- Adrien NAYRAT http://dalibo.com - http://dalibo.org diff --git a/src/bin/psql/describe.c