Re: [HACKERS] Turning off HOT/Cleanup sometimes

2014-09-17 Thread Emanuel Calvo
50 | 0 | 2150655 pgbench_accounts |5098774 | 300123 | 1897484 (4 rows) I ran the regression tests over the patched version and they passed ok. -- -- Emanuel Calvo http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Ser

Re: [HACKERS] printing table in asciidoc with psql

2014-09-17 Thread Emanuel Calvo
t;asciidoc" in src/bin/psql/help.c[354] 354,96-103 fprintf(output, _(" format set output format [unaligned, aligned, wrapped, html, latex, ..]\n")); Tested the patch and worked fine. -- -- Emanuel Calvo http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: [HACKERS] Turning off HOT/Cleanup sometimes

2014-09-15 Thread Emanuel Calvo
El 14/09/14 17:37, Simon Riggs escribió: > On 12 September 2014 18:19, Simon Riggs wrote: >> On 12 September 2014 15:30, Tom Lane wrote: >>> After a little bit I remembered there was already a function for this. >>> So specifically, I'd suggest using ExecRelationIsTargetRelation() >>> to decide

Re: BRIN indexes (was Re: [HACKERS] Minmax indexes)

2014-09-14 Thread Emanuel Calvo
stebin.com/gkigSNm7 Also, I found pages with an unkown type (using deafult parameters for the index creation): brin_page_type | array_agg --------+--- unknown (00) | {3,4} revmap | {1} regular| {2} meta | {0} (4 rows) > > -- -- Emanuel Calvo @3manuek

[HACKERS] Patch for CREATE RULE sgml -- Was in: [DOCS]

2014-03-21 Thread Emanuel Calvo
-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Hi guys, I realized that the output of the CREATE RULE has not a detailed output for the "events" parameter. But the question here is that I'm not sure which format follow: { INSERT | UPDATE | DELETE | SELECT} or INSERT UPDATE DELE

[HACKERS] Additional information on log_line_prefix

2013-10-25 Thread Emanuel Calvo
poral tables used Those prefixes/values are just examples/proposals. Thanks for the hard work! -- -- Emanuel Calvo

Re: [HACKERS] Parallel pg_basebackup

2013-08-24 Thread Emanuel Calvo
That looks promising! Thanks Peter! 2013/8/24 Peter Eisentraut > On Fri, 2013-08-23 at 10:51 -0300, Emanuel Calvo wrote: > > I was wondering if there is a proposal for parallelize pg_basebackup > > There isn't one, but after some talk behind the scenes, I think we > shou

[HACKERS] Parallel pg_basebackup

2013-08-23 Thread Emanuel Calvo
if you have parallel processes, none of them will have the IOPS decreased which will be translated in a great improvement. Also the network bandwidth is strong between the regions. Thanks guys! -- -- Emanuel Calvo

Re: [HACKERS] [Devel 9.2] Index-only scan in count aggregation

2012-04-18 Thread Emanuel Calvo
El día 18 de abril de 2012 18:17, Robert Haas escribió: > On Wed, Apr 18, 2012 at 12:13 PM, Emanuel Calvo > wrote: >> Hi guys, >> >> I'm one of the nightly sources of 9.2devel. I was trying some simple >> queries and I realized something: >> >> stu

[HACKERS] [Devel 9.2] Index-only scan in count aggregation

2012-04-18 Thread Emanuel Calvo
ext patches or the idea is to maintain this behaviour. Cheers and thanks for the amazing work you all had done! -- -- Emanuel Calvo -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Re: [pgeu-general] REMINDER: FOSDEM 2012 - PostgreSQL Devroom: Call for Speakers

2011-12-19 Thread Emanuel Calvo
> > Please keep in mind, that the Call for Speakers is open until December 20th. > Only a few days left. > Now it's a good time to submit your proposal ;-) > Did someone applied? -- --               Emanuel Calvo               Helpame.com -- Sent via pgsql-hackers

Re: [HACKERS] [Feature Request] \dx show "options"

2011-11-14 Thread Emanuel Calvo
2011/11/14 Robert Haas : > On Mon, Nov 14, 2011 at 10:45 AM, Emanuel Calvo > wrote: >> 2011/11/10 Robert Haas : >>> On Wed, Nov 9, 2011 at 12:31 PM, Emanuel Calvo >>> wrote: >>>>> \dew+ lists the actual options supplied to a foreign data wrappe

Re: [HACKERS] [Feature Request] \dx show "options"

2011-11-14 Thread Emanuel Calvo
2011/11/10 Robert Haas : > On Wed, Nov 9, 2011 at 12:31 PM, Emanuel Calvo wrote: >>> \dew+ lists the actual options supplied to a foreign data wrapper already. >> >> Checked, but the options doesn't appear (the column exists, but is empty). > > Well, that jus

