Andrus schrieb am 16.02.2021 um 07:48:
> Last year I posted testcase [1] which shows that using jit makes execution
> magnitude slower ( 2.5s vs 0.4 sec) in typical shopping cart application
> product search in Postgres 12.
>
> There are also other reports on this [2,3].
>
> I tried to turn jit of
Hi!
Last year I posted testcase [1] which shows that using jit makes execution
magnitude slower ( 2.5s vs 0.4 sec) in typical shopping cart application
product search in Postgres 12.
There are also other reports on this [2,3].
I tried to turn jit off for subquery using
select ... from
(
set
Wouldnt you need to connect to the database first before you can ALTER ROLE
anything?
On Tue, Feb 16, 2021 at 1:25 AM Wolfgang Walther
wrote:
> Hi,
>
> I'm trying to set a GUC for a role in the current database only - but
> don't know the name of the database at the time of writing code. Could
>
Il giorno lun 15 feb 2021 alle ore 20:40 Loles ha
scritto:
> One thing is the number of records in the table and another is the current
> value of the sequence.
>
> Execute:
>
> select max (field) from bobo.menu_pages;
>
> In both master and slave server.
>
> What give you back?
>
> "field" is th
Thanks David. I tried that and this is what I get:
Feb 16 11:27:23 db1 postgres[27675]: [3595-1] etx_ecom>
LOG: connection authorized: user=username database=etx_ecom
Feb 16 11:27:23 db1 postgres[26184]: [3598-1] core> LOG:
disconnection: session time: 0:00:47.727 user=username database=core
hos
On Mon, 2021-02-15 at 12:40 -0800, Christophe Pettus wrote:
> > On Feb 15, 2021, at 08:15, Laurenz Albe wrote:
> > Right. I cannot think of any other reason, given that the standby only
> > allows reading. It's just an "xmax", and PostgreSQL needs to read the
> > multixact to figure out if it ca
On Monday, February 15, 2021, Abdul Qoyyuum
wrote:
> Hi all,
>
> I have a Postgresql cluster with master and multiple slaves running on
> version 9.6. I'm trying to adjust the log_statement from all to ddl on
> specific databases (i.e. postgresql.conf has log_statement='all' but I need
> a couple
On Tue, 16 Feb 2021 at 02:12, Fabio Pardi wrote:
>
> On 14/02/2021 22:16, Gavin Flower wrote:
> > While I agree it might be good to be able specify the number of workers,
> > sure it would be possible to derive a suitable default based on the number
> > of effective processors available?
>
> I h
On Mon, 15 Feb 2021 at 10:16, Gavin Flower
wrote:
> Just wondering why there is a hard coded limit.
I don't see where the hardcoded limit is. The total number is limited
to max_parallel_workers_per_gather, but there's nothing hardcoded
about the value of that.
> While I agree it might be good t
Hi all,
I have a Postgresql cluster with master and multiple slaves running on
version 9.6. I'm trying to adjust the log_statement from all to ddl on
specific databases (i.e. postgresql.conf has log_statement='all' but I need
a couple of databases set to log_statement='ddl').
etx_ecom=# ALTER DAT
> Nable didn't seem to work. I got a bounce iirc.
Not sure what you are doing? My previous reply a day ago and this reply are
from Nable with no issues.
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
I am running postgreSQL 13 server/client successfully on my workstation but am
having problems setting it up in a docker container, both running CentOS 7. I
have previously run postgreSQL 9.6 successfully in docker but right now I am
unable to initialize the database under pg 13. For some reason
On 2/15/21 1:50 PM, Joe Abbate wrote:
On 15/2/21 16:29, Adrian Klaver wrote:
On 2/15/21 1:15 PM, Joe Abbate wrote:
We've been experiencing PG server process crashes about every other
week on a mostly read only website (except for a single insert/update
on page access). Typical log entries loo
On Tue, Feb 16, 2021 at 4:32 AM Laurenz Albe wrote:
> What I would do is experiment with the "ldapsearch" executable from OpenLDAP
> and see
> if you can reproduce the problem from the command line.
Also, maybe try doing this as the "postgres" user (or whatever user
PostgreSQL runs as), just in
On 15/2/21 16:29, Adrian Klaver wrote:
On 2/15/21 1:15 PM, Joe Abbate wrote:
We've been experiencing PG server process crashes about every other
week on a mostly read only website (except for a single insert/update
on page access). Typical log entries look like
LOG: checkpointer process (PI
Joe Abbate writes:
> Hello,
>
> We've been experiencing PG server process crashes about every other week
> on a mostly read only website (except for a single insert/update on page
> access). Typical log entries look like
>
> LOG: checkpointer process (PID 11200) was terminated by signal 9: Ki
On 2/15/21 1:15 PM, Joe Abbate wrote:
Hello,
We've been experiencing PG server process crashes about every other week
on a mostly read only website (except for a single insert/update on page
access). Typical log entries look like
LOG: checkpointer process (PID 11200) was terminated by sign
Hello,
We've been experiencing PG server process crashes about every other week
on a mostly read only website (except for a single insert/update on page
access). Typical log entries look like
LOG: checkpointer process (PID 11200) was terminated by signal 9: Killed
LOG: terminating any othe
Philip Semanchuk writes:
> I saw some unexpected behavior that I'm trying to understand. I suspect it
> might be a quirk specific to AWS Aurora and I'd like to confirm that.
> When I restart my local Postgres instance (on my Mac), the values in
> pg_stat_user_tables.n_mod_since_analyze are pres
> On Feb 15, 2021, at 08:15, Laurenz Albe wrote:
> Right. I cannot think of any other reason, given that the standby only
> allows reading. It's just an "xmax", and PostgreSQL needs to read the
> multixact to figure out if it can see the row or not.
OK, I think I see the scenario: A very lar
On 2021-02-15 12:30, Adrian Klaver wrote:
> On 2/15/21 9:24 AM, Thomas Guyot wrote:
>
>> The "download mbox" option doesn't work, I get asked for a user/password
>> every time (I would've downloaded archives for the lats two months to
>> get continuation on most threads).
>
> The user/password is
On 2/15/21 12:22 PM, Karthik K wrote:
yes, I'm using \copy to load the batch table,
with the new design that we are doing, we expect updates to be less
going forward and more inserts, one of the target columns I'm updating
is indexed, so I will drop the index and try it out, also from your
One thing is the number of records in the table and another is the current
value of the sequence.
Execute:
select max (field) from bobo.menu_pages;
In both master and slave server.
What give you back?
"field" is the data that belongs to the sequence.
El lun., 15 feb. 2021 18:55, Paolo Saudi
Karthik K writes:
> exactly, for now, what I did was, as the table is already partitioned, I
> created 50 different connections and tried updating the target table by
> directly querying from the source partition tables. Are there any other
> techniques that I can use to speed this up? also whe
yes, I'm using \copy to load the batch table,
with the new design that we are doing, we expect updates to be less going
forward and more inserts, one of the target columns I'm updating is
indexed, so I will drop the index and try it out, also from your suggestion
above splitting the on conflict in
On 2/15/21 11:41 AM, Karthik K wrote:
exactly, for now, what I did was, as the table is already partitioned, I
created 50 different connections and tried updating the target table by
directly querying from the source partition tables. Are there any other
techniques that I can use to speed th
On 2021-Feb-15, Adrian Klaver wrote:
> On 2/15/21 9:24 AM, Thomas Guyot wrote:
>
> > The "download mbox" option doesn't work, I get asked for a user/password
> > every time (I would've downloaded archives for the lats two months to
> > get continuation on most threads).
>
> The user/password is
exactly, for now, what I did was, as the table is already partitioned, I
created 50 different connections and tried updating the target table by
directly querying from the source partition tables. Are there any other
techniques that I can use to speed this up? also when we use on conflict
statement
On 2/15/21 9:55 AM, Marc Millas wrote:
Hi Tom,
I do read the doc, and understand the caching behaviour of plpgsql.
This is not about plpgsql caching. It is about EXECUTE in plpgsql
meaning something different then the PREPARE/EXECUTE combination in SQL.
You are trying to run EXECUTE moninse
On 2/15/21 8:23 AM, Laurenz Albe wrote:
On Sat, 2021-02-13 at 09:57 -0700, Rob Sargent wrote:
I’m confused, as usual, about using a cert in a connection string. I wish to
connect form a
“middle ware” piece to PG on be half of various clients. Does each client
need a corresponding
cert
Hi all,
I have two servers, a primary and a secondary one with a streaming replica
setup.
Today I noticed that some sequences are not lined-up, the replica ones are
well ahead, while the records number is the same. How is it possible?
Thanks,
Paolo
--
-- primary server
--
postgres@db-srv1:~$ psql
Hi Tom,
I do read the doc, and understand the caching behaviour of plpgsql.
if in psql I write begin;execute moninsert(randname()); execute
moninsert(randname());end;
it does work. And if I put this (begin execute end) inside a do loop it
doesnt anymore.
ok the begin execute end is ""pure"" SQL,
On 2/15/21 9:24 AM, Thomas Guyot wrote:
The "download mbox" option doesn't work, I get asked for a user/password
every time (I would've downloaded archives for the lats two months to
get continuation on most threads).
The user/password is in the message in the prompt.
The resend option does
Hi,
I'm trying to set a GUC for a role in the current database only - but
don't know the name of the database at the time of writing code. Could
be development, staging, ...
I would basically like to do something like this:
ALTER ROLE a IN CURRENT DATABASE SET b TO c;
Although that syntax d
On 2021-02-14 22:44, Thomas Munro wrote:
> On Fri, Jan 29, 2021 at 4:27 AM Alvaro Herrera
> wrote:
>
> While catching up with some interesting new threads just now I was
> quite confused by the opening sentence of this message (which also
> arrived in my mailbox):
>
> https://www.postgresql.org
On 2/15/21 8:55 AM, Ron wrote:
The time portions of the part_date fields don't match...
sides=> ALTER TABLE employer_response
ADD CONSTRAINT amended_response_fk FOREIGN KEY
(amended_response_id, part_date)
REFERENCES employer_response(employer_response_id, part_date)
ON
On 2/15/21 10:58 AM, Adrian Klaver wrote:
On 2/15/21 8:55 AM, Ron wrote:
On 2/15/21 10:27 AM, Adrian Klaver wrote:
On 2/15/21 8:23 AM, Ron wrote:
On 2/15/21 10:17 AM, Adrian Klaver wrote:
On 2/15/21 8:12 AM, Ron wrote:
Postgresql 12.5
The error:
DETAIL: Key (amended_response_id, part
On 2/15/21 8:55 AM, Ron wrote:
On 2/15/21 10:27 AM, Adrian Klaver wrote:
On 2/15/21 8:23 AM, Ron wrote:
On 2/15/21 10:17 AM, Adrian Klaver wrote:
On 2/15/21 8:12 AM, Ron wrote:
Postgresql 12.5
The error:
DETAIL: Key (amended_response_id, part_date)=(103309154, 2021-01-06
00:00:00) is
Hi all,
I saw some unexpected behavior that I'm trying to understand. I suspect it
might be a quirk specific to AWS Aurora and I'd like to confirm that.
When I restart my local Postgres instance (on my Mac), the values in
pg_stat_user_tables.n_mod_since_analyze are preserved. In other words, if
On 2/15/21 10:27 AM, Adrian Klaver wrote:
On 2/15/21 8:23 AM, Ron wrote:
On 2/15/21 10:17 AM, Adrian Klaver wrote:
On 2/15/21 8:12 AM, Ron wrote:
Postgresql 12.5
The error:
DETAIL: Key (amended_response_id, part_date)=(103309154, 2021-01-06
00:00:00) is not present in table "employer_
Ron writes:
> Postgresql 12.5
> It's a self-referential FK on a single (but partitioned) table. The ALTER
> TABLE command fails, but I queried it, and the record that it fails on
> exists. I modified the original INITIALLY IMMEDIATE clause to INITIALLY
> DEFERRED but that did not help.
> Wha
On 2/15/21 10:27 AM, Adrian Klaver wrote:
On 2/15/21 8:23 AM, Ron wrote:
On 2/15/21 10:17 AM, Adrian Klaver wrote:
On 2/15/21 8:12 AM, Ron wrote:
Postgresql 12.5
The error:
DETAIL: Key (amended_response_id, part_date)=(103309154, 2021-01-06
00:00:00) is not present in table "employer_re
Marc Millas writes:
> in psql, with a postgres 12.5 db on a centos 7 intel:
> I do create a function named randname() returning a varchar, and a table
> matable with a column prenom varchar(50). then
> postgres=# prepare moninsert(varchar) as
> postgres-# insert into matable(prenoms) values($1);
>
On 2/15/21 8:23 AM, Ron wrote:
On 2/15/21 10:17 AM, Adrian Klaver wrote:
On 2/15/21 8:12 AM, Ron wrote:
Postgresql 12.5
The error:
DETAIL: Key (amended_response_id, part_date)=(103309154, 2021-01-06
00:00:00) is not present in table "employer_response"
is pointing at 103309154 for amen
On Mon, Feb 15, 2021 at 9:19 AM Marc Millas wrote:
>
> postgres=# prepare moninsert(varchar) as
>
> do $$ begin for counter in 1..100 loop execute
> moninsert(randname());end loop;end;$$;
> ERREUR: la fonction moninsert(character varying) n'existe pas
> someone can explain ?
>
>
>From the pl
On 2/15/21 10:17 AM, Adrian Klaver wrote:
On 2/15/21 8:12 AM, Ron wrote:
Postgresql 12.5
It's a self-referential FK on a single (but partitioned) table. The ALTER
TABLE command fails, but I queried it, and the record that it fails on
exists. I modified the original INITIALLY IMMEDIATE clause
On 2/15/21 8:18 AM, Marc Millas wrote:
Hi,
in psql, with a postgres 12.5 db on a centos 7 intel:
I do create a function named randname() returning a varchar, and a table
matable with a column prenom varchar(50). then
postgres=# prepare moninsert(varchar) as
postgres-# insert into matable(preno
Hi,
in psql, with a postgres 12.5 db on a centos 7 intel:
I do create a function named randname() returning a varchar, and a table
matable with a column prenom varchar(50). then
postgres=# prepare moninsert(varchar) as
postgres-# insert into matable(prenoms) values($1);
PREPARE
I test it:
postgre
On 2/15/21 8:12 AM, Ron wrote:
Postgresql 12.5
It's a self-referential FK on a single (but partitioned) table. The
ALTER TABLE command fails, but I queried it, and the record that it
fails on exists. I modified the original INITIALLY IMMEDIATE clause to
INITIALLY DEFERRED but that did not h
On Mon, 2021-02-15 at 08:03 -0800, Christophe Pettus wrote:
> On Feb 15, 2021, at 07:47, Laurenz Albe wrote:
> > So my guess would be that the difference between primary and standby is not
> > that a
> > different number of multixacts are created, but that you need to read them
> > on
> > the st
Postgresql 12.5
It's a self-referential FK on a single (but partitioned) table. The ALTER
TABLE command fails, but I queried it, and the record that it fails on
exists. I modified the original INITIALLY IMMEDIATE clause to INITIALLY
DEFERRED but that did not help.
What am I doing wrong?
(
> On Feb 15, 2021, at 07:47, Laurenz Albe wrote:
> So my guess would be that the difference between primary and standby is not
> that a
> different number of multixacts are created, but that you need to read them on
> the standby and not on the primary.
Why does the secondary need to read the
On Fri, 2021-02-12 at 11:11 -0800, Christophe Pettus wrote:
> On a whole fleet of load-balanced replicas, we saw an incident where one
> particular query
> started backing up on MultiXactMemberControlLock and multixact_member.
> There was no sign
> of this backup on the primary. Under what co
On Sat, 2021-02-13 at 10:36 +, João Gaspar wrote:
> I have a PostgreSQL 13.1 (RHEL 8.3) Server and I want to configure the
> pg_hba.conf with a remote ldaps server.
>
> My steps:
>
> I create a PostgreSQL user1 with superuser role to test the ldaps
> authentication method in the terminal cl
On Sat, 2021-02-13 at 09:57 -0700, Rob Sargent wrote:
> I’m confused, as usual, about using a cert in a connection string. I wish to
> connect form a
> “middle ware” piece to PG on be half of various clients. Does each client
> need a corresponding
> cert/key or is the certification intended
On 14/02/2021 22:16, Gavin Flower wrote:
> On 14/02/2021 22:47, David Rowley wrote:
>> On Sun, 14 Feb 2021 at 13:15, Seamus Abshere
>> wrote:
>>> The comment from Robert says: (src/backend/optimizer/path/allpaths.c)
>>>
>>> /*
>>> * If the use of parallel appe
On Sun, 2021-02-14 at 22:47 +1300, David Rowley wrote:
> On Sun, 14 Feb 2021 at 13:15, Seamus Abshere
>
> wrote:
>
> > The comment from Robert says: (src/backend/optimizer/path/allpaths.c)
> > /*
> > * If the use of parallel append is permitted, always
> > req
Guten Tag Guy Burgess,
am Montag, 15. Februar 2021 um 11:52 schrieben Sie:
> The mystery now is that the only process logged as touching the
> affected WAL files is postgres.exe (of which there are many separate
> processes). Could it be that one of the postgres.exe instances is
> holding the affe
On 12/02/2021 4:33 am, Thorsten Schöning wrote:
The behaviour you describe happens exactly when two processes e.g.
concurrently hold HANDLEs on the same file and one of those deletes
the file then. Windows keeps file names until all open HANDLEs are
closed and depending on how those HANDLEs have
59 matches
Mail list logo
