Re: [HACKERS] sql_implementation_info still contains old value

2012-10-25 Thread Euler Taveira
On 25-10-2012 21:05, David Johnston wrote: > If this is the case does pg_upgrade "init-db" for this purpose? > Yes. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent v

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

2012-05-09 Thread Euler Taveira
x27;ll break minor versions. IMHO 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.ti

Re: [HACKERS] Draft release notes complete

2012-05-12 Thread Euler Taveira
f my work, I 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, Su

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

2012-05-26 Thread Euler Taveira
ic) is a bit slower 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.803

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 Tavei

[HACKERS] libpq compression

2012-06-13 Thread Euler Taveira
29.php [2] http://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/ PostgreS

Re: [HACKERS] libpq compression

2012-06-14 Thread Euler Taveira
ions could be coded to cover a variety of algorithms without putting us in trouble because 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

Re: [HACKERS] libpq compression

2012-06-15 Thread Euler Taveira
the wheel but I see more drawbacks than benefits in adopting a SSL-based compression. I like 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 interestin

Re: [HACKERS] libpq compression

2012-06-15 Thread Euler Taveira
s. It really addresses 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

Re: [HACKERS] libpq compression

2012-06-15 Thread Euler Taveira
e're using SSL to do compression, if > we want to support it in a way that's not hackish. > That's exactly the complexity I wouldn't add 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)

Re: [HACKERS] libpq compression

2012-06-17 Thread Euler Taveira
pecific version or later in docs 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 Treinament

Re: [HACKERS] libpq compression

2012-06-17 Thread Euler Taveira
"DEFAULT" works with all openssl versions. > 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 p

Re: [HACKERS] libpq compression

2012-06-17 Thread Euler Taveira
it seems reasonable that > *either* side 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 --

Re: [HACKERS] libpq compression

2012-06-22 Thread Euler Taveira
way, we could implement another algorithms in such library without needing to modify libpq code. Using 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

Re: [HACKERS] libpq compression

2012-06-25 Thread Euler Taveira
lem. That's what I'm 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 24x

Re: [HACKERS] libpq compression

2012-06-25 Thread Euler Taveira
load, for example). If you implement decompression, why not code compression code too? -- 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)

Re: [HACKERS] libpq compression

2012-06-25 Thread Euler Taveira
+ SSL-based 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

Re: [HACKERS] libpq compression

2012-06-26 Thread Euler Taveira
nversely, 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

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

2012-07-07 Thread Euler Taveira
says "hey, I needed more 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 WALWriteLo

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

Re: [HACKERS] JSON decoding plugin

2013-12-09 Thread Euler Taveira
on datatype but decided that I wouldn't mess up with the backend code before have a feedback in the general idea. > *) Consider removing 'plugin ' from the name of the plugin. > --plugin=json_decoding etc. > 'plugin' was a tentative to produce an unique name (it suck

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

2013-12-11 Thread Euler Taveira
tp://www.postgresql.org/message-id/ca+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-ha

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

2013-12-23 Thread Euler Taveira
nal module or not. Opinions? [1] http://www.postgresql.org/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

Re: [HACKERS] move collation import to backend

2017-01-09 Thread Euler Taveira
wever, successive executions takes ~1200 ms. I'm attaching the complete and also a patch at the top of your last patch. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento diff --git a/doc/src/sg

Re: [HACKERS] Retiring from the Core Team

2017-01-12 Thread Euler Taveira
On 11-01-2017 21:29, Josh Berkus wrote: > For that reason, as of today, I am stepping down from the PostgreSQL > Core Team. > Thanks for your hard work! Your contributions were very important and valuable for community growth. I'm sure you will continue to advocate PostgreSQL.

Re: [HACKERS] [PATCH] Rename pg_switch_xlog to pg_switch_wal

2017-01-12 Thread Euler Taveira
ecided to clean up this code. Let's do it smoothly. As Robert suggested in the other email: extension to create old names. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql

Re: [HACKERS] Logical Replication WIP

2017-01-15 Thread Euler Taveira
use case is almost zero. Of course, it should be documented. Also, if someone wants to replicate an information schema table, it could do it with ALTER PUBLICATION. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 2

Re: [HACKERS] Logical Replication and Character encoding

2017-02-01 Thread Euler Taveira
t flexible with conversion routines. -- 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

Re: [HACKERS] s/xlog/wal/ in tools and function names?

