Hi,
I have a question about parallel plans. I also posted it on the general list
but perhaps it's a question for hackers. Here is my test case :
select version();
version
Envoyé : lundi 23 novembre 2020 06:04
À : Phil Florent
Cc : pgsql-hackers@lists.postgresql.org
Objet : Re: Parallel plans and "union all" subquery
On Sun, Nov 22, 2020 at 11:51 PM Phil Florent wrote:
>
>
> Hi,
>
>
> I have a question about parallel plans. I also p
Thanks, ran the original test and it works great after the patch.
Phil
De : Robert Haas
Envoyé : jeudi 22 mars 2018 18:17
À : Peter Geoghegan
Cc : Andres Freund; Phil Florent; PostgreSQL Hackers
Objet : Re: pgstat_report_activity() and parallel CREATE INDEX
Hi,
We are still on the process to migrate our applications from proprietary RDBMS
to PostgreSQL.
Here is a simple query executed on various systems (real query is different but
this one does not need any data) :
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Produ
Hi,
Thank you, as you mentionned it's not really an interesting real life case
anyway.
Regards,
Phil
De : Pavel Stehule
Envoyé : lundi 25 novembre 2019 21:23
À : Phil Florent
Cc : pgsql-hack...@postgresql.org
Objet : Re: GROUPING SETS and SQL standard
with PostgreSQL, not with Oracle.
Hence it means it's PostgreSQL which conforms to the standard in this case.
Regards,
Phil
De : Phil Florent
Envoyé : lundi 25 novembre 2019 22:18
À : Pavel Stehule
Cc : pgsql-hack...@postgresql.org
Objet : RE: GROUPING SE
be a problem anymore.
Regards
Phil
De : Tom Lane
Envoyé : mardi 26 novembre 2019 01:39
À : Phil Florent
Cc : Pavel Stehule ; pgsql-hack...@postgresql.org
Objet : Re: GROUPING SETS and SQL standard
Phil Florent writes:
> A of () (called grand total in the Standard) i
"snapper" and it is also based on
sampling.
Best regards
Phil
De : Yotsunaga, Naoki
Envoyé : lundi 29 octobre 2018 02:20
À : 'Phil Florent'; 'Michael Paquier'
Cc : 'Tomas Vondra'; 'pgsql-hackers@lists.postgresql.org
Langote
Envoyé : jeudi 9 août 2018 06:35
À : Tom Lane
Cc : David Rowley; Rushabh Lathia; Alvaro Herrera; Robert Haas; Phil Florent;
PostgreSQL Hackers
Objet : Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1
on Debian
On 2018/08/09 13:00, Tom Lane wrote:
> Amit Langote wri
Hi,
Historically many public hospitals I work for had IBM Power hardware.
The SMT8 (8 threads/cores) capabilities of Power CPU are useful to lower Oracle
licence & support cost. We migrate to PostgreSQL and it runs very well on
Power, especially since the (relatively) recent parallel executions f
ly we will have this encryption thing or perhaps we will be obliged to
go back to the proprietary RDBMS for some needs even if the feature is in fact
mostly useless...
Best regards,
Phil
De : Amit Kapila
Envoyé : lundi 3 avril 2023 06:07
À : Phil Florent
Cc : vignesh
Hi,
Not very convenient but if autovacuum is enabled isn't vacuum_defer_cleanup_age
the way to make extensions like pg_dirtyread more effective for temporal
queries to quickly correct human DML mistakes without the need of a complete
restore, even if no standby is in use ? vacuum_defer_cleanup
Hi,
I opened an issue with an attached code on oracle_fdw git page :
https://github.com/laurenz/oracle_fdw/issues/534
Basically I expected to obtain a "no privilege" error from PostgreSQL when I
have no read privilege on the postgres foreign table but I obtained an Oracle
error instead.
Laurenz
Hi,
Thanks for your explanations.
Test case had no real-world logic anyway. It was just an oversight in a
one-time use legacy migration script.
Regards,
Phil
From: Laurenz Albe
Sent: Friday, June 10, 2022 11:17:07 AM
To: Etsuro Fujita
Cc: Kyotaro Horiguchi ; eu..
Hi,
A DSS developer from my company, Julien Roze, reported me an error I cannot
explained. Is it a new behavior or a bug ?
Original query is much more complicated but here is a simplified test case with
postgresql 14 and 15 beta 2 on Debian 11, packages from pgdg :
Ver Cluster Port Status Owne
Hi,
I am very interested in this feature that will conform to the SQL standard and
I read that :
Session 1:
create global temp table gtt(x integer);
insert into gtt values (generate_series(1,10));
Session 2:
insert into gtt values (generate_series(1,20));
Session1:
create
Hi,
I should post that in the general section but I am confused by the sentence "A
parent partition is always going to have a lower relid than its children"
In the code, relid has many meanings and not only "oid of a class" as in
https://www.postgresql.org/message-id/20910.734...@sss.pgh.
I get it. Thank you for this precision.
Regards
Phil
De : David Rowley
Envoyé : lundi 16 juillet 2018 07:48
À : Phil Florent
Cc : Tom Lane; Robert Haas; Amit Langote; PostgreSQL Hackers
Objet : Re: Internal error XX000 with enable_partition_pruning=on, pg 11
Hi,
I am skeptical about accumulated statistics.
pg_stat_activity now gives necessary information about wait events. It can be
easily be used with a polling system that sleeps most of the time to limit the
overhead. Measuring the duration of individual wait events is not necessary to
know the
Hi,
> Some case, sampling of events can not find the cause of issue. It lose detail
> data.
> For example, some throughput issue occur(ex : disk io), but each wait point
> occurs only a few milliseconds.
It loses non meaningful details and it's in fact a good point. In this example,
sampling
Hi,
I agree with that. PostgreSQL 10 is really great, tuning tools based on
sampling of pg_stat_activity became accurate without any modification.
Best regards
Phil
De : Michael Paquier
Envoyé : jeudi 26 juillet 2018 03:24
À : Phil Florent
Cc : Tomas Vondra
Hi,
I obtained an XX000 error testing my DSS application with PostgreSQL 11 beta 1.
Here is a simplified version of my test, no data in the tables :
-- 11
select version();
version
st regards
Phil
De : Yotsunaga, Naoki
Envoyé : jeudi 4 octobre 2018 10:31
À : 'Michael Paquier'; Phil Florent
Cc : Tomas Vondra; pgsql-hackers@lists.postgresql.org
Objet : RE: [Proposal] Add accumulated statistics for wait event
On Thu, July 26, 2018 at 1:25 AM, Michael Paquier wrote:
ctivty() was not called by workers in
parallel index creation)
Best regards
Phil
De : Michael Paquier
Envoyé : jeudi 4 octobre 2018 12:58
À : Phil Florent
Cc : Yotsunaga, Naoki; Tomas Vondra; pgsql-hackers@lists.postgresql.org
Objet : Re: [Proposal] Add accumulated statistics for wait event
On
24 matches
Mail list logo
