On Tue, May 4, 2021 at 10:04 PM Ian Lawrence Barwick
wrote:
> 2021年5月5日(水) 10:43 Tiffany Thang :
> >
> > Hi,
> >
> > I'm having trouble finding in the documentation the steps to install the
> postgres extensions such as pg_stat_statements and pg_trgm on
> PG13.1/CentOS7. Can someone please assist
On Wed, May 5, 2021 at 2:12 PM Thomas Munro wrote:
> It might be interesting to know how that 40ms time scales as you add
> more workers. ...
Another thought: I'd also try tests like that in large databases (ie
large virtual memory) vs small ones, and with and without huge/locked
memory pages co
On Wed, May 5, 2021 at 3:50 AM Hans Buschmann wrote:
> (BTW: Is this cost multiplied by the real count of workers choosen
> (max_parallel_workers_per_gather) or only a value independent of the number
> of workers?. This would matter in windows-high-parallel scenarios)
It's not multiplied:
http
2021年5月5日(水) 10:43 Tiffany Thang :
>
> Hi,
>
> I'm having trouble finding in the documentation the steps to install the
> postgres extensions such as pg_stat_statements and pg_trgm on PG13.1/CentOS7.
> Can someone please assist?
>
>
> postgres=# create extension pg_stat_statements;
>
> ERROR: co
Hi,
I'm having trouble finding in the documentation the steps to install the
postgres extensions such as pg_stat_statements and pg_trgm on
PG13.1/CentOS7. Can someone please assist?
postgres=# create extension pg_stat_statements;
ERROR: could not open extension control file
"/usr/pgsql-13/sha
On Wed, May 5, 2021 at 07:49:29AM +1000, Venkata B Nagothi wrote:
> Hi There,
>
> We are attempting to upgrade our Postgres databases from 9.5 to 12.5 using
> pg_upgrade link mode and are facing issues with OIDs.
>
> ALTER TABLE... SET WITHOUT OIDs on the larger tables is taking very long and
>
Hi There,
We are attempting to upgrade our Postgres databases from 9.5 to 12.5 using
pg_upgrade link mode and are facing issues with OIDs.
ALTER TABLE... SET WITHOUT OIDs on the larger tables is taking very long
and is locking up the table as well. We do have tables of more than 1 TB of
size.
Is
Hi,
this topic would probably be a better fit for pgsql-hackers, as it's
about the internal implementation, but let's continue the discussion
here for now.
On 5/2/21 6:52 AM, Pedro Luis Guzmán Hernández wrote:
Hi there,
I've just started using extended stats cause the planner was giving me
On Tue, May 4, 2021 at 12:43:36PM -0400, Tom Lane wrote:
> Arne Henrik Segtnan writes:
> > When trying to upgrade from PostgreSQL 10 to 12, the installation fails as
> > shown below.
>
> > 2021-05-04 13:06:05.614 CEST [12890] postgres@zabbix_db ERROR: column
> > r.relhasoids does not exist a
Hans Buschmann writes:
> In my opinion, even for Linux the default for parallel_setup_cost is set too
> low (1000). It should reflect the sequential access of 1000 pages, which
> normally is faster from buffer cache on modern hardware.
I tend to agree with you that the default costs for paralle
Arne Henrik Segtnan writes:
> When trying to upgrade from PostgreSQL 10 to 12, the installation fails as
> shown below.
> 2021-05-04 13:06:05.614 CEST [12890] postgres@zabbix_db ERROR: column
> r.relhasoids does not exist at character 1616
> 2021-05-04 13:06:05.614 CEST [12890] postgres@zabbi
On Tue, May 4, 2021 at 6:38 PM Bruce Momjian wrote:
>
> On Tue, May 4, 2021 at 06:29:17PM +0200, Arne Henrik Segtnan wrote:
> > Hi,
> >
> > When trying to upgrade from PostgreSQL 10 to 12, the installation fails as
> > shown below.
> >
> > # pg_upgradecluster --link --method=upgrade 10 main /dbda
On Tue, May 4, 2021 at 06:29:17PM +0200, Arne Henrik Segtnan wrote:
> Hi,
>
> When trying to upgrade from PostgreSQL 10 to 12, the installation fails as
> shown below.
>
> # pg_upgradecluster --link --method=upgrade 10 main /dbdata/zabbix
>
>
> From PosgreSQL log:
> 2021-05-04 13:06:04.780
Thank you Thomas for pointing me to this GUC which I haven't realized before.
>From the documentation I take that a cost of 1.0 is set for a sequential page
>fetch.
In my opinion, even for Linux the default for parallel_setup_cost is set too
low (1000). It should reflect the sequential access o
Hi,
When trying to upgrade from PostgreSQL 10 to 12, the installation fails as
shown below.
# pg_upgradecluster --link --method=upgrade 10 main /dbdata/zabbix
From PosgreSQL log:
2021-05-04 13:06:04.780 CEST [12861] LOG: database system is ready to accept
connections
done
server started
Subject: How to Host Multiple Mail Domains (Email Hosting) in iRedMail
Full Featured Linux Mail Server
Author: Mr. Turritopsis Dohrnii Teo En Ming (TARGETED INDIVIDUAL)
Country: Singapore
Date: 3rd May 2021 Monday
Type of Publication: PDF Manual
Document Version: 20210503.01
***IMPORTANT NOTICE**
On Tue, May 4, 2021 at 7:40 PM Hans Buschmann wrote:
> The problem seems that this (probably inherent) performance disadvantage of
> windows is not reflected in the cost model.
https://www.postgresql.org/docs/13/runtime-config-query.html#GUC-PARALLEL-SETUP-COST
is for that.
It might be interest
Hi again Peter (and thanks again for your input)
> > https://pingcap.com/blog/tikv-and-spdk-pushing-the-limits-of-storage-performance
> > It talks about the Storage Performance Development Kit (SPDK) (spdk.io).
> It looks somewhat similar to Oracle's "raw device tablespaces"
Run far and run fas
Hi Peter, and thanks for your input.
> > Now, I'm not quite sure that I completely comprehend matters: Is there
> > a difference between Asynchronous I/O and Buffered I/O?
> Buffered I/O...
So, with buffered I/O, I might write something to the db (with a
commit) and would get a "yes, written" r
Hi Ron, and thanks for your input.
> > Now, I'm not quite sure that I completely comprehend matters: Is there
> > a difference between Asynchronous I/O and Buffered I/O?
> * Asynchronous (a-syn-chron-ous) is an adjective which means "not together
> with time".
> * Buffered means "read more than
Hi Vijay, and thanks for your input.
> This wiki page.
> It has PR references for mysql and mongo for the fsycnc issue.
> Fsync Errors - PostgreSQL wiki
OK - so that shows that it did affect MySQL and MongoDB... I'm
surprised that there wasn't more of a brouhaha over it so - what with
MySQL bein
>No Windows here, but could it be super slow at launching workers? How
>does a trivial parallel query compare, something like?
>SET force_parallel_mode = on;
>EXPLAIN ANALYZE SELECT 42;
indeed this query takes about 40ms in windows and 7ms on Linux (lowest values).
Due to remoting the machine
Hello,
I'm a PostgreSQL user on Windows and encountered trouble running pg_upgrade
with the following error [1], ultimately due to blocked ports in Windows
added via OS updates.
A workaround is to run pg_upgrade with lower range ports for the old/new
servers via the -p/-P parameters.
23 matches
Mail list logo