2016-12-02 Thread Euler Taveira
ceive_location > pg_last_xlog_replay_location > pg_is_xlog_replay_paused > pg_switch_xlog > pg_xlog_replay_pause > pg_xlog_replay_resume > (12 rows) > In those cases, let's keep the functions as wrappers and undocumented. In a few releases, we could remove the

Re: [HACKERS] ALTER SYSTEM for pg_hba.conf

2017-01-05 Thread Euler Taveira
ess we stick with a default value that could not be a good idea in the security pov). -- 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

Re: [HACKERS] what to revert

2016-05-03 Thread Euler Taveira
"around" the walsender and > share more of the logic between the code paths. > Question is: is the actual code so useless that it can't even be a 1.0 release? A lot of (complex) features were introduced with the notion that will be improved in the next version. However, if the cod

[HACKERS] minor message improvement

2016-05-07 Thread Euler Taveira
file exists" Attached is a patch that turn it into one. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento diff --git a/src/backend/access/transam/xlog.c b/src/backend/access/transam/xlog.c in

Re: [HACKERS] Accurate list of Keywords / Datatypes?

2016-05-07 Thread Euler Taveira
On 07-05-2016 22:53, Robins Tharakan wrote: > Should I be looking somewhere else? Parse keywords from Git Source file > (if so where)? Parse PG Documentation? > src/include/parser/kwlist.h -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Co

Re: [HACKERS] Patch for German translation

2016-05-09 Thread Euler Taveira
gsql-translators [2] to send corrections / translations. [1] http://git.postgresql.org/gitweb/?p=pgtranslation/messages.git;a=summary [2] http://www.postgresql.org/list/pgsql-translators/ -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento

Re: [HACKERS] Does Type Have = Operator?

2016-05-10 Thread Euler Taveira
ragile. You could also try oprname, oprrest or oprjoin but the result is worse than the former solution. You definitely need a hack. Also, IS DISTINCT FROM is an alias for = operator per standard IIRC. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultori

Re: [HACKERS] alter table alter column ... (larger type) ... when there are dependent views

2016-05-10 Thread Euler Taveira
xecAlterColumnType(). It is a hack and must be done with care. -- 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 t

Re: [HACKERS] Does Type Have = Operator?

2016-05-10 Thread Euler Taveira
6 |6 | t| t 6 | NULL | f| NULL NULL |3 | f| NULL NULL |6 | f| NULL NULL | NULL | t| NULL (9 rows) -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

Re: [HACKERS] Accurate list of Keywords / Datatypes?

2016-05-10 Thread Euler Taveira
On 10-05-2016 22:22, David G. Johnston wrote: > I don't know how the docs, this function, and the source code relate to > each other. > Function is built around ScanKeywords structure which in turn is built using parser/kwlist.h. -- Euler Taveira

Re: [HACKERS] [PATCH] Add EXPLAIN (ALL) shorthand

2016-05-21 Thread Euler Taveira
tion defaults, I'm all ears. -- 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] 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
wing server log 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@pos

[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] 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

Re: [HACKERS] pg_upgrade vs vacuum_cost_delay

2016-06-16 Thread Euler Taveira
Those 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 -

Re: [HACKERS] to_date_valid()

2016-07-02 Thread Euler Taveira
#x27;t you add a third parameter (say, validate = true | false) instead of creating another function? The new parameter could default to false to not break compatibility. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Supo

Re: [HACKERS] Is this a bug?

2014-03-13 Thread Euler Taveira
eral, I'm in favor 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, Desenvo

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

2014-03-27 Thread Euler Taveira
+ (we can live with that). If we agree to remove d_w_o, don't worry with that line because it will be removed soon. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers

Re: [HACKERS] pg_shmem_allocations view

2014-05-04 Thread Euler Taveira
_allocations to > pg_shmem_allocations. > ... or another boolean column (say 'dynamic') and just one view. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-hackers

