On Tue, Oct 23, 2018 at 5:49 PM Haribabu Kommi
wrote:
> I am able to generate the simple test and found the problem. The issue
> with the following
> SQL.
>
> SELECT *
>INTO TABLE xacttest
>FROM aggtest;
>
> During the processing of the above query, the tuple that is selected from
> the a
Hello Arthur,
sh> psql "host=127.0.0.2 hostaddr=127.0.0.1"
I'm not sure that is is the issue. User defined the host name and psql
show it.
The issue is that "host" is an ip, "\conninfo" will inform wrongly that you
are connected to "127.0.0.2", but the actual connection is really to
"127.
Michael Paquier wrote:
> If there are no
> objections, I'll look at this patch again by the end of this week in
> order to get it committed.
No objections from me; on the contrary, I would like to thank you for
your effort here. I appreciate that you probably spent more time
tutoring me than it w
Hello,
> Also, the alternate implementation should not change the result, so
> something looks amiss in your version. Moreover, I'm unclear how to
> implement an overflow multiply with the safe no overflow version.
(snip)
I made an honest mistake. I had assumed the modulo number of Knuth's LCG
On 19.10.2018 0:54, Peter Geoghegan wrote:
I would welcome any theories as to what could be the problem here. I'm
think that this is fixable, since the picture for the patch is very
positive, provided you only focus on bgwriter/checkpoint activity and
on-disk sizes. It seems likely that there
On Mon, Oct 22, 2018 at 1:42 PM Fabien COELHO wrote:
>
> Hello Michaël,
>
> > The first failure is unrelated to the involved commits, as they touched
> > completely different areas of the code:
> > INSERT INTO hash_split_heap SELECT a/2 FROM generate_series(1, 25000) a;
> > + WARNING: buffer ref
Amit Kapila writes:
> On Mon, Oct 22, 2018 at 1:42 PM Fabien COELHO wrote:
>> Both animals use gcc experimental versions, which may rather underline a
>> new bug in gcc head rather than an existing issue in pg. Or not.
> It is possible, but what could be the possible theory?
It seems like the t
Hi hackers,
The last-minute change for CREATE (EVENT) TRIGGER to accept EXECUTE
FUNCTION as well as EXECUTE PROCEDURE did not update the tab completion
in psql to match. Please find attached two patches that do this for
CREATE TRIGGER and CREATE EVENT TRIGGER, respectively.
To keep the duplicati
Hello Tom & Amit,
Both animals use gcc experimental versions, which may rather underline a
new bug in gcc head rather than an existing issue in pg. Or not.
It is possible, but what could be the possible theory?
It seems like the two feasible theories are (1) gcc bug, or (2) buffer
leak th
On 10/22/2018 10:00 PM, Amit Langote wrote:
After observing the test case in the provided log, I managed to reproduce
it with the following:
create table foo (a int primary key, b int);
create table bar (a int references foo on delete cascade, b int);
insert into foo values (1, 1);
insert int
ilm...@ilmari.org (Dagfinn Ilmari Mannsåker) writes:
> Hi hackers,
>
> The last-minute change for CREATE (EVENT) TRIGGER to accept EXECUTE
> FUNCTION as well as EXECUTE PROCEDURE did not update the tab completion
> in psql to match. Please find attached two patches that do this for
> CREATE TRIGG
I wrote:
> =?utf-8?q?PG_Bug_reporting_form?= writes:
>> SELECT * FROM test_file_fdw_program_limit LIMIT 0;
>> /*
>> [38000] ERROR: program "echo "test"" failed Detail: child process exited
>> with exit code 1
>> */
> Yeah, I can reproduce this on macOS as well as Linux. Capturing stderr
> shows
On Mon, Oct 22, 2018 at 5:06 AM Adelino Silva <
adelino.j.si...@googlemail.com> wrote:
> Hello Takayuki,
>
> Sorry can you explain how we can same network bandwidth by not sending the
> WAL archive from the primary to the standby(s).
> I possible scenario is have to multiple standby servers in sam
[schema-variables-20181007-01.patch.gz]
Hi,
I tried to test your schema-variables patch but got stuck here instead
(after applying succesfully on top of e6f5d1acc):
make[2]: *** No rule to make target
'../../../src/include/catalog/pg_variable.h', needed by 'bki-stamp'.
Stop.
make[1]: ***
On 23/10/2018 02:11, Michael Paquier wrote:
> On Mon, Oct 22, 2018 at 07:12:28PM +0200, Peter Eisentraut wrote:
>> OK, slightly reworked version attached.
>
> + attTup = (Form_pg_attribute) GETSTRUCT(tuple);
> attnum = ((Form_pg_attribute) GETSTRUCT(tuple))->attnum;
>
> No need to call twic
On Tue, Oct 23, 2018 at 11:35 AM Andrey Lepikhov
wrote:
> I have same problem with background heap & index cleaner (based on your
> patch). In this case the bottleneck is WAL-record which I need to write
> for each cleaned block and locks which are held during the WAL-record
> writing process.
Pa
I propose the attached patch to remove the long-unused catalog column
pg_attrdef.adsrc.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From df811a76e026be395a4309a1f0de75540dae5b11 Mon Sep 17 00:00:00 2001
From: P
I wrote:
> Once this is in shape, I'll do some performance testing.
On second thought, there's no point in waiting, especially if a
regression points to a design flaw.
I compiled patched postgres with HEAP_FSM_CREATION_THRESHOLD set to
32, then ran the attached script which populates 100 tables
Hi,
On Tue, Oct 23, 2018 at 8:46 PM Andrew Dunstan
wrote:
> On 10/22/2018 10:00 PM, Amit Langote wrote:
> > After observing the test case in the provided log, I managed to reproduce
> > it with the following:
> >
> > create table foo (a int primary key, b int);
> > create table bar (a int referen
Hello Tom,
Sorry for the misleading. Could you try these two queries? I made the query
even slower in latest version of postgres. These are information about how we
set up evaluation environment and query result.
Thanks,
Jinho Jung
Install Multiple version of DBs in one machine
==
Hi,
I found that in the PG source code function BackendInitialize(), handler for
SIGTERM was set to be startup_die(). And in startup_die(), we simply call
proc_exit to exit the process.
What's more, early in BackendInitialize() function, we called pq_init to
setup socket_close() as a process ex
On 2018-10-23 13:54:31 +0200, Fabien COELHO wrote:
>
> Hello Tom & Amit,
>
> > > > Both animals use gcc experimental versions, which may rather underline a
> > > > new bug in gcc head rather than an existing issue in pg. Or not.
> >
> > > It is possible, but what could be the possible theory?
>
Hello Richard,
Currently for quals in the form of "NOT NOT (SubLink)", this SubLink
would not
be considered when pulling up sublinks. For instance:
gpadmin=# explain select * from a where NOT NOT (a.i in (select b.i
from b));
QUERY PLAN
--
Good Morning,
We have older version of postgres 8.3.7, I am trying to install postgres on
ubuntu 14.04 LTS under GCP instance, Im having difficulty in installating the
postgres 8.3.7 .
We are not able proceed with the installation manually. I am wondering whether
ubuntu 14 is compatible with
On Tue, Oct 23, 2018 at 10:08 AM Vaidyanathaswamy, Anandsaikrishnan <
avaidyanathasw...@corelogic.com> wrote:
> Good Morning,
>
>
>
> We have older version of postgres 8.3.7, I am trying to install postgres
> on ubuntu 14.04 LTS under GCP instance, Im having difficulty in
> installating the postg
On 10/23/18 13:15, Steve Crawford wrote:
> On Tue, Oct 23, 2018 at 10:08 AM Vaidyanathaswamy, Anandsaikrishnan <
> avaidyanathasw...@corelogic.com> wrote:
>> We are not able proceed with the installation manually. I am wondering
>> whether ubuntu 14 is compatible with version 8.3.7
...
> First, I
target 'submake-catalog-headers' failed
> src/Makefile.global:370: recipe for target 'submake-generated-headers'
> failed
>
>
Unfortunately previous patch was completely broken. I am sorry
Please, check this patch.
Regards
Pavel
> thanks,
>
> Erik Rijkers
>
schema-variables-20181023-01.patch.gz
Description: application/gzip
On 2018-Oct-23, Peter Eisentraut wrote:
> I propose the attached patch to remove the long-unused catalog column
> pg_attrdef.adsrc.
+1, looks good. I think this change has been waiting for a very long
time -- documented as useless by 81c41e3d0ed3 (Jan 2005, general doc
copy-edit, a paragraph you
On 10/23/18 1:51 PM, Vaidyanathaswamy, Anandsaikrishnan wrote:
> configure: error: readline library not found
> If you have readline already installed, see config.log for details on the
> failure. It is possible the compiler isn't looking in the proper directory.
> Use --without-readline to disab
> On 23 Oct 2018, at 15:17, Peter Eisentraut
> wrote:
>
> I propose the attached patch to remove the long-unused catalog column
> pg_attrdef.adsrc.
+1, I ran into a bug in an app as recently as today where adsrc was used
instead of pg_get_expr().
Patch looks good. I probably would’ve opted fo
Thank you so much for your prompt reply,
Background on this, We have postgres same version for the past 12 years with
8.3.7, We are moving to cloud GCP
To start with testing the 8.3.7 on ubuntu 14.04 LTS version, I am finding
difficulty in installing the 8.3.7 version, Here is the latest error
Hello,
I am extremely excited to be part of PostgreSQL...
Every task seems to be exciting!
I have basic knowledge of SQL and am thinking of being part of your
organization's tasks.
Thankyou.
Yours faithfully,
PMS
Folks,
Per gripes I've been hearing with increasing frequency, please find
attached a patch that implements $Subject. It's microsecond resolution
because at least at the moment, nanosecond resolution doesn't appear
to be helpful in this context.
Best,
David.
--
David Fetter http://fetter.org/
P
On Wed, Oct 24, 2018 at 7:51 AM David Fetter wrote:
> Per gripes I've been hearing with increasing frequency, please find
> attached a patch that implements $Subject. It's microsecond resolution
> because at least at the moment, nanosecond resolution doesn't appear
> to be helpful in this context.
On Wed, Oct 24, 2018 at 08:00:24AM +1300, Thomas Munro wrote:
> On Wed, Oct 24, 2018 at 7:51 AM David Fetter wrote:
> > Per gripes I've been hearing with increasing frequency, please find
> > attached a patch that implements $Subject. It's microsecond resolution
> > because at least at the moment,
On 2018-Oct-23, David Fetter wrote:
> On Wed, Oct 24, 2018 at 08:00:24AM +1300, Thomas Munro wrote:
> > On Wed, Oct 24, 2018 at 7:51 AM David Fetter wrote:
> > > Per gripes I've been hearing with increasing frequency, please find
> > > attached a patch that implements $Subject. It's microsecond r
Hello,
We appreciate you taking time for test! When we do more evaluation, we
noticed that the previously attached query made regression only on DBs that
we installed from APT manager (i.e., apt-get command) not on DBs that we
built from the source code. But we also confirmed that there are many c
*Order is reversed. *
*1.sql*
9.4.19: 20ms
10.5 : 1,227ms
*4.sql*
9.4.19: 13ms
10.5 : 88,721ms
*20.sql*
9.4.19: 271ms
10.5 : 6,104ms
*22.sql*
9.4.19: 8ms
10.5 : 105ms
On Tue, Oct 23, 2018 at 3:15 PM Jinho Jung wrote:
> Hello,
>
> We appreciate you taking time for test! When we do mor
On Tue, Oct 23, 2018 at 04:14:50PM -0300, Alvaro Herrera wrote:
> On 2018-Oct-23, David Fetter wrote:
>
> > On Wed, Oct 24, 2018 at 08:00:24AM +1300, Thomas Munro wrote:
> > > On Wed, Oct 24, 2018 at 7:51 AM David Fetter wrote:
> > > > Per gripes I've been hearing with increasing frequency, pleas
On Tue, Oct 23, 2018 at 12:26:35PM +0100, Dagfinn Ilmari Mannsåker wrote:
> The last-minute change for CREATE (EVENT) TRIGGER to accept EXECUTE
> FUNCTION as well as EXECUTE PROCEDURE did not update the tab completion
> in psql to match. Please find attached two patches that do this for
> CREATE T
On Wed, Oct 24, 2018 at 12:11:18AM +0200, David Fetter wrote:
> That's an interesting point. pgbadger is the only one I recall using
> that's still maintained. Which others would it be useful to test?
There could be private solutions as well. My take is that we should use
separate letters and no
On Tue, Oct 23, 2018 at 07:50:57AM -0700, Andres Freund wrote:
> FWIW, my animal 'serinus', which runs debian's gcc-snapshot shows the same
> problem:
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=serinus&dt=2018-10-22%2006%3A34%3A02
>
> So it seems much more likely to be 1).
Thanks
On Tue, Oct 23, 2018 at 09:42:16AM +0200, Laurenz Albe wrote:
> No objections from me; on the contrary, I would like to thank you for
> your effort here. I appreciate that you probably spent more time
> tutoring me than it would have taken you to write this yourself.
You're welcome. Happy that i
On Tue, Oct 23, 2018 at 12:54 PM Kyotaro HORIGUCHI
wrote:
>
> Hello.
>
> # It took a long time to come here..
>
> At Fri, 19 Oct 2018 21:38:35 +0900, Masahiko Sawada
> wrote in
> > On Wed, Oct 10, 2018 at 1:34 PM Masahiko Sawada
> > wrote:
> ...
> > * Updated docs, added the new section "Dist
Hi all,
baaf272 has added support for group updates in clog, however it has
added the wait event WAIT_EVENT_CLOG_GROUP_UPDATE in a non-alphabetical
order. There are many events, so keeping things in order helps users in
finding them.
Are there any objections to the attached, which reorders thing
Hello.
# It might be better that you provided self-contained test case.
As the discussion between Heikki and Tom just upthread, it would
be doable but that usage isn't typical. The query would be
normally written as followings and they are transformed as
desired.
select '|'||subject||'|', ts_ran
On Wed, Oct 24, 2018 at 08:46:47AM +0900, Michael Paquier wrote:
> On Wed, Oct 24, 2018 at 12:11:18AM +0200, David Fetter wrote:
> > That's an interesting point. pgbadger is the only one I recall using
> > that's still maintained. Which others would it be useful to test?
>
> There could be privat
On Wed, Oct 24, 2018 at 08:43:05AM +0900, Michael Paquier wrote:
> On Tue, Oct 23, 2018 at 12:26:35PM +0100, Dagfinn Ilmari Mannsåker wrote:
> > The last-minute change for CREATE (EVENT) TRIGGER to accept EXECUTE
> > FUNCTION as well as EXECUTE PROCEDURE did not update the tab completion
> > in psq
On Wed, Oct 24, 2018 at 5:56 AM Michael Paquier wrote:
> baaf272 has added support for group updates in clog, however it has
> added the wait event WAIT_EVENT_CLOG_GROUP_UPDATE in a non-alphabetical
> order. There are many events, so keeping things in order helps users in
> finding them.
That's a
On Tue, Oct 23, 2018 at 02:40:30PM +0900, Michael Paquier wrote:
> Actually, as StartSubTransaction also switches to TRANS_START for a
> savepoint, if there is an error until the state is switched to
> TRANS_INPROGRESS then the code would fail to switch back to
> CurrentUserId even if it is set, an
On Wed, Oct 24, 2018 at 10:25:37AM +0530, Kuntal Ghosh wrote:
> That's a valid argument. Additionally, I've found
> WAIT_EVENT_HASH_GROW_BUCKETS_ALLOCATING and
> WAIT_EVENT_HASH_GROW_BATCHES_ALLOCATING are added in a
> non-alphabetical order in WaitEventIPC enum.
Indeed, thanks for double-checking
On Wed, Oct 24, 2018 at 10:48 AM Michael Paquier wrote:
> > That's a valid argument. Additionally, I've found
> > WAIT_EVENT_HASH_GROW_BUCKETS_ALLOCATING and
> > WAIT_EVENT_HASH_GROW_BATCHES_ALLOCATING are added in a
> > non-alphabetical order in WaitEventIPC enum.
> And those ones are also incorr
On Sun, Oct 21, 2018 at 08:56:32PM -0400, Stephen Frost wrote:
> All of this pie-in-the-sky about what pluggable storage might have is
> just hand-waving, in my opinion, and not worth much more than that. I
> hope (and suspect..) that the actual pluggable storage that's being
> worked on doesn't d
53 matches
Mail list logo
