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

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

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

2017-10-03 Thread Adrien Nayrat
poofing), 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] Improving DISTINCT with LooseScan node

2017-09-18 Thread Adrien Nayrat
, -- Adrien NAYRAT http://dalibo.com - http://dalibo.org signature.asc Description: OpenPGP digital signature

Re: [HACKERS] PG 10 release notes

2017-09-12 Thread Adrien Nayrat
in previous releases, I understand we do not mention in v10's releases notes. Regards, -- Adrien NAYRAT signature.asc Description: OpenPGP digital signature

Re: [HACKERS] PG 10 release notes

2017-09-09 Thread Adrien Nayrat
On 07/13/2017 04:36 PM, Adrien Nayrat wrote: > Hello hackers, > > From: Peter Geoghegan >> 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...@postgresql.org > >

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

2017-09-04 Thread Adrien Nayrat
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 Descrip

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

2017-09-04 Thread Adrien Nayrat
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

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

2017-08-28 Thread Adrien Nayrat
enabled in auto_explain's hook. I added these 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

[HACKERS] auto_explain : log queries with wrong estimation

2017-08-24 Thread Adrien Nayrat
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] PATCH: multivariate histograms and MCV lists

2017-08-17 Thread Adrien Nayrat
#x27;stts2'), 0); Both 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 3a8

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

2017-08-02 Thread Adrien Nayrat
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] PG 10 release notes

2017-07-14 Thread Adrien Nayrat
On 07/13/2017 04:36 PM, Adrien Nayrat wrote: > Hello hackers, > > From: Peter Geoghegan >> 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...@postgresql.org > >

Re: [HACKERS] PG 10 release notes

2017-07-13 Thread Adrien Nayrat
ort 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 signature.asc Descrip

Re: [HACKERS] Dumping database creation options and ACLs

2017-07-10 Thread Adrien Nayrat
er flag in 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

2017-06-29 Thread Adrien Nayrat
ed results of pg_dumpall -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 patc

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

2017-03-28 Thread Adrien Nayrat
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] New design for FK-based join selectivity estimation

2016-12-13 Thread Adrien Nayrat
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] LSN as a recovery target

2016-08-23 Thread Adrien Nayrat
On 08/23/2016 10:39 AM, Petr Jelinek wrote: > On 23/08/16 09:33, Michael Paquier wrote: >> On Tue, Aug 23, 2016 at 12:49 AM, Robert Haas >> wrote: >>> On Mon, Aug 22, 2016 at 8:28 AM, Michael Paquier >>> wrote: >>>> On Mon, Aug 22, 2016 at 7:12 PM, Ad

Re: [HACKERS] LSN as a recovery target

2016-08-22 Thread Adrien Nayrat
On 08/20/2016 04:16 PM, Michael Paquier wrote: > On Sat, Aug 20, 2016 at 10:44 AM, Petr Jelinek wrote: >> On 20/08/16 02:13, Michael Paquier wrote: >>> On Fri, Aug 19, 2016 at 10:47 PM, Adrien Nayrat >>> wrote: >>> Using a PG_TRY/CATCH block the way you do t

Re: [HACKERS] LSN as a recovery target

2016-08-19 Thread Adrien Nayrat
t (see below) It do the job. However if you use an incorrect recovery_target_lsn you get this message : "FATAL: invalid input syntax for type pg_lsn: "0RT5/4"" I added a PG_TRY/PG_CATCH section in order to get a more explicit message : FATAL: wrong recovery_target_lsn (must