[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
rm seems pretty low and the additional > tests would cover 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:

[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 F

Re: [HACKERS] Changeset Extraction v7.6.1

2014-06-01 Thread Euler Taveira
ption if you want to copy *part* of the database(s) (unless you have space available and want to do the cleanup after upgrade). In a near future, a (new) tool could do (a) copy schema, (b) accumulate modifications while copying data, (c) copy whole table and (d) apply modifications for selected t

Re: [HACKERS] xlog location arithmetic

2012-01-21 Thread Euler Taveira de Oliveira
I couldn't. I attached another patch that implements pg_size_pretty(numeric). -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 4863

Re: [HACKERS] Patch pg_is_in_backup()

2012-01-30 Thread Euler Taveira de Oliveira
your patch to the next CF. -- 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.pos

Re: [HACKERS] Patch pg_is_in_backup()

2012-02-02 Thread Euler Taveira de Oliveira
ackup copies are running. As about returning the backup timestamp, we could return an array like array[['label_1', '2012-01-28 02:00:01 BRST'], ['label_2', '2012-01-28 03:40:34 BRST']] or NULL if none. -- Euler Taveira de Oliveira - Timbira h

Re: [HACKERS] xlog location arithmetic

2012-02-07 Thread Euler Taveira de Oliveira
etty(numeric). It is slower than the former but it is not a performance critical function. > According to the above source code comment in pg_proc.h, ISTM > pg_size_pretty() for numeric also needs to have its own DESCR(). > Fixed. > According to "man strcat", the dest stri

Re: [HACKERS] xlog location arithmetic

2012-02-09 Thread Euler Taveira de Oliveira
#x27;ll not attach another version for pg_size_pretty because it is a matter of updating a duplicated OID. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/f

Re: [HACKERS] wal_buffers

2012-02-19 Thread Euler Taveira de Oliveira
t;wrap around"? In this case, we have an idea that wal_buffers needs to be increased. -- 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@po

Re: [HACKERS] temporal algebra and data type

2012-02-22 Thread Euler Taveira de Oliveira
g/docs/devel/static/rangetypes.html -- 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.post

Re: [HACKERS] xlog location arithmetic

2012-02-25 Thread Euler Taveira de Oliveira
something obvious? > sscanf() is too fragile for input sanity check. Try pg_xlog_location_diff('12/3', '-10/0'), for example. I won't object removing that function if you protect xlog location input from silly users. -- Euler Taveira de Oliveira - Timbira

Re: [HACKERS] LIST OWNED BY...

2012-02-29 Thread Euler Taveira de Oliveira
On 29-02-2012 14:20, Thom Brown wrote: > No, the cascade part is fine. It's the objects which won't cause a > cascade that are an issue. Putting it in a transaction for rolling > back doesn't help find out what it intends to drop. > DROP OWNED BY foo VERBOSE? --

Re: [HACKERS] LIST OWNED BY...

2012-02-29 Thread Euler Taveira de Oliveira
On 29-02-2012 15:23, Thom Brown wrote: > Or just change it to output a verbose notice without changing the syntax? > I can't see why we will do it only for DROP OWNED. Chat messages are annoying unless the user asks for it (that's why I suggested VERBOSE). -- Euler Tav

Re: [HACKERS] Patch: improve selectivity estimation for IN/NOT IN

2012-03-04 Thread Euler Taveira de Oliveira
; We don't normally add new features to stable branches unless it is a bug. In the optimizer case, planner regression is a bug (that this case is not). -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e

Re: [HACKERS] Hi- How frequently Postgres Poll for trigger file

2010-12-01 Thread Euler Taveira de Oliveira
that a signal doesn't wake up a process, so I suggest (ii) but I'm fine to include (i) at docs too. Comments? [1] http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=723d0184e2972f21db0f85feef3d35f0cb9b3298 -- Euler Taveira de Oliveira http://www.timbira.com/

Re: [HACKERS] To Signal The postmaster

2010-12-07 Thread Euler Taveira de Oliveira
aaliya zarrin escreveu: > I want to signal the postmaster (User defined signal) once I created the > trigger file (for switch over). > Send a SIGHUP to postmaster. Have in mind that it doesn't work on all supported platforms. -- Euler Taveira de Oliveira http://www.timbira.

Re: [HACKERS] pg_streamrecv for 9.1?

2010-12-29 Thread Euler Taveira de Oliveira
fulfill people's desire that claim an easy replication setup. IIRC, Dimitri already coded a base backup over libpq tool [1] but it is written in Python. [1] https://github.com/dimitri/pg_basebackup/ -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers ma

Re: [HACKERS] Fixing GIN for empty/null/full-scan cases

2011-01-06 Thread Euler Taveira de Oliveira
Em 06-01-2011 21:31, Tom Lane escreveu: I think I like option #2 better. Comments? +1. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] system views for walsender activity

2011-01-10 Thread Euler Taveira de Oliveira
an states (in normal scenarios). -- Euler Taveira de Oliveira http://www.timbira.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] [PERFORM] pgbench to the MAXINT

2011-01-11 Thread Euler Taveira de Oliveira
Em 10-01-2011 05:25, Greg Smith escreveu: Euler Taveira de Oliveira wrote: Em 07-01-2011 22:59, Greg Smith escreveu: setrandom: invalid maximum number -2147467296 It is failing at atoi() circa pgbench.c:1036. But it just the first one. There are some variables and constants that need to be

Re: [HACKERS] Named restore points

2011-01-14 Thread Euler Taveira de Oliveira
y point as '1234567' (xid) or '2011-01-14' (I use this format a lot) and (ii) if the suffix name is *_name* it shouldn't allow xid and time. IMHO, recovery_target_name should allow only names. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-

Re: [HACKERS] Per-column collation, the finale

2011-01-14 Thread Euler Taveira de Oliveira
h. I personally would like to eyeball his patch (but it will be during the week). -- Euler Taveira de Oliveira http://www.timbira.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] Named restore points

2011-01-14 Thread Euler Taveira de Oliveira
Em 14-01-2011 19:50, Jaime Casanova escreveu: On Fri, Jan 14, 2011 at 5:42 PM, Euler Taveira de Oliveira wrote: Em 14-01-2011 17:41, Jaime Casanova escreveu: Here is a patch that implements "named restore points". Nice feature. I only read the provided documentation an

Re: [HACKERS] pg_basebackup for streaming base backups

2011-01-15 Thread Euler Taveira de Oliveira
't be hard to do..) +1. -- Euler Taveira de Oliveira http://www.timbira.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] reviewers needed!

2011-01-16 Thread Euler Taveira de Oliveira
t mark it "ready for committer" instead leave it as is ("needs review"); just be sure to add your comments in the commitfest app. [1] http://wiki.postgresql.org/wiki/RRReviewers -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing

Re: [HACKERS] pg_dump directory archive format / parallel pg_dump

2011-01-21 Thread Euler Taveira de Oliveira
Em 21-01-2011 12:47, Andrew Dunstan escreveu: Maybe we could change the hint to say "--file=DESTINATION" or "--file=FILENAME|DIRNAME" ? ... "--file=OUTPUT" or "--file=OUTPUTNAME". -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via p

Re: [HACKERS] [PATCH] Output configuration status after ./configure run.

2010-02-10 Thread Euler Taveira de Oliveira
Alvaro Herrera escreveu: > The general idea seems sensible to me. I can't comment on the > specifics. > +1. A lot of other programs have this summary at the end of configure execution. The problem is that PostgreSQL has too many options. Do we want to list all of them? -- Eu

Re: [HACKERS] [PATCH] Output configuration status after ./configure run.

2010-02-10 Thread Euler Taveira de Oliveira
w beforehand what are the default configure options. Of course, parsing the configure output and greping the interested options is a boring task but at least it is all there; but it's not a summary. :( -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hacke

Re: [HACKERS] Postgres Triggers issue

2010-02-10 Thread Euler Taveira de Oliveira
w us the definition of m_a, temp_m_t, and related tables? -- Euler Taveira de Oliveira http://www.timbira.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] Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL

2010-02-11 Thread Euler Taveira de Oliveira
ke the %s idea. IMHO fixing pg_standby for SR is a must-fix. I'm foreseeing a lot of users asking why pg_standby doesn't work on SR mode ... -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make chan

Re: [HACKERS] psql tab completion for DO blocks

2010-02-11 Thread Euler Taveira de Oliveira
Takahiro Itagaki escreveu: > Should we fix the documentation when we add the tab completion? > Yes, it seems consistent with other commands having optional parameters in the middle of the command rather than at the end. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Se

Re: [HACKERS] psql tab completion for DO blocks

2010-02-11 Thread Euler Taveira de Oliveira
_name ] | code } ... -- Euler Taveira de Oliveira http://www.timbira.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] Hostnames in pg_hba.conf

