Re: [HACKERS] pgbench throttling latency limit

2014-09-13 Thread Fabien COELHO
[about logging...] Here is an attempt at updating the log features, including the aggregate and sampling stuff, with skipped transactions under throttling. I moved the logging stuff into a function which is called when a transaction is skipped or finished. From a log file format

Re: [HACKERS] documentation update for doc/src/sgml/func.sgml

2014-09-13 Thread Fabien COELHO
Attached is an updated version of the patch. Ok. I notice that you decided against adding tags around function and type names. It's really not about the IEEE changing something, but about someone changing the Wikipedia page. The way I linked it makes sure it always displays the same

Re: [HACKERS] PoC: Partial sort

2014-09-13 Thread Alexander Korotkov
On Tue, Aug 19, 2014 at 2:02 PM, David Rowley dgrowle...@gmail.com wrote: Here's a few notes from reading over the code: * pathkeys.c EquivalenceMember *member = (EquivalenceMember *) lfirst(list_head(key-pk_eclass-ec_members)); You can use linitial() instead of lfirst(list_head()).

Re: [HACKERS] documentation update for doc/src/sgml/func.sgml

2014-09-13 Thread David G Johnston
Fabien COELHO-3 wrote Of course a general rule how to link to WP would be nice ... I'm afraid that the current implicit rule is more or less no links, at least there are very few of them but in the glossary, and when I submitted docs with them they were removed before committing. Ideally

Re: [HACKERS] documentation update for doc/src/sgml/func.sgml

2014-09-13 Thread Fabien COELHO
Of course a general rule how to link to WP would be nice ... I'm afraid that the current implicit rule is more or less no links, at least there are very few of them but in the glossary, and when I submitted docs with them they were removed before committing. Ideally if external links were

Re: [HACKERS] [GSoC2014] Patch ALTER TABLE ... SET LOGGED

2014-09-13 Thread Fabrízio de Royes Mello
On Tue, Aug 26, 2014 at 1:42 AM, Fabrízio de Royes Mello fabriziome...@gmail.com wrote: On Fri, Aug 22, 2014 at 5:23 PM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: Fabrízio de Royes Mello wrote: On Fri, Aug 22, 2014 at 4:45 PM, Alvaro Herrera alvhe...@2ndquadrant.com wrote:

Re: [HACKERS] formatting.c

2014-09-13 Thread Bruce Momjian
On Fri, Sep 12, 2014 at 11:48:03PM -0400, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Is everyone OK with me renaming some variables, structures, and macros? It will make back-patching harder, but will allow us to properly maintain that file. The back-patching problem could

Re: [HACKERS] [REVIEW] Re: Compression of full-page-writes

2014-09-13 Thread Andres Freund
On 2014-09-13 08:52:33 +0300, Ants Aasma wrote: On Sat, Sep 13, 2014 at 6:59 AM, Arthur Silva arthur...@gmail.com wrote: That's not entirely true. CRC-32C beats pretty much everything with the same length quality-wise and has both hardware implementations and highly optimized software

Re: [HACKERS] [REVIEW] Re: Compression of full-page-writes

2014-09-13 Thread Tom Lane
Andres Freund and...@2ndquadrant.com writes: On 2014-09-13 08:52:33 +0300, Ants Aasma wrote: On Sat, Sep 13, 2014 at 6:59 AM, Arthur Silva arthur...@gmail.com wrote: That's not entirely true. CRC-32C beats pretty much everything with the same length quality-wise and has both hardware

[HACKERS] Postgres code for a query intermediate dataset

2014-09-13 Thread Rohit Goyal
Hi All, I want to work on the code of intermediate dataset of select and update query. For example. Rohit's salary has been updated 4 times, so it has 4 different version of salary. I want to select salary of person named Rohit. Now suppose , in intermediate result, I found 4 different

Re: [HACKERS] Postgres code for a query intermediate dataset

2014-09-13 Thread Atri Sharma
On Sat, Sep 13, 2014 at 11:06 PM, Rohit Goyal rhtgyl...@gmail.com wrote: Hi All, I want to work on the code of intermediate dataset of select and update query. For example. Rohit's salary has been updated 4 times, so it has 4 different version of salary. I want to select salary of

Re: [HACKERS] Postgres code for a query intermediate dataset

2014-09-13 Thread David G Johnston
Atri Sharma wrote On Sat, Sep 13, 2014 at 11:06 PM, Rohit Goyal lt; rhtgyl.87@ gt; wrote: Hi All, I want to work on the code of intermediate dataset of select and update query. For example. Rohit's salary has been updated 4 times, so it has 4 different version of salary. I want

Re: [HACKERS] Postgres code for a query intermediate dataset

2014-09-13 Thread Atri Sharma
On Sat, Sep 13, 2014 at 11:52 PM, David G Johnston david.g.johns...@gmail.com wrote: Atri Sharma wrote On Sat, Sep 13, 2014 at 11:06 PM, Rohit Goyal lt; Or rather even if you want to be able to reference the older versions of that record there is nothing in PostgreSQL to facilitate that.

Re: [HACKERS] [REVIEW] Re: Compression of full-page-writes

