Re: [HACKERS] pg_upgrade and statistics

2012-03-13 Thread Euler Taveira
could be accomplished using a simple approach like '... row_number() OVER (ORDER BY pg_relation_size(oid) ... WHERE row_number % n = x' (tip stolen from Simon's book). [1] http://archives.postgresql.org/message-id/4f10a728.7090...@agliodbs.com -- Euler Taveira de Oliveira - Timbira

[HACKERS] VALID UNTIL

2012-03-14 Thread Euler Taveira
00:00:00-03 (2 rows) Is there any reason why it is not exposed? What about exposing that information in attributes or even in a separate column? It could help troubleshooting quickly on this case. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL

Re: [HACKERS] Syntax error and reserved keywords

2012-03-14 Thread Euler Taveira
cover all sql commands. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] another idea for changing global configuration settings from SQL

2012-11-16 Thread Euler Taveira
On 16-11-2012 12:27, Hannu Krosing wrote: Why not just make the sending SIGHUP a separate command as it is now ? SELECT pg_reload_config(); ... or even a RELOAD command. I've already coded a WIP patch for such command. -- Euler Taveira de Oliveira - Timbira http

Re: [HACKERS] another idea for changing global configuration settings from SQL

2012-11-16 Thread Euler Taveira
of it? As said by others, using pg_db_role_setting only works for sighup, superuser, and user context. How would you solve the backend and postmaster context? -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

Re: [HACKERS] New statistics for WAL buffer dirty writes

2012-07-07 Thread Euler Taveira
buffers so I write those dirty ones. It doesn't say how many. I would like to have something that says hey, you have 1000 buffers available and you are using 100 buffers (10%). This new statistic is only useful for decreasing the WALWriteLock contention. -- Euler Taveira de Oliveira - Timbira

Re: [HACKERS] NOT NULL constraints in foreign tables

2012-08-17 Thread Euler Taveira
changes between data sources. Even if we do it for creation time, schema could be changed behind the scenes. Let's use at least constraints (NOT NULL, CHECK, UNIQUE, PK -- UNIQUE + NOT NULL) to improve optimizer but warn (loudly) that those constraints are merely for optimization. -- Euler Taveira

Re: [HACKERS] [PoC] load balancing in libpq

2012-09-23 Thread Euler Taveira
think about PQsetdb[Login](), PQconnectdbParams() and PQconnectStartParams(). If you want to pursue this idea, you should think a way to support same option multiple times (one idea is host1, host2, etc). Isn't it easier to add support on your application or polling software? -- Euler Taveira de

Re: [HACKERS] autovacuum stress-testing our system

2012-09-26 Thread Euler Taveira
. Out of curiosity, did you run perf (or some other performance analyzer) to verify if some (stats and/or autovac) functions pop up in the report? -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

Re: [HACKERS] system_information.triggers truncate triggers

2012-09-26 Thread Euler Taveira
On 26-09-2012 11:08, Simon Riggs wrote: I suggest we implement that with some kind of switch/case in the view definition. -- parameter can be set in a session and defaults to on SET compliance_information_schema TO off; -- Euler Taveira de Oliveira - Timbira http

Re: [HACKERS] Switching timeline over streaming replication

2012-09-27 Thread Euler Taveira
generic (it use 'wal records' term to explain the feature). Feel free to reword those paragraphs mentioning SR. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Hash id in pg_stat_statements

2012-10-01 Thread Euler Taveira
for those statistics tools, isn't it? Instead of relying on internal structures hash, why don't you expose the query text hash to such tools? If you solve the space normalizations, it is an almost perfect solution for your use case. -- Euler Taveira de Oliveira - Timbira http

Re: [HACKERS] Hash id in pg_stat_statements

2012-10-02 Thread Euler Taveira
environment is distributed, you can't use the hash. There isn't a perfect solution but I see both cases being useful for analysis tools. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql

[HACKERS] install zic binary

2012-10-23 Thread Euler Taveira
DST. That's because the governor decided (without consulting the population) to be in but when people said 'no', he stepped back and requested the president to be out; that was too late. [1] http://mm.icann.org/pipermail/tz/2012-October/018347.html -- Euler Taveira de Oliveira - Timbira

Re: [HACKERS] postgres long options without value

2012-04-04 Thread Euler Taveira
do it. You can be fooled when we change a parameter default value (specially if you have it in a script that is used in different versions) from major versions. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e

Re: [HACKERS] [patch] for psql : Allow processing of multiple -f (file) options