2010-02-11 Thread Euler Taveira de Oliveira
Mark Mielke escreveu: > Of course, then I'll ask for the ability to simplify specifying multiple > databases: > We already support multiple users and/or databases for a single pg_hba.conf line ... -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hacker

Re: [HACKERS] TCP keepalive support for libpq

2010-02-12 Thread Euler Taveira de Oliveira
Marko Kreen escreveu: > 3) Support all 3 parameters (keepidle, keepintvl, keepcnt) > and ignore parameters not supported by OS. > +1. AFAIR, we already do that for the backend. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsq

Re: [HACKERS] TCP keepalive support for libpq

2010-02-15 Thread Euler Taveira de Oliveira
Fujii Masao escreveu: > Here is the patch which provides those three parameters as conninfo > options. Should this patch be added into the first CommitFest for v9.1? > Go ahead. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsq

Re: [HACKERS] TCP keepalive support for libpq

2010-02-15 Thread Euler Taveira de Oliveira
Magnus Hagander escreveu: > If we want to do this, I'd be inclined to say we sneak this into 9.0.. > It's small enough ;) > I'm afraid Robert will say a big NO. ;) I'm not against your idea; so if nobody objects go for it *now*. -- Euler Taveira de Oliv

Re: [HACKERS] Problem with 8.4 stats collector high load