2014-09-13 Thread k...@rice.edu
On Sat, Sep 13, 2014 at 12:55:33PM -0400, Tom Lane wrote: Andres Freund and...@2ndquadrant.com writes: On 2014-09-13 08:52:33 +0300, Ants Aasma wrote: On Sat, Sep 13, 2014 at 6:59 AM, Arthur Silva arthur...@gmail.com wrote: That's not entirely true. CRC-32C beats pretty much everything with

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

2014-09-13 Thread Peter Geoghegan
On Fri, Sep 12, 2014 at 11:38 AM, Robert Haas robertmh...@gmail.com wrote: Based on discussion thus far it seems that there's a possibility that the trade-off may be different for short strings vs. long strings. If the string is small enough to fit in the L1 CPU cache, then it may be that

Re: [HACKERS] Postgres code for a query intermediate dataset

2014-09-13 Thread Gavin Flower
On 14/09/14 06:35, Atri Sharma wrote: On Sat, Sep 13, 2014 at 11:52 PM, David G Johnston david.g.johns...@gmail.com mailto:david.g.johns...@gmail.com wrote: Atri Sharma wrote On Sat, Sep 13, 2014 at 11:06 PM, Rohit Goyal lt; Or rather even if you want to be able to reference

Re: [HACKERS] A mechanism securing web applications in DBMS

2014-09-13 Thread Stephen Frost
Zhaomo, * Zhaomo Yang (zhy...@cs.ucsd.edu) wrote: Have you considered just using a regular, but unlogged, table? That would also avoid any risk that the application manages to drop or shadow the temp table somehow with a fake table that changes who is currently authenticated, and avoids

Re: [HACKERS] jsonb contains behaviour weirdness

2014-09-13 Thread Peter Geoghegan
On Fri, Sep 12, 2014 at 6:40 AM, Alexander Korotkov aekorot...@gmail.com wrote: It's likely that JB_ROOT_COUNT(val) JB_ROOT_COUNT(tmpl) should be checked only for objects, not arrays. Also, should JsonbDeepContains does same fast check when it deals with nested objects? Attached patch

Re: [HACKERS] run xmllint during build (was Re: need xmllint on borka)

2014-09-13 Thread Peter Eisentraut
On 8/21/14 4:28 PM, Fabien COELHO wrote: I'm fine with $(missing) or whatever else that provides a clear message. I've committed the $(missing) use separately, and rebased this patch on top of that. From cb2787b2473186239eb23e7320654513df8e8fb7 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut

Re: [HACKERS] Audit of logout

2014-09-13 Thread Tom Lane
Amit Kapila amit.kapil...@gmail.com writes: Yes, it was failing only on windows. Today when I further tried to look into the issue, I found that if I rebuild plpgsql, it didn't occurred. So the conclusion is that it occurred due to build mismatch, however I am not sure why a rebuild of

Re: [HACKERS] [REVIEW] Re: Compression of full-page-writes

2014-09-13 Thread k...@rice.edu
On Sat, Sep 13, 2014 at 09:50:55PM -0300, Arthur Silva wrote: On Sat, Sep 13, 2014 at 1:55 PM, Tom Lane t...@sss.pgh.pa.us wrote: Andres Freund and...@2ndquadrant.com writes: On 2014-09-13 08:52:33 +0300, Ants Aasma wrote: On Sat, Sep 13, 2014 at 6:59 AM, Arthur Silva

Re: [HACKERS] [REVIEW] Re: Compression of full-page-writes

2014-09-13 Thread Arthur Silva
On Sat, Sep 13, 2014 at 10:27 PM, k...@rice.edu k...@rice.edu wrote: On Sat, Sep 13, 2014 at 09:50:55PM -0300, Arthur Silva wrote: On Sat, Sep 13, 2014 at 1:55 PM, Tom Lane t...@sss.pgh.pa.us wrote: Andres Freund and...@2ndquadrant.com writes: On 2014-09-13 08:52:33 +0300, Ants Aasma

Re: [HACKERS] [REVIEW] Re: Compression of full-page-writes

2014-09-13 Thread Claudio Freire
On Sat, Sep 13, 2014 at 10:27 PM, k...@rice.edu k...@rice.edu wrote: Here're the results running the test program on my i5-4200M crc sb8: 90444623 elapsed: 0.513688s speed: 1.485220 GB/s crc hw: 90444623 elapsed: 0.048327s speed: 15.786877 GB/s xxhash: 7f4a8d5 elapsed: 0.182100s

Re: [HACKERS] PoC: Partial sort

2014-09-13 Thread Peter Geoghegan
On Fri, Sep 12, 2014 at 2:19 PM, Alexander Korotkov aekorot...@gmail.com wrote: Actually, higher cardinality skip columns is better. Sorting of smaller groups is faster than sorting larger groups of same size. Also, with smaller groups you achieve limit more accurate (in average), i.e. sort

Re: [HACKERS] PoC: Partial sort

2014-09-13 Thread Peter Geoghegan
Some quick comments on partial-sort-basic-2.patch: *** a/src/include/utils/tuplesort.h --- b/src/include/utils/tuplesort.h *** *** 24,29 --- 24,30 #include executor/tuptable.h #include fmgr.h #include utils/relcache.h + #include utils/sortsupport.h Why