2012-04-09 Thread Euler Taveira
* options? Look at the archives for references. Also, your disclaimer doesn't seems attractive; make it clear you're contributing code under the PostgreSQL license. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7

Re: [HACKERS] Can pg_trgm handle non-alphanumeric characters?

2012-05-09 Thread Euler Taveira
the default is the desirable behavior for almost all use cases (you are the first one that complain about it). Maybe in the future, we should be able to flip this flag without rebuilding binaries. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL

Re: [HACKERS] Draft release notes complete

2012-05-12 Thread Euler Taveira
should be credited (as coauthor) because he used a considerable part of my work. I confess that I like the link for relevant commit log in the release notes. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e

Re: [HACKERS] No, pg_size_pretty(numeric) was not such a hot idea

2012-05-26 Thread Euler Taveira
than bigint version, but I don't think that such a bit slowdown of pg_size_pretty() becomes a matter practically. No? That's what I proposed at [1]. +1 for dropping the pg_size_pretty(bigint). [1] http://archives.postgresql.org/message-id/4f315f6c.8030...@timbira.com -- Euler Taveira de

Re: [HACKERS] No, pg_size_pretty(numeric) was not such a hot idea

2012-05-27 Thread Euler Taveira
On 27-05-2012 10:45, Fujii Masao wrote: OK, let me propose another approach: add pg_size_pretty(int). If we do this, all usability and performance problems will be solved. I wouldn't like to add another function but if it solves both problems... +1. -- Euler Taveira de Oliveira - Timbira

[HACKERS] libpq compression

2012-06-13 Thread Euler Taveira
://archives.postgresql.org/pgsql-hackers/2011-01/msg00337.php [3] http://archives.postgresql.org/pgsql-hackers/2002-03/msg00664.php [4] http://archives.postgresql.org/pgsql-performance/2009-08/msg00053.php -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria

Re: [HACKERS] libpq compression

2012-06-14 Thread Euler Taveira
of patent infringement. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] libpq compression

2012-06-15 Thread Euler Taveira
the Farina's idea in supporting compression outside libpq but I'm ok with adding a standard algorithm for compression (problem is that in the future others could want to add another interesting compression algorithms). -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br

Re: [HACKERS] libpq compression

2012-06-15 Thread Euler Taveira
corner cases such as high- performance system. That is my opinion too. I'm free to use to most appropriate algorithm for compression. It is just a matter of coding an interface for my favorite compression algorithm. We could even add some algorithms in a new contrib module. -- Euler

Re: [HACKERS] libpq compression

2012-06-15 Thread Euler Taveira
to the code. I'm in favor of experimenting an standard algorithm (zlib, for example -- let's say, it is the easiest way to implement it) or even hooks (libpq and backend -- that seems to be complex but less than openssl-backed connection just for compression). -- Euler Taveira de Oliveira - Timbira

Re: [HACKERS] libpq compression

2012-06-17 Thread Euler Taveira
or even configure. But looking at an old version (0.9.7, 2003-12-31), it seems to support ! notation. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] libpq compression

2012-06-17 Thread Euler Taveira
. AFAICS, DEFAULT works for ancient openssl versions (~10 years ago). -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] libpq compression

2012-06-17 Thread Euler Taveira
should be able to at least define a list of ciphers it *doens't* want to talk with. +1. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] libpq compression

2012-06-22 Thread Euler Taveira
SSL/TLS you are bounded by what SSL/TLS software products decide to use as compression algorithms. I'll be happy to maintain the code iif it is postgres-specific or even as close as possible to core. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL

Re: [HACKERS] libpq compression

2012-06-25 Thread Euler Taveira
thinking too but I would like to make sure that others don't object to general idea. Let me give it a try in both ideas... -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers

Re: [HACKERS] libpq compression

2012-06-25 Thread Euler Taveira
? -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] libpq compression

2012-06-25 Thread Euler Taveira
compression x SSL + our compression code. If the latter is faster then we could discuss the possibility to disable compression in our SSL code and put in documentation that it is recommended to enable compression in SSL connections. -- Euler Taveira de Oliveira - Timbira http

Re: [HACKERS] libpq compression

2012-06-26 Thread Euler Taveira
, if they are bad, and we decide to support another algorithm, we might consider also using that other algorithm, at least optionally, for the purposes for which we now use pglz. I'll remember to test it too. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL

Re: [HACKERS] Fwd: Successful post to pgsql-hackers