2010-02-16 Thread Euler Taveira de Oliveira
clues what does it cause and how to investigate it? > OProfile? -- Euler Taveira de Oliveira http://www.timbira.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] PGXS: REGRESS_OPTS=--load-language=plpgsql

2010-02-18 Thread Euler Taveira de Oliveira
ed. Besides we could patch pg_regress.c to ignore loading plpgsql language into the database (instead of adding another parameter -- we already have too many options). -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) T

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

2010-09-27 Thread Euler Taveira de Oliveira
Itagaki Takahiro escreveu: > I had the same problems before, and I wrote some hacks for VC++. > Isn't there such a code in core or am i missing something? Is it worth supporting the VC++ standalone projects? -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pg

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

2010-09-28 Thread Euler Taveira de Oliveira
Magnus Hagander escreveu: > We might, however, want to add a specific section to the > *documentation* about building extensions on Windows. > +1. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make c

[HACKERS] external pid file

2010-09-29 Thread Euler Taveira de Oliveira
Hi, Is there any reason the postmaster.pid and external_pid_file contents to be different? -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] create custom collation from case insensitive portuguese

2010-11-02 Thread Euler Taveira de Oliveira
rg/pgsql-hackers/2010-07/msg00512.php -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] pg_ctl init doc bug

2010-11-09 Thread Euler Taveira de Oliveira
oking at the manual but the -o option only accept initdb options so I think there is a documentation bug. Patch is attached. While at it, is it worth adding a pg_ctl init example? -- Euler Taveira de Oliveira http://www.timbira.com/ diff --git a/doc/src/sgml/ref/pg_ctl-ref.sgml b/doc/src/

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Euler Taveira de Oliveira
27;make world' is not the answer. There is not an option for "install all pieces of software". Let's install pg+contrib and leave only 'CREATE EXTENSION foo' for the admins. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: C

Re: [HACKERS] Debug contrib/cube code

2011-05-06 Thread Euler Taveira de Oliveira
need to change the code to achieve what you want. -- 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

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Euler Taveira de Oliveira
. > I'm in favor of find out what are the popular extensions and make them into "base"; the other ones could be moved to PGXN. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento --

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-07 Thread Euler Taveira de Oliveira
Em 07-05-2011 13:42, Peter Eisentraut escreveu: Do you need pg_config to install extensions? No. But we need it to build other extensions. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent

[HACKERS] tuning autovacuum

2011-06-08 Thread Euler Taveira de Oliveira
me to split autovacuum information into another statistic view? Comments? -- 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

Re: [HACKERS] tuning autovacuum

2011-06-08 Thread Euler Taveira de Oliveira
r counters easier to implement and simpler to analyze. But the timestamp idea has its merit because we already have a similar statistic (last timestamp table was vacuumed or analyzed). -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvim

Re: [HACKERS] Named restore points

2011-02-01 Thread Euler Taveira de Oliveira
ting on author because of those open issues. This patch needs to bump catalog version because of the new function. I'm not sure if the new record type requires bumping the xlog magic number. I'm attaching the updated patch and two scripts that I used to play with the patch.

Re: [HACKERS] 64-bit pgbench V2

2011-02-06 Thread Euler Taveira de Oliveira
Em 06-02-2011 13:09, Bruce Momjian escreveu: What happened to this idea/patch? I refactored the patch [1] to not depend on strtoll. [1] http://archives.postgresql.org/message-id/4d2cccd9@timbira.com -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers

<    1   2   3   4   5   >