Re: [HACKERS] [Feature Request] \dx show "options"

2011-11-09 Thread Emanuel Calvo
2011/11/9 Robert Haas : > On Wed, Nov 9, 2011 at 7:57 AM, Emanuel Calvo wrote: >> I was thinking that could be great to add a column in \dx showing the >> available >> options for each foreign data wrapper. >> >> Seems reasonable? > > \dx doesn't l

Re: [HACKERS] [Feature Request] \dx show "options"

2011-11-09 Thread Emanuel Calvo
2011/11/9 Emanuel Calvo : > Hi guys, > > I was thinking that could be great to add a column in \dx showing the > available > options for each foreign data wrapper. > > Seems reasonable? > Sorry the spam guys, it necesary the sme for index collations. They appear in &

[HACKERS] [Feature Request] \dx show "options"

2011-11-09 Thread Emanuel Calvo
Hi guys, I was thinking that could be great to add a column in \dx showing the available options for each foreign data wrapper. Seems reasonable? -- --               Emanuel Calvo               Helpame.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

[HACKERS] Feature request: new column is_paused in pg_stat_replication

2011-06-29 Thread Emanuel Calvo
calculate this in the primary, just comparing the other locations with the replay one. Any toughs? -- --               Emanuel Calvo               Helpame.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.or

[HACKERS] pg_basebackup

2011-05-25 Thread Emanuel Calvo
Thougths? -- --               Emanuel Calvo               Helpame.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] uuid contrib don't compile in OpenSolaris

2009-08-15 Thread Emanuel Calvo Franco
d_generator. I tryed to run uuidgen, but throws a lib.so.1 absence. Seems that the problem comes more dephtly. -- Emanuel Calvo Franco Database consultant at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-hackers

Re: [HACKERS] uuid contrib don't compile in OpenSolaris

2009-08-14 Thread Emanuel Calvo Franco
be easy to port it but it needs a time :(. > >                Zdenek > Oh! thanks Zdenek! I could try a workaround on this, i you guys could help let me know. -- Emanuel Calvo Franco Database consultant at: www.siu.edu.ar www.emanu

Re: [HACKERS] uuid contrib don't compile in OpenSolaris

2009-07-24 Thread Emanuel Calvo Franco
parator. As I say, looking in the web i found that maybe is a bad character (a hidden tab or something like this). This occurs only in opensolaris 200906 (i didn't test on previous versions). -- Emanuel Calvo Franco www.emanuelcalvofranco.com.ar ArPug.com.ar

[HACKERS] uuid contrib don't compile in OpenSolaris

2009-07-24 Thread Emanuel Calvo Franco
his ? If not, i will continue my workaround on this and try to propose something to fix it. --              Emanuel Calvo Franco      www.emanuelcalvofranco.com.ar          ArPug.com.ar / aosug.com.ar -- Emanuel Calvo Franco www.emanuelcalvofranco.com.ar

Re: [HACKERS] PostgreSQL installation

2009-06-12 Thread Emanuel Calvo Franco
ation for Solaris are in the site #1, you will find since installation until complex trace rutines. Enjoy it! #1[http://www.sun.com/software/products/postgresql/index.jsp] Regards, -- Emanuel Calvo Franco ArPUG [www.arpug.com.ar] / AOSUG Member www.emanuelcalvofranco.com.ar

Re: [HACKERS] problem inserting in GIN index

2009-03-10 Thread Emanuel Calvo Franco
                          WWW: http://www.sigaev.ru/ > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > Yes, there are some btree indexes broken. Alvaro asked him

Re: [HACKERS] problem inserting in GIN index

2009-03-09 Thread Emanuel Calvo Franco
(pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Emanuel Calvo Franco Sumate al ARPUG ! (www.postgres-arg.org - www.arpug.com.ar) ArPUG / AOSUG Member Postgresql Support &am

Re: [HACKERS] solaris libpq threaded build fails

2009-01-13 Thread Emanuel Calvo Franco
gt; http://www.postgresql.org/mailpref/pgsql-hackers > > -- > Bruce Momjian http://momjian.us > EnterpriseDB http://enterprisedb.com > > + If your life is a hard drive, Christ can be your backup. + > > -- > Sent via pgsql-hackers mailin

[HACKERS] FAQ_Solaris 1.28 to spanish

2008-10-28 Thread postgres Emanuel CALVO FRANCO
This file is for add to pgsql-docs, is the translation of the FAQ_solaris. I have new things to add, specially for Open Solaris plattaform specifications. I can write a new FAQ or just concatenate to this the other features of OSolaris? Reggards, -- Emanuel Calvo Franco Syscope