On 2023-10-27 12:03, p...@pfortin.com wrote:
I can't think of a common hardware bus/other that would only affect
PostgreSQL disk accesses.
Which file system is PostgreSQL being run on?
Asking because I remember seeing weirdness reported with *some* SSD
drives when used with ZFS:
https://gi
On Thu, 26 Oct 2023 15:50:16 -0400 p...@pfortin.com wrote:
>Hi Peter,
>
>All of the following is based on using SQL_workbench/J (WB) (Mageia Linux
>has not provided a viable pgAdmin4 package); WB is setup to autoload the
>table row count and 10 rows. I'm sticking to one set of files where they
>a
On Thu, Oct 26, 2023 at 11:46:18AM -0400, Raymond Brinzer wrote:
> I'd like to express my appreciation for a project with a feature set so
> extensive that a person might mistakenly assume that its goal was to cover the
> spec comprehensively.
Okay, I couldn't stop smiling from this comment. :-)
Hi Peter,
All of the following is based on using SQL_workbench/J (WB) (Mageia Linux
has not provided a viable pgAdmin4 package); WB is setup to autoload the
table row count and 10 rows. I'm sticking to one set of files where they
are all roughly 33.6M rows.
I've been doing a lot of digging and f
> On Oct 26, 2023, at 11:53, Atul Kumar wrote:
>
> Please share the required link having such information in detail, It would be
> more helpful to me.
https://www.postgresql.org/docs/current/auth-pg-hba-conf.html
Please share the required link having such information in detail, It would
be more helpful to me.
Regards.
On Fri, Oct 27, 2023 at 12:16 AM Christophe Pettus wrote:
>
>
> > On Oct 26, 2023, at 11:44, Atul Kumar wrote:
> > There is already one line to serve your stated purpose
> > local
> On Oct 26, 2023, at 11:44, Atul Kumar wrote:
> There is already one line to serve your stated purpose
> local all alltrust
>
>
> That's why I specifically raised this question for below from postgresql
> experts
> hostall all
as per response
"It allows anyone/anything on the local machine to connect to the database
without authentication. Whether that impacts any particular one/thing
depends on your personal setup."
There is already one line to serve your stated purpose
local all all
On Thu, Oct 26, 2023 at 10:56 AM Zain Kabani
wrote:
> I was looking into using prepared statements and using the auto
> plan_cache_mode. The issue is that the current sample of data collected to
> determine whether to use custom plans or the generic one is very small and
> susceptible to a bad se
Thanks, I appreciate the input
Regards
Yong
On Thu, Oct 26, 2023, 11:39 AM Ron wrote:
> On 10/26/23 07:42, Yongye Serkfem wrote:
>
> Hello PostgreSQL Community,
> I am having difficulties uninstalling ora2pg which I manually installed on
> our Postgresql servers. I would appreciate any input on
Hi team,
I was looking into using prepared statements and using the auto
plan_cache_mode. The issue is that the current sample of data collected to
determine whether to use custom plans or the generic one is very small and
susceptible to a bad set of queries that might pick the suboptimal choice.
Anders Kildemand ezt írta (időpont: 2023. okt. 26., Cs,
14:38):
> What's the situation with Property Graph Queries in Postgres?
>
If the underlying question is how to utilize graph database functionality
in PostgreSQL, there are similar extensions that may be worth exploring:
- Apache AGE is a P
On 10/26/23 09:51, Atul Kumar wrote:
Hi,
I have the postgres12 version running on centos7.
In pg_hba.conf file I have an entry like below:
host all all /32 md5
So from the above entry, I understand that all users can connect to all
databases from the rem
Atul Kumar writes:
> In pg_hba.conf file I have an entry like below:
> hostall all /32md5
That is an entry governing ordinary session connections ...
> Error that I got:
> pg_basebackup: error: FATAL: no pg_hba.conf entry for replication
> connection fro
Hi,
I have the postgres12 version running on centos7.
In pg_hba.conf file I have an entry like below:
hostall all /32md5
So from the above entry, I understand that all users can connect to all
databases from the remote ip.
But when I use pg_basebackup f
I'd like to express my appreciation for a project with a feature set so
extensive that a person might mistakenly assume that its goal was to cover
the spec comprehensively.
On Thu, Oct 26, 2023 at 10:32 AM Tom Lane wrote:
> Anders Kildemand writes:
> > What's the situation with Property Graph Q
On 10/26/23 07:42, Yongye Serkfem wrote:
Hello PostgreSQL Community,
I am having difficulties uninstalling ora2pg which I manually installed on
our Postgresql servers. I would appreciate any input on how to uninstall
it. Thanks everyone for your time.
Why do you have to uninstall it, when "ju
On 10/26/23 05:42, Yongye Serkfem wrote:
Hello PostgreSQL Community,
I am having difficulties uninstalling ora2pg which I manually installed
on our Postgresql servers. I would appreciate any input on how to
uninstall it. Thanks everyone for your time.
Need way more information:
1) ora2pg ver
On 10/26/23 03:56, Shaozhong SHI wrote:
If a PgAmin view is created and tables it queries are missing, what will
happen?
Easy enough to test:
create view test_vw as select * from non_existent_table;
ERROR: relation "non_existent_table" does not exist
LINE 1: create view test_vw as select * fr
Anders Kildemand writes:
> What's the situation with Property Graph Queries in Postgres?
There isn't any.
> I've heard that it has become part of the SQL standard from this blog:
> https://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new
> How far in development is th
Hello PostgreSQL Community,
I am having difficulties uninstalling ora2pg which I manually installed on
our Postgresql servers. I would appreciate any input on how to uninstall
it. Thanks everyone for your time.
Very Respectfully
Yong
Hello!
What's the situation with Property Graph Queries in Postgres?
I've heard that it has become part of the SQL standard from this blog:
https://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new
How far in development is this feature? and is there an expected time f
Hello PostgreSQL Community,
I've recently developed a tool named PostgresFly that I'd like to share
with you. It's a Python-crafted tool designed specifically for Windows
users to remotely install PostgreSQL on Linux machines directly from the
source.
This approach offers the benefits of customizat
On Thursday, October 26, 2023, Shaozhong SHI wrote:
> If a PgAmin view is created and tables it queries are missing, what will
> happen?
>
> If a PdAmin view is created, and it may take 20 hours to complete, what
> will happen?
>
> Would views automatically run, when you start the PgAmin?
>
>
Tes
On 2023-10-26 11:56:56 +0200, Olivier Gautherot wrote:
> El jue, 26 oct 2023 11:15, Peter J. Holzer escribió:
> On 2023-10-25 17:48:46 +0200, Olivier Gautherot wrote:
> > El mié, 25 oct 2023 16:58, Олег Самойлов escribió:
> > Okey, I see no one was be able to solve this problem. B
If a PgAmin view is created and tables it queries are missing, what will
happen?
If a PdAmin view is created, and it may take 20 hours to complete, what
will happen?
Would views automatically run, when you start the PgAmin?
Regards,
David
Hi,
El jue, 26 oct 2023 11:15, Peter J. Holzer escribió:
> On 2023-10-25 17:48:46 +0200, Olivier Gautherot wrote:
> > El mié, 25 oct 2023 16:58, Олег Самойлов escribió:
> > Okey, I see no one was be able to solve this problem. But I could.
> May be
> > for someone this will be useful to
On 2023-10-23 16:31:30 -0700, Adrian Klaver wrote:
> On 10/23/23 14:55, p...@pfortin.com wrote:
> > Next, I made a query list for 30 tables, turned on timing and pasted the
> > queries. Pasting results inline:
> > ncsbe=# select count(*) from ncvhis_2012_12_06;
> > select count(*) from ncvhis_2016
On 2023-10-25 17:48:46 +0200, Olivier Gautherot wrote:
> El mié, 25 oct 2023 16:58, Олег Самойлов escribió:
> Okey, I see no one was be able to solve this problem. But I could. May be
> for someone this will be useful too. There is solution.
[...]
> Now query is:
>
> SELECT genera
29 matches
Mail list logo
