On 24/04/18 13:57, Kyotaro HORIGUCHI wrote:
At Mon, 23 Apr 2018 03:41:47 -0400, Heikki Linnakangas wrote in
<89e33d4f-5c75-0738-3dcb-44c4df59e...@iki.fi>
Looking at the patch linked above
(https://www.postgresql.org/message-id/20171026.190551.208996945.horiguchi.kyotaro%40lab.ntt.co.jp):
---
> "Aleksandr" == Aleksandr Parfenov writes:
Aleksandr> The idea of the fix for this situation is to check is a
Aleksandr> result of the function constant or not during the planning
Aleksandr> of the query. Attached patch does this by processing Var
Aleksandr> entries at planner stage and
Thanks to everyone, v3 is pushed.
Teodor Sigaev wrote:
I don't very happy with rootBuffer added everywhere. ginInsertItemPointers()
and ginPrepareDataScan() now take both args, rootBlkno and rootBuffer,
second could be invalid. As I can see, you did it to call
CheckForSerializableConflictIn(
Hello Vladimir,
>> Personally I think raw data bytes are OK if functions for getting all
>> keys and values from this data are provided
>
> What is the purpose of using Thrift "encoding" if it turns out to be a
> simple wrapper for existing binary data?
>
> Do you mean the goal is to have "get/s
On 03.05.2018 20:01, Robert Haas wrote:
On Fri, Apr 27, 2018 at 4:43 PM, Merlin Moncure wrote:
What _I_ (maybe not others) want is a
faster pgbouncer that is integrated into the database; IMO it does
everything exactly right.
I have to admit that I find that an amazing statement. Not that
p
> 4 мая 2018 г., в 0:37, Robert Haas написал(а):
>
> On Wed, May 2, 2018 at 3:06 PM, Vladimir Sitnikov
> wrote:
>> Sample output can be seen here:
>> https://github.com/vlsi/pgsqlstat/tree/pgsqlio#pgsqlio
>
> Neat. Not sure what generated this trace, but note this part:
>
> 3271838881374
Hello everyone in this thread!
I got a similar server crash as in [1] on the master branch since the
commit 9fdb675fc5d2de825414e05939727de8b120ae81 when the assertion fails
because the second argument ScalarArrayOpExpr is not a Const or an
ArrayExpr, but is an ArrayCoerceExpr (see [2]):
=#
Thank you, pushed.
Peter Geoghegan wrote:
I noticed that we're calling _bt_nonkey_truncate() needlessly when a
minimum key is needed at the leftmost page on each level of the tree.
This was always a special case, and I think that it should remain as
one. Attached patch avoids unneeded truncation
>I mean Charles is free to choose the interface for the extension he
believes is right
I'm just trying to figure out what are the use cases for using that Thrift
extension.
For instance, it would be interesting if Thrift was an alternative way to
transfer data between client and the database. I g
Currently pg_rewind copies all files including postgresql.conf. It
would be nice if pg_rewind has an option to not copy
postgresql.conf. I sometimes create multiple PostgreSQL database
clusters with different port number which postmaster is listening on
for a testing purpose. So existing postgresql
пт, 4 мая 2018 г., 12:27 Andrey Borodin :
>
> > 4 мая 2018 г., в 0:37, Robert Haas написал(а):
> >
> > On Wed, May 2, 2018 at 3:06 PM, Vladimir Sitnikov
> > wrote:
> >> Sample output can be seen here:
> >> https://github.com/vlsi/pgsqlstat/tree/pgsqlio#pgsqlio
> >
> > Neat. Not sure what genera
Hello Vladimir,
> I'm just trying to figure out what are the use cases for using that Thrift
> extension.
You can find an answer in the project description:
https://wiki.postgresql.org/wiki/GSoC_2018#Thrift_datatype_support_.282018.29
--
Best regards,
Aleksander Alekseev
signature.asc
Descri
>I don't have time to check this out just now, but it seems like an
excellent idea
There are a couple of sad things:
1) DTrace probes seem to be disabled by default. At least, I had to build
PostgreSQL with --enable-dtrace in my macOS.
Does that (the requirement to enable dtrace within PostgreSQL)
On 5/4/18, Tom Lane wrote:
> Well, the work's already done, and personally I think the code is
> cleaner after 9bf28f96c and bad51a49a regardless of whether there's any
> performance benefit. You could call 1f1cd9b5d a wart if you wanted.
> But we've done largely the same thing to pgindent, for o
On Mon, Apr 2, 2018 at 5:12 AM, Alexander Lakhin wrote:
> Is it a supported scenario to make installcheck-world without performing
> "make" first?
The evidence suggests that the answer is "no".
> (If I do "make -C src/interfaces/ecpg" and then "make installcheck-world",
> then this error is gone
On Fri, May 4, 2018 at 12:59 PM, Tatsuo Ishii wrote:
> Currently pg_rewind copies all files including postgresql.conf. It
> would be nice if pg_rewind has an option to not copy
> postgresql.conf. I sometimes create multiple PostgreSQL database
> clusters with different port number which postmaste
Would it work to use ALTER SYSTEM (postgresql.auto.conf)? Or is that copied
by pg_rewind also?
Even if so, using the ALTER SYSTEM command after pg_rewind might be an easy
way of correcting the port back to what you want without doing more
complicated processing or re-writing the entire postgresql.
On Fri, May 4, 2018 at 2:06 PM, Isaac Morland
wrote:
> Would it work to use ALTER SYSTEM (postgresql.auto.conf)? Or is that
> copied by pg_rewind also?
>
Yes that is copied currently by pg_rewind, as are server logs if they are
in the data directory. I think replication slots also might be copi
04.05.2018 14:58, Robert Haas wrote:
Thanks for your involvement!
Your proposed fix involves inventing something called
USE_INSTALLED_ASSETS, but we don't need that anywhere else, so why do
we need it for ECPG?
We need that not only for ECPG, but for libpostgres, libpgport, and
libpq too, if w
On Fri, May 04, 2018 at 02:10:46PM +0200, Chris Travers wrote:
> Yes that is copied currently by pg_rewind, as are server logs if they are
> in the data directory.
Yes, that is valid for all the existing versions of pg_rewind in the
core tree, as well as what I maintain for VMware (9.3 and 9.4
ver
## Tatsuo Ishii (is...@sraoss.co.jp):
> Currently pg_rewind copies all files including postgresql.conf. It
> would be nice if pg_rewind has an option to not copy
> postgresql.conf.
How about including a file outside the data directory with "local"
settings? Like "include /some/where/else/local.co
On Fri, May 04, 2018 at 02:05:25PM +0200, Chris Travers wrote:
> I totally agree. Ideally, rewind would just rewind data dirs by default
> and provide an option to include other files as specified by the
> administrator.
That's actually a potential please-shoot-both-my-feet option. Imagine
if on
Hello hackers,
Recently I was working with sql arrays in postgres and it turned out
that postgres doesn't have such very convinient functional constructions
as map, reduce and filter. Currently to map function over array user has
to make a subquery like:
select u.* from
my_table,
> Even if so, using the ALTER SYSTEM command after pg_rewind might be an easy
> way of correcting the port back to what you want without doing more
> complicated processing or re-writing the entire postgresql.conf.
To make ALTER SYSTEM works, the server needs to start up in the first
place. But wi
> I totally agree. Ideally, rewind would just rewind data dirs by default
> and provide an option to include other files as specified by the
> administrator.
Something like "--copy-including-files=file1,file2,..."? However I
would like to also have "--copy-excluding-files=". The latter would be
m
On Fri, May 04, 2018 at 12:47:09AM -0400, Mike Palmiotto wrote:
> I don't seem to have any problem catching the SIGHUP in my extension
> without > BackgroundWorkerUnblockSignals a la:
>
> pqsignal_sighup(SIGHUP, sighup_handler);
I am pretty sure you mean s/pqsignal_sighup/pqsignal/.
> static voi
On 4/10/18 12:40, Peter Eisentraut wrote:
> A report from a pgbouncer user revealed that running pg_dump -C/--create
> does not work through a connection proxy if the virtual database name on
> the proxy does not match the real database name on the database server.
> That's because pg_dump looks up
On Thu, May 03, 2018 at 08:45:13AM -0400, Peter Eisentraut wrote:
> I went with the patch I had posted, since I needed to move ahead with
> something. If it turns out to be a problem, we can easily switch it
> around.
Okay.
> As Tom mentioned, in order to grow the SPI stack to where it has a
> s
On Thu, May 03, 2018 at 08:40:49PM +0200, Christoph Berg wrote:
> [*] I haven't checked, but this likely applies to Michael Paquier's
> version of it as well
Confirmed. That applies as well.
--
Michael
signature.asc
Description: PGP signature
Greetings,
* Aleksander Alekseev (a.aleks...@postgrespro.ru) wrote:
> >> Personally I think raw data bytes are OK if functions for getting all
> >> keys and values from this data are provided
> >
> > What is the purpose of using Thrift "encoding" if it turns out to be a
> > simple wrapper for exi
Hello all
I want propose patch to make possible change primary_conninfo,
primary_slot_name, restore_command and trigger_file in recovery.conf without
restart postgresql.
Startup process will reread recovery.conf on SIGHUP.
My primary usecase is postgresql cluster with streaming replication. When
On Fri, May 04, 2018 at 05:19:26PM +0300, Sergei Kornilov wrote:
> I did not find previous discussions.
There have been a lot of discussions across the years about switching
recovery parameters to use the GUC infrastructure, please see those
two ones:
https://www.postgresql.org/message-id/CABUevEy
Earlier this week I pushed tzdata 2018d into our tree, expecting that
that would be the current IANA timezone data for next week's releases.
Well, I was wrong; today they pushed out a new version:
https://mm.icann.org/pipermail/tz-announce/2018-May/50.html
on account of North Korea deciding t
Hello Michael
Thank you, i understand your opinion.
I really tried to find a discussion about reload recovery.conf (or walreceiver
conninfo changing and similar stuff), not about GUC.
regards, Sergei
On 05/04/2018 09:35 AM, Michael Paquier wrote:
> On Fri, May 04, 2018 at 12:47:09AM -0400, Mike Palmiotto wrote:
>> I don't seem to have any problem catching the SIGHUP in my extension
>> without > BackgroundWorkerUnblockSignals a la:
>>
>> pqsignal_sighup(SIGHUP, sighup_handler);
>
> I am pretty
On Thu, May 3, 2018 at 12:01 PM, Robert Haas wrote:
> On Fri, Apr 27, 2018 at 4:43 PM, Merlin Moncure wrote:
>> What _I_ (maybe not others) want is a
>> faster pgbouncer that is integrated into the database; IMO it does
>> everything exactly right.
>
> I have to admit that I find that an amazing
Hello Stephen,
> Perhaps the design decisions aren't all made beforehand, but they also
> shouldn't be made in a vacuum- there should be discussions on -hackers
> about what the right decision is for a given aspect and that's what
> should be worked towards.
+1, agree.
> > Personally I would pr
Greetings,
* Aleksander Alekseev (a.aleks...@postgrespro.ru) wrote:
> > I understand that you're open to having it as a new data type or as a
> > bytea, but I don't agree. This should be a new data type, just as json
> > is a distinct data type and so is jsonb.
>
> Could you please explain in a
Hi,m
On 2018-05-04 10:58:22 -0400, Tom Lane wrote:
> On balance I'm leaning towards option #2, ie go with the new data but
> wait till just after the minor releases. Thoughts?
+1. Should have a beta in that timeframe as well, giving more people a
chance to notice.
Greetings,
Andres Freund
On Wed, May 2, 2018 at 11:37 AM, Adrien Nayrat
wrote:
> In 9.6 gather node reports sum of buffers for main process + workers. In 10,
> gather node only reports buffers from the main process.
Oh, really? Well, that sounds like a bug. Amit seems to think it's
expected behavior, but I don't know w
On Fri, May 4, 2018 at 2:39 AM, Teodor Sigaev wrote:
> Thank you, pushed.
Thanks.
--
Peter Geoghegan
Hi,
Now that there's several tools used during compilation that can benefit
from ccache I wonder if it's time to add an option to configure for
setting up ccache across the board.
ISTM --enable-ccache would simplify setup for a number of people? And it
shouldn't be hard to implement.
Greetings,
On Thu, May 3, 2018 at 5:25 PM, Andrew Dunstan
wrote:
> I've been getting an Msys2 environment working, and will soon document
> how to build with this environment. There are several nice things
> about it, including a modern version of perl and proper support for
> the mingw-w64 compilers.
>
> So
Hi,
Currently there's no convenient way to get a corrupted page (be it a
checksum failure, corrupted pd_upper/lower or whatnot) via pageinspect's
get_raw_page(). Given that pageinspect is kind of our tool to do inspect
issues on a data level that's not so great.
I therefore propose that we add an
On Fri, May 4, 2018 at 11:41 AM, Andres Freund wrote:
> Hi,
>
> Currently there's no convenient way to get a corrupted page (be it a
> checksum failure, corrupted pd_upper/lower or whatnot) via pageinspect's
> get_raw_page(). Given that pageinspect is kind of our tool to do inspect
> issues on a d
On 2018-05-04 11:42:35 -0700, Peter Geoghegan wrote:
> On Fri, May 4, 2018 at 11:41 AM, Andres Freund wrote:
> > Hi,
> >
> > Currently there's no convenient way to get a corrupted page (be it a
> > checksum failure, corrupted pd_upper/lower or whatnot) via pageinspect's
> > get_raw_page(). Given t
On Fri, May 4, 2018 at 11:46 AM, Andres Freund wrote:
> Could you expand on that? Are you envisioning an option to
> ReadBufferExtended()? Because that's certainly not what I'm thinking of
> - it seems dangerous to populate shared buffers with an invalid
> page. Therefore I was more thinking to fa
On 2018-05-04 11:53:25 -0700, Peter Geoghegan wrote:
> On Fri, May 4, 2018 at 11:46 AM, Andres Freund wrote:
> > Could you expand on that? Are you envisioning an option to
> > ReadBufferExtended()? Because that's certainly not what I'm thinking of
> > - it seems dangerous to populate shared buffer
On Tue, May 1, 2018 at 5:02 PM, Stas Kelvich wrote:
> Yes, that totally possible. On both systems you need:
Cool.
> * set track_global_snapshots='on' -- this will start writing each
> transaction commit sequence number to SRLU.
> * set global_snapshot_defer_time to 30 seconds, for example -- t
On Fri, May 4, 2018 at 11:22 AM, Merlin Moncure wrote:
> If we are breaking 1:1 backend:session relationship, what controls
> would we have to manage resource consumption?
I mean, if you have a large number of sessions open, it's going to
take more memory in any design. If there are multiple ses
Hackers,
There are not yet any examples in the postgres sources where this
oversight causes problems, but in genbki.pl, where it makes the
decision whether to quote a token:
# Quote value if needed. We need not quote values that satisfy
# the "id" pattern in bootscanner.l, curren
Hi,
The Release Management Team is pleased to announce that
the release date for PostgreSQL 11 Beta 1 is set to be 2018-05-24.
We’re excited to make the Beta available for testing and receive
some early feedback around the latest major release of PostgreSQL.
Please let us know if you have any qu
Pavan Deolasee wrote:
> I wonder if we should just avoid initialising those variables at the top
> and take compiler's help to detect any missed branches. That way, we shall
> know exactly why and where we are making them true/false. I also think that
> we should differentiate between scenarios wh
On Fri, May 4, 2018 at 1:58 PM, Andres Freund wrote:
> Hi,
>
> Now that there's several tools used during compilation that can benefit
> from ccache I wonder if it's time to add an option to configure for
> setting up ccache across the board.
>
> ISTM --enable-ccache would simplify setup for a num
On Fri, May 4, 2018 at 2:30 PM, Robert Haas wrote:
> On Thu, May 3, 2018 at 5:25 PM, Andrew Dunstan
> wrote:
>> I've been getting an Msys2 environment working, and will soon document
>> how to build with this environment. There are several nice things
>> about it, including a modern version of pe
On 2018-05-04 17:04:38 -0400, Andrew Dunstan wrote:
> On Fri, May 4, 2018 at 1:58 PM, Andres Freund wrote:
> > Hi,
> >
> > Now that there's several tools used during compilation that can benefit
> > from ccache I wonder if it's time to add an option to configure for
> > setting up ccache across th
On Fri, May 4, 2018 at 5:07 PM, Andres Freund wrote:
> On 2018-05-04 17:04:38 -0400, Andrew Dunstan wrote:
>> On Fri, May 4, 2018 at 1:58 PM, Andres Freund wrote:
>> > Hi,
>> >
>> > Now that there's several tools used during compilation that can benefit
>> > from ccache I wonder if it's time to a
Andres Freund wrote:
> > On Fri, May 4, 2018 at 1:58 PM, Andres Freund wrote:
> > > ISTM --enable-ccache would simplify setup for a number of people? And it
> > > shouldn't be hard to implement.
> >
> > What exactly would it do? I use ccache all the time, have for years,
> > but it's not clear
Moving discussion to -hackers list.
Mike Blackwell wrote:
> I didn't see a .perlcriticrc file in the project, so ran with our local
> settings.
>
> With those, perlcritic is pretty unhappy, even at -4, though I don't see
> anything that pops out as potentially bug-inducing.
Uh, we've certainly f
On Fri, May 4, 2018 at 2:25 PM, Robert Haas wrote:
> On Fri, May 4, 2018 at 11:22 AM, Merlin Moncure wrote:
>> If we are breaking 1:1 backend:session relationship, what controls
>> would we have to manage resource consumption?
>
> I mean, if you have a large number of sessions open, it's going to
On Fri, May 4, 2018 at 11:56 AM, Andres Freund wrote:
> Can you expand on what they want?
>
> - Avoid polluting caches? Why's the ringbuffer logic not good enough?
> - Continue after a checksum or similar failure? That seems a bit useless
> for amcheck imo? You know there's corruption at that po
Alvaro Herrera writes:
> Andres Freund wrote:
>>> What exactly would it do? I use ccache all the time, have for years,
>>> but it's not clear to me what can usefully be done by configure.
>> Use ccache without having to set it up individually for CC, CLANG, CXX.
> Umm, I just add /usr/lib/ccache
Alvaro,
I didn't mean to imply otherwise. Our settings here are probably
different.
Good point on the git log --grep. I'll try to remember that in the future.
Mike
__
*Mike Blackwell | Technical Analyst, Distribut
On 04/05/18 10:05, Heikki Linnakangas wrote:
On 24/04/18 13:57, Kyotaro HORIGUCHI wrote:
At Mon, 23 Apr 2018 03:41:47 -0400, Heikki Linnakangas wrote in
<89e33d4f-5c75-0738-3dcb-44c4df59e...@iki.fi>
Looking at the patch linked above
(https://www.postgresql.org/message-id/20171026.190551.20899
First cut at release notes for next week's minor releases is up at
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=488ccfe40a865e3f3c6343e2de026c37ba5a7d50
If you prefer not to read XML markup, they should appear in the devel docs
on the website after guaibasaurus's next run, a
On Fri, May 04, 2018 at 07:00:18PM -0400, Tom Lane wrote:
> First cut at release notes for next week's minor releases is up at
>
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=488ccfe40a865e3f3c6343e2de026c37ba5a7d50
>
> If you prefer not to read XML markup, they should appe
Hello,
Attached is a trivial documentation fix for PG 11 partitioning, which includes:
* pg_partition fails to mention hash for the strategy.
* Partitioning key column values can now be modified, which results in row
movement between partitions.
Regards
Takayuki Tsunakawa
partition_doc_fix.
Michael Paquier writes:
> On Fri, May 04, 2018 at 07:00:18PM -0400, Tom Lane wrote:
> +
> +
> +
> + Support building with Microsoft Visual Studio 2015 (Michael Paquier)
> +
> This will only be part of release-9.5.sgml in the final version, right?
Right, each item is only for t
Hi!
> 4 мая 2018 г., в 16:05, Юрий Соколов написал(а):
>
> I didn't suggest log scale of usages, but rather "replacement-period based"
> increment: usage count could be incremented at most once in NBlocks/32
> replaced items. Once it is incremented, its "replacement time" is remembered,
> and
69 matches
Mail list logo