2013-02-09 Thread Euler Taveira
On 09-02-2013 13:45, Gurjeet Singh wrote: BTW, I hope I understand what selfcopy is: send a copy to yourself. Why would that be turned on by default? If you want to reply to yourself... -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria

Re: [HACKERS] Materialized views WIP patch

2013-03-04 Thread Euler Taveira
, that's another feature. And of limited utility, as mentioned. For a first release, that is fine as is. Let's not complicate a feature that has been widely discussed in this development cycle. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria

Re: [HACKERS] SIGHUP not received by custom bgworkers if postmaster is notified

2013-03-21 Thread Euler Taveira
. Alvaro said that will include SIGHUP handle in worker_spi (see [2] for how to process configurantion file). [1] http://www.postgresql.org/message-id/20121231140353.gc4...@alvh.no-ip.org [2] http://www.postgresql.org/message-id/1357210591.1964.22.camel@localhost.localdomain -- Euler Taveira de

Re: [HACKERS] comment for fast promote

2013-07-27 Thread Euler Taveira
to suggest it is not useful. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: [HACKERS] Proposal for Allow postgresql.conf values to be changed via SQL [review])

2013-07-29 Thread Euler Taveira
permissions or ownership is an elegant way to disable it. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] getting rid of maintainer-check

2013-09-10 Thread Euler Taveira
elsewhere recently. There are some details to be resolved there, but it's doable. This has been bashing sufficient developers along the years. +1. - Checking for tabs in SGML files can be run during the regular documentation build without problems. This one too. +1. -- Euler Taveira

Re: [HACKERS] Patch for reserved connections for replication users

2013-10-20 Thread Euler Taveira
situation is when you can't run pg_basebackup because automated routines got all of the available connections and the replication user is not a superuser (even if replication user is a superuser, if some app run as superuser there won't be slots available). -- Euler Taveira

Re: [HACKERS] TODO : Allow parallel cores to be used by vacuumdb [ WIP ]

2013-11-07 Thread Euler Taveira
(pg_dump and scripts) can be done in a separate patch. Prototype patch is attached in the mail, please provide your feedback/Suggestions... I'll try to merge your patch with the one I have here until the next CF. -- Euler Taveira Timbira - http://www.timbira.com.br

Re: [HACKERS] TODO : Allow parallel cores to be used by vacuumdb [ WIP ]

2013-11-08 Thread Euler Taveira
that you can't pick indexes for the same relation (for reindex). [1] http://www.postgresql.org/message-id/CA+TgmobwxqsagXKtyQ1S8+gMpqxF_MLXv=4350tfzvqawke...@mail.gmail.com -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte

Re: [HACKERS] commit fest 2013-11 week 1 report

2013-11-22 Thread Euler Taveira
On 22-11-2013 11:07, Pavel Golub wrote: Is is possible to add small patch to the current commit fest? No. Deadline was 11/15. Add it to next CF [1]. [1] https://commitfest.postgresql.org/action/commitfest_view?id=21 -- Euler Taveira Timbira - http://www.timbira.com.br

Re: [HACKERS] JSON decoding plugin

2013-12-09 Thread Euler Taveira
. *) Consider removing 'plugin ' from the name of the plugin. --plugin=json_decoding etc. 'plugin' was a tentative to produce an unique name (it sucks but...). -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e

Re: [HACKERS] should we add a XLogRecPtr/LSN SQL type?

2013-12-11 Thread Euler Taveira
+tgmozrmnn0evesd-kxb9e-mvdmwoti6guujuvqp_8q2c5...@mail.gmail.com -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Planning time in explain/explain analyze

2013-12-23 Thread Euler Taveira
/message-id/BANLkTi=sxKTCTcv9hsACu38eaj=fw_4...@mail.gmail.com [2] https://github.com/umitanuki/planinstr -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] TODO : Allow parallel cores to be used by vacuumdb [ WIP ]

2014-01-16 Thread Euler Taveira
made the change and attached the modified patch. Don't you submit it for a CF, do you? Is it too late for this CF? -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers

Re: [HACKERS] Changeset Extraction v7.6.1

2014-02-19 Thread Euler Taveira
. Regards, [1] https://github.com/eulerto/wal2json -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Storing the password in .pgpass file in an encrypted format

2014-02-21 Thread Euler Taveira
could add support to accept md5... storage format as password. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] pg_dump reporing version of server pg_dump as comments in the output

2014-03-03 Thread Euler Taveira
, timestamps were removed to avoid noise in diffs. [1] http://www.postgresql.org/message-id/3677.1253912...@sss.pgh.pa.us -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers

Re: [HACKERS] Is this a bug?

2014-03-13 Thread Euler Taveira
of validating things. euler@euler=# reset noname; ERROR: 42704: unrecognized configuration parameter noname LOCAL: set_config_option, guc.c:5220 -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent

Re: [HACKERS] psql \d+ and oid display

2014-03-27 Thread Euler Taveira
it will be removed soon. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] pg_shmem_allocations view

2014-05-04 Thread Euler Taveira
') and just one view. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

[HACKERS] Various cosmetic fixes

2014-05-14 Thread Euler Taveira
Hi, While updating pt-br translation I noticed that some sentences could be improved. I also fix some style glitches. A set of patches are attached. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e

Re: [HACKERS] pg_recvlogical tests

2014-05-15 Thread Euler Taveira
the walsender interface that's not covered by any tests right now... beta is not the right time to add even a *minor* functionality. Let's do it for 9.5. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e

[HACKERS] cosmetic fixes

2014-05-18 Thread Euler Taveira
Hi, Here are some more trivial fixes in pg_recvlogical message style. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento From 0bbf437b490a92afa4b14e4903188bcf795f8e47 Mon Sep 17 00:00:00 2001 From

Re: [HACKERS] Changeset Extraction v7.6.1

2014-06-01 Thread Euler Taveira
be an alternative to pg_upgrade. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] how to implement selectivity injection in postgresql

2014-08-13 Thread Euler Taveira
/README. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] how to implement selectivity injection in postgresql

2014-08-13 Thread Euler Taveira
. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] settings without unit

2014-09-04 Thread Euler Taveira
Hi, I noticed that a setting in pg_settings without units have NULL and as unit values ( for integer and NULL for the other ones). Could we be consistent? It is like that since units were introduced (b517e65). No unit means unit = NULL. A proposed patch is attached. -- Euler Taveira

[HACKERS] pg_recvlogical description

2014-12-08 Thread Euler Taveira
Hi, The pg_recvlogical docs was rewritten but someone forgot to tweak the help description. It is a bit late in the 9.4 cycle but let be consistent. Regards, -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e

[HACKERS] nls and server log

2014-12-24 Thread Euler Taveira
in spanish and client messages in french. Is it an acceptable plan? Ideas? -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Remove fsync ON/OFF as a visible option?

2015-03-22 Thread Euler Taveira
to follow the default postgresql.conf. They don't add or remove parameters but replace values. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] parallel mode and parallel contexts

2015-04-26 Thread Euler Taveira
and found some low-hanging fruit. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento From 3ce5376868f61a67540915b83a15c59a31fc895a Mon Sep 17 00:00:00 2001 From: Euler Taveira eu...@timbira.com Date: Sun, 26

Re: [HACKERS] initdb start server recommendation

2015-05-01 Thread Euler Taveira
/debugging purposes. None of those use cases are intended for general users. Let's make it simple and drop 'postgres' line. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql

Re: [HACKERS] initdb start server recommendation

2015-05-07 Thread Euler Taveira
. With things like systemd, launchd, supervisord that like to manage the daemons directly, using postgres directly might be the preferable choice. Agree. However, I'm saying that _general users_ (those that don't use OS init interface) tend to prefer 'pg_ctl' to 'postgres'. -- Euler Taveira

[HACKERS] small typo

2015-05-19 Thread Euler Taveira
Hi, Attached is a small typo. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento diff --git a/contrib/pg_buffercache/pg_buffercache_pages.c b/contrib/pg_buffercache/pg_buffercache_pages.c index

Re: [HACKERS] TODO: replica information functions

2015-07-28 Thread Euler Taveira
superuser-only? pg_recovery_config(OUT name text, OUT setting text) SETOF record or pg_recovery_config(OUT name text, OUT setting text, IN all bool) SETOF record This function covers pg_standby_conninfo(). -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL

Re: [HACKERS] pg_recvlogical fixes

2015-10-22 Thread Euler Taveira
On 21-10-2015 18:36, Andres Freund wrote: On 2015-10-21 11:52:31 -0300, Euler Taveira wrote: While testing wal2json, I faced some problems with pg_recvlogical. Attached is a serie of patches that can improve pg_recvlogical. Patches #2 and #3 are bugfixes (and should be applied to 9.5 too

Re: [HACKERS] Duplicated assignment of slot_name in walsender.c

