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
OC
with LZ compression (that is already available in common).
I'll try to update the code and do some benchmarks.
[1] http://www.postgresql.org/message-id/4fd9698f.2090...@timbira.com
--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, De
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
.
>
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
20
minutes (those are the 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 change
ertain circumstances (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 su
logstash accepts 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 t
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
conditional
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
cluster, because they are just *logs*.
>
> ...and we also have "pg_logical", that includes a "log" keyword already...
>
"clog" and "xlog" is almost "log"; "logical" is not. I don't imagine
people confusing "
e 9.0) and could remove initdb.
Opinions?
--
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 subscript
under pg_ctl if the split
> above between instance-wide and db-specific holds.
>
I don't use it for a long time. It also a client-side binary then better
place for it is pg_command. BTW, is anybody using it? If so, we could
add this functionality to psql and remove it.
--
E
t Login roles does
> not exist. I think it's a bug? or at least a wrong error message
>
I'm not sure. I bet a dime that the role was created as "Iris" and you
are trying to assing "iris" (they are different). If you list the
roles, we can confirm that.
--
E
[1]
https://www.postgresql.org/message-id/3073cc9b0910051618t693d15f3u265872908240d...@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-
On 26-10-2016 12:43, Serge Rielau wrote:
> Posting to this group on a Friday evening was obviously a Bad Idea(tm). :-)
>
Serge, add your patch to the next commitfest [1] so we don't forget to
review it.
[1] https://commitfest.postgresql.org/11/
--
Euler Taveira
should be > otherwise >=.
There could be TAP tests for pg_recvlogical but it is material for
another patch.
I'll mark this patch waiting on author for your considerations.
--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desen
und
> protections are now enabled
>
It should be DEBUG1 as soon as 9.3 is deprecated.
> 2017-03-09 23:40:12.335 EST [19339] LOG: autovacuum launcher started
> 2017-03-09 23:40:12.336 EST [19341] LOG: logical replication launcher
> started
>
> +1 for DEBUG1.
--
Euler Tav
g or could be SET before query starts.
Start reading backend/optimizer/README.
--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postg
h/costsize.c.
--
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/ma
ostgresql.org/message-id/bdd1adb1-c26d-ad1f-2f15-cc5205606...@timbira.com.br
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
<http://www.timbira.com.br>
licates with a small script.
--
Euler Taveira Timbira - http://www.
timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
<http://www.timbira.com.br>
?
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
<http://www.timbira.com.br>
tead of the old coding.
>
Patch works fine. However, I don't see any documentation about supporting
different schemas for logical replication. Is it an oversight?
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvol
Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
<http://www.timbira.com.br>
From da4dc2807566958dd89cc9f05bf6a83a996e99c7 Mon Sep 17 00:00:00 2001
From: Euler Taveira
Date: Wed, 12 Apr 2017
2017-04-19 1:32 GMT-03:00 Michael Paquier :
> I vote for "location" -> "lsn". I would expect complains about the
> current inconsistency at some point, and the function names have been
> already changed for this release..
>
+1.
--
Euler Taveira
t;
Docs stated "Publications can choose to limit the changes they produce to
any combination of INSERT, UPDATE, and DELETE". It is clear that only those
DMLs are supported. However, we should mention that large objects are not
supported.
--
Euler Taveira
2017-06-16 11:03 GMT-03:00 Peter Eisentraut <
peter.eisentr...@2ndquadrant.com>:
>
>
> Some of that information was sprinkled around, but I have now added a
> new section that collects them all in one place. (section 31.4)
Shouldn't we mention that COPY is supported?
ld
provide an option to fire statement triggers during initial copy.
> By contrast, the normal apply worker does not fire any statement
> triggers (because they are not "statements").
>
> +1.
> We could adjust one or the other or leave it as is.
Let's leav
create a replication slot on remote
host as mentioned in section "Replication Slot Management". If we want to
maintain the message let's downgrade it to DEBUG1 (as we do with "create
implicit index for table") but I prefer to rip it out.
--
Euler Taveira
sible to create
extensions that prohibit query execution for certain users (see
sql_firewall [1] as an example).
[1] https://github.com/uptimejp/sql_firewall
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento,
saction.
>
> Is that possible?
>
> If so, can you please provide an example or point me into the right
> direction?
>
>
>
Take a look at BDR code (bdr_queue_ddl_commands and
bdr_queue_dropped_objects) [1]. It implements DDL replication too.
[1] https://github.com/2ndQuad
t slot_name = NONE for enabled subscription
bar=# alter subscription sub1 disable;
ALTER SUBSCRIPTION
bar=# drop subscription sub1;
ERROR: could not drop the replication slot "does_not_exist" on publisher
DETAIL: The error was: ERROR: replication slot "does_not_exist" does not
it for the next CF.
[1]
https://www.postgresql.org/message-id/CA%2Bmi_8bJ_uPr67j-6mbin537DVvfk%3DbOhmWneyBRfbZu89q0tw%40mail.gmail.com
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
<http://www.timbira.com.br>
);
skip (boolean): specifies that the command will not try to refresh table
information. The default is false.
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
<http://www.timbira.com.br>
rd in the command. That's the price we pay to avoid ambiguity that the
previous syntax had.At least I think Petr's proposal is less confusing than
mine (my proposal maintains current behavior but can cause some confusion).
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
<http://www.timbira.com.br>
, how many people would create real tables into information_schema?
Almost zero. Let's leave it alone. Since pg_dump doesn't document that
information_schema isn't dumped, I think we shouldn't document this for
logical replication.
--
Euler Taveira
efresh twice to disable).
It will cause confusion. It seems that WITH sets ALTER SUBSCRIPTION
properties. Indeed, they are REFRESH properties. I think we shouldn't
exclude REFRESH keyword. Syntax leaves no doubt that WITH are REFRESH
properties.
--
Euler Taveira
stted that we have a
ready-for-production plugin in core (besides pgoutput). It was
suggested [1] that I submit wal2json for 11. I'm in process to clean
up the code and hope to submit it to CF2.
[1] https://github.com/eulerto/wal2json
[2]
https://www.postgresql.org/message-id/CAHE3wggh6ucSCB%2Bh
ut to support more than one format
(like pglogical did AFAIR), however, we wouldn't reuse code (different
formats) and will have a fat plugin (I don't foresee a plugin using
different formats in the same connection. It is difficult to
coordinate a chang
+1. It could be
different from the last 3 passwords but we don't store a password
history.
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
--
Sent via pgsql-hackers mailing l
t all of the
logical decoding features (for example, origin filter) but it is in my
roadmap.
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
--
Sent via pgsql-hackers mailing list
#x27;t write an explicit question but I believe it was your doubt,
didn't it?
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
--
Sent via pgsql-hackers mailing list (pgsql-h
00,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000
(1 registro)
euler=#
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consulto
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
ler tables one after the other would safe overall execution time.
> Good point, I have 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/
Post
apping. I'll continue to polish this code.
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 (pg
.pgpass? You 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.
server version) in plain mode (the other modes already
include the desired info by default). In the past, 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.c
ds during the regular build was already discussed
> 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
> docu
ctions open. We've already set up an illogical
> and hard-to-troubleshoot situation where replication connections do not
> appear in pg_stat_activity, yet they are counted against max_connections.
>
Another situation is when you can't run pg_basebackup because automated
routines
factor to unify parallel code (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 Ta
e before size (for vacuum);
(ii) consider 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/
Post
ontroldata
sentence. 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:0
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
On 16-09-2015 10:57, Tom Lane wrote:
Euler Taveira 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 this matches?
It
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 -
e 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
On 18-09-2015 00:59, Amit Kapila wrote:
On Fri, Sep 18, 2015 at 8:30 AM, Euler Taveira mailto:eu...@timbira.com.br>> wrote:
>
> Hi,
>
> Is there a reason to quote "jobs" at this sentence?
>
> 190 fprintf(stderr, _("%s: number of parallel \&quo
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
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.
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'
. 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 24
ust one 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
throw a cold water 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@post
ption);
--
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
Date: Tue, 1 Sep 2015 23:52:55 -0300
Subject: [P
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
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
gular streaming
replication.
Reviewed-by: Michael Paquier
--
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 yo
thread 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
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
l. This ANALYZE-per-table
ranking 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
--
foo | 2012-03-01 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.c
27;re volunteering to
do it, please 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 on/true?
>
Please, don't 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: Consulto
mode? How would you
handle ON_ERROR_* 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:
trigger_file description
(informing a way to cleanup the file created) than 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
rom working).
>
Disable ALTER SYSTEM? No, thanks. Change the postgresql.auto.conf
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 p
a limited impact
> unless we get them on board with the idea.
>
In my experience, packagers tend 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
code 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
Date: Sun, 26 Apr 2
lso
advocate for 'pg_ctl -w') and (ii) disaster/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,
even 'kill'?
> 3. It's not clear that pg_ctl is necessarily the best way to start the
> server. 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
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.
f 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-hackers mailing li
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
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 choice is 2.
ons.
>
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/
Po
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 - T
gs or just a
subset 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, Desenvolv
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: Co
y auto_refresh=on? Also,
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://
s a feature not a bug. 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
viding a mechanism to cross-check 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
ou
didn't 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?
-
-memory map could store that
information to speed up the checks. The only downside I can see is that you
will increase the number of opened file descriptors.
> Ideas? Objections? Preferred options?
>
I prefer to attack 3, sort of 4 (explained in 5 -- in-memory map) and 5.
Out of curio
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
but is sufficiently 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
--
S
is too much work 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 Ol
cs for a long
period of time (say a few months) or your 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/
PostgreS
we're in or out 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
--
t tuple
according to the new minor version. Another option is document that that
version is the initdb'ed version.
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
--
Sent via pgsql-hac
1 - 100 of 441 matches
Mail list logo