2015-10-21 Thread Euler Taveira
On 20-10-2015 08:28, Bernd Helmle wrote: The 2nd assignment to slot_name looks unnecessary? Yes, it is. Seems to be an oversight. Patch attached. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

Re: [HACKERS] pg_basebackup and replication slots

2015-10-26 Thread Euler Taveira
start of regular streaming replication. Reviewed-by: Michael Paquier <michael.paqu...@gmail.com> -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers maili

[HACKERS] pg_recvlogical fixes

2015-10-21 Thread Euler Taveira
); -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento >From 9b3d63d1744e2b65a7f1a1d44ed166f4c9684771 Mon Sep 17 00:00:00 2001 From: Euler Taveira <eu...@timbira.com.br> Date: Tue, 1 Sep 2015

Re: [HACKERS] WIP: Fix parallel workers connection bug in pg_dump (Bug #13727)

2015-10-30 Thread Euler Taveira
in -bugs because the discussion started there. Sometimes people track -bugs ML to make sure that some bugs aren't forgotten. Add your patch to the next CF [1]. [1] https://commitfest.postgresql.org/7/ -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL

Re: [HACKERS] Need to print the raw_parse_tree in the Log file

2015-11-07 Thread Euler Taveira
On 07-11-2015 12:21, Praveen M wrote: I would like to print the raw parse tree into the log . Is there any internal utility function to achieve this. If there is none , can you please help me to achieve this. debug_print_parse = on -- Euler Taveira Timbira - http

Re: [HACKERS] pam auth - add rhost item

2015-10-16 Thread Euler Taveira
entry in pg_hba.conf. [1] http://www.postgresql.org/docs/current/static/auth-methods.html#AUTH-PAM [2] http://www.postgresql.org/docs/current/static/role-membership.html -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte

Re: [HACKERS] pam auth - add rhost item

2015-10-16 Thread Euler Taveira
ter on it. [1] http://pubs.opengroup.org/onlinepubs/8329799/pam_set_item.htm -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)

Re: [HACKERS] pam auth - add rhost item

2015-10-14 Thread Euler Taveira
n. I'm not a PAM expert but my impression is that rhost is an optional item. Therefore, advise PAM users to use HBA is a way to not complicate the actual feature. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Trein

Re: [HACKERS] Small documentation fix in src/interfaces/ecpg/preproc/po/pt_BR.po

2015-10-07 Thread Euler Taveira
On 06-10-2015 19:49, Andreas 'ads' Scherbaum wrote: When working on a script, I stumbled over a mistake in the pt_BR.po translation for ecpg. Patch attached. I've already fixed it in the translation git. It'll be available only in the next set of releases. -- Euler Taveira

Re: [HACKERS] Small documentation fix in src/interfaces/ecpg/preproc/po/pt_BR.po

2015-10-07 Thread Euler Taveira
On 07-10-2015 14:05, Alvaro Herrera wrote: Euler Taveira wrote: On 06-10-2015 19:49, Andreas 'ads' Scherbaum wrote: When working on a script, I stumbled over a mistake in the pt_BR.po translation for ecpg. Patch attached. I've already fixed it in the translation git. It'll be available only

[HACKERS] pg_resetxlog sentences

2015-09-15 Thread Euler Taveira
. Patch is attached. It is new in 9.5 so backpatch is needed. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento >From cc8da654ab363366860de6c114bfc9a28561978a Mon Sep 17 00:00:00 2001 From: Eu

[HACKERS] pltcl: sentence improvement

2015-09-16 Thread Euler Taveira
Hi, This simple patch improves a sentence. Spotted while working on translation. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento >From 7cae997155e222e0a8280018cccf717ab2ee1c38 Mon Sep 17 00:00

Re: [HACKERS] pltcl: sentence improvement

2015-09-16 Thread Euler Taveira
On 16-09-2015 10:57, Tom Lane wrote: Euler Taveira <eu...@timbira.com.br> writes: This simple patch improves a sentence. Spotted while working on translation. I concur that spelling out "#" as "number" is an improvement, but I'm curious which backend error you think

Re: [HACKERS] pg_resetxlog sentences

2015-09-17 Thread Euler Taveira
On 17-09-2015 00:25, Fujii Masao wrote: One relevant question is; why doesn't pg_controldata report newestCommitTs? I thought about it while looking at the code but forgot to ask. AFAICS it is an oversight. See attached patch. -- Euler Taveira Timbira - http

Re: [HACKERS] vacuumdb sentence

2015-09-17 Thread Euler Taveira
On 18-09-2015 00:59, Amit Kapila wrote: On Fri, Sep 18, 2015 at 8:30 AM, Euler Taveira <eu...@timbira.com.br <mailto:eu...@timbira.com.br>> wrote: > > Hi, > > Is there a reason to quote "jobs" at this sentence? > > 190 fprintf(stderr, _("%s: num

[HACKERS] vacuumdb sentence

2015-09-17 Thread Euler Taveira
ssage a few lines above (correctly) does not use quotes. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Improving test coverage of extensions with pg_dump

2015-09-20 Thread Euler Taveira
E command (emitted if a parameter was informed) during dump could handle it. BTW, last thread [1] about logical column ordering seems to have died a few months ago. Alvaro? [1] http://www.postgresql.org/message-id/20141209174146.gp1...@alvh.no-ip.org -- Euler Taveira Tim

Re: [HACKERS] WIP: About CMake v2

2015-11-26 Thread Euler Taveira
I think you don't understand the point: start with the *right* cmake version because you could have to redo (a lot of) your work or have your patch rejected because you don't follow our advice. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultori

Re: [HACKERS] What .gitignore files do in the tarball?

2015-11-25 Thread Euler Taveira
ngs to repository. If someone wants to develop a patch, we should advice him/her to use git. +1 to remove all of those files. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hac

Re: [HACKERS] WIP: About CMake v2

2015-11-26 Thread Euler Taveira
On 26-11-2015 07:33, YUriy Zhuravlev wrote: > On Thursday 26 November 2015 01:29:37 Euler Taveira wrote: >> I give it a try. Nice WIP. IMHO you should try to support cmake version >> that are available in the stable releases. Looking at [1], I think the >> best choi

Re: [HACKERS] WIP: About CMake v2

2015-11-25 Thread Euler Taveira
will cover Red Hat based distros and also Debian based ones). Are you using a new feature from 3.1? I mean, it should be nice to cover old stable releases, if it is possible. [1] https://cmake.org/Wiki/CMake_Life_Cycle_Considerations -- Euler Taveira Timbira - http://www.timbi

Re: [HACKERS] Parallel safety tagging of extension functions

2016-06-16 Thread Euler Taveira
gt; min(citext) > max(citext) > int_array_aggregate(int4) > rewrite(tsquery[]) > I don't think those functions are used a lot (as you said) to justify adding more code in 9.6. Let's not be in a hurry on something that can wait some months. -- Euler Taveira Ti

Re: [HACKERS] pg_upgrade vs vacuum_cost_delay

2016-06-16 Thread Euler Taveira
e run during downtime, so it seems like you'd > want those to run as fast as possible. > Doesn't --new-options do the job? -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgs

Re: [HACKERS] Raising the checkpoint_timeout limit

2016-02-01 Thread Euler Taveira
most common values I use for c_t). -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: h

Re: [HACKERS] get current log file

2016-02-24 Thread Euler Taveira
cumstances (and even discard some messages). -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] get current log file

2016-02-26 Thread Euler Taveira
patterns and you can also use syslog for it. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] get current log file

2016-02-26 Thread Euler Taveira
t; Those are good concerns. Also, we already have emit_log_hook that could grab server log messages. A small extension using the hook (there are some out there) could be use with a log consuming tool. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: C

Re: [HACKERS] [PATCH] fix DROP OPERATOR to reset links to itself on commutator and negator

2016-02-26 Thread Euler Taveira
ould be sufficient. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postg

Re: [HACKERS] [PATCH] fix DROP OPERATOR to reset links to itself on commutator and negator

2016-02-26 Thread Euler Taveira
nditional expression into a variable. + if (isDelete ? t->oprnegate == baseId : !OidIsValid(t->oprnegate)) It could be separate into a variable to be readable (or at least deserve a comment). (isDelete ? InvalidOid : ObjectIdGetDatum(baseId)) ... and this one too. It is used in 4 place

Re: [HACKERS] Add generate_series(date,date) and generate_series(date,date,integer)

2016-01-26 Thread Euler Taveira
On 26-01-2016 09:53, Michael Paquier wrote: > Something like the patch attached would be fine? This wins a backpatch > because the query continuously running eats memory, no? > +1. Although it breaks compatibility, a function that just eats resources is not correct. -- Eule

Re: [HACKERS] remove wal_level archive

2016-01-26 Thread Euler Taveira
. > 3. Add a WARNING at startup (until removal of values) saying something like "'archive' value is deprecated and will be removed in a future version. Use 'replica' value instead." -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Con

  1   2   3   4   5   >