explain-output nor the error-message.
Without this it's pretty much guess-work...
--
Andreas Joseph Krogh
them in your partial-index.
--
Andreas Joseph Krogh
ividual_entity_proxy_id"
> left join "cms_prospects".INDIVIDUAL_DEMOGRAPHIC T2 on
T0."individual_entity_proxy_id" = T2."individual_entity_proxy_id"
Pardon me for saying so, but this query seems silly.
It's self-joining a table on its PK, which I don't think could ever be useful.
Where is the self-join?
--
Andreas Joseph Krogh
P's query is recursive, sow no inlining will take place...
--
Andreas Joseph Krogh
>https://blog.gojekengineering.com/a-toast-from-postgresql-83b83d0d0683
>When I execute this query, except JSON data like;
>SELECT paramuser_id, paramperson_id, paramisdeleted, paramactiontime
> FROM zamazin;
>It takes 94 ms. :)
>
>
>Andreas Joseph Krogh , 7 Şub 2020 Cum, 17:42 tarihinde
>şunu
På fredag 07. februar 2020 kl. 15:35:04, skrev Asya Nevra Buyuksoy <
ayisan1...@gmail.com <mailto:ayisan1...@gmail.com>>:
I use pgadmin3.
Try "psql", it has the lowest overhead (I think). pgAdmin might use time
presenting the results etc. which is easy to overlook.
--
Andreas Joseph Krogh
På fredag 07. februar 2020 kl. 15:16:13, skrev Asya Nevra Buyuksoy <
ayisan1...@gmail.com <mailto:ayisan1...@gmail.com>>:
Andreas Joseph Krogh wrote on 2/7/2020 8:41 AM:
På fredag 07. februar 2020 kl. 14:23:35, skrev Asya Nevra Buyuksoy <
ayisan1...@gmail.com <mailto:ay
e that this
relates to the TOAST structure.
My guess is the time is spent in the client retrieving the data, not in the DB
itself. Are you on a slow network?
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
se you'll be encurraged to upgrade to latest version (12.1) as
9.4.1 is now 5 years old..
--
Andreas Joseph Krogh
in general) ismuch faster with
SSD. -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com> www.visena.com
<https://www.visena.com> <https://www.visena.com>
ed off
when upgrading.
That's what we'll do, unfortunately:-( -- Andreas Joseph Krogh CTO / Partner -
Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com> <https://www.visena.com>
ies so we'll turn JIT=off until we can mesure performance-gain. -- Andreas
Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com
<mailto:andr...@visena.com> www.visena.com <https://www.visena.com>
<https://www.visena.com>
vents from using parallelism ?
Thanks.
Laurent Set in postgresql.conf: log_statement = 'all' reload settings and
check the logs for what statemets are acutally issued. -- Andreas Joseph Krogh
CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com
<mailto:andr...@vise
ugh all params for more
understanding Happy to help :) Prince Pathria Systems Architect Intern Evive
+91 9478670472goevive.com <http://goevive.com> There's no such thing as PCIe
SATA, use PCIe or NVMe in RAID-10, it's quite affordable these days and
meaningless not to use. --
Andreas Joseph Krogh
Do you know if the the circuit board has capacitors?
Don't know, sorry...
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På fredag 11. mai 2018 kl. 14:11:39, skrev Mark Kirkwood <
mark.kirkw...@catalyst.net.nz <mailto:mark.kirkw...@catalyst.net.nz>>:
On 11/05/18 23:23, Andreas Joseph Krogh wrote:
> På onsdag 09. mai 2018 kl. 22:00:16, skrev Andreas Joseph Krogh
> mailto:andr...@visena.com>&g
På onsdag 09. mai 2018 kl. 22:00:16, skrev Andreas Joseph Krogh <
andr...@visena.com <mailto:andr...@visena.com>>:
På tirsdag 10. april 2018 kl. 19:41:59, skrev Craig James <
cja...@emolecules.com <mailto:cja...@emolecules.com>>:
On Tue, Apr 10, 2018 at 12:21
På tirsdag 10. april 2018 kl. 19:41:59, skrev Craig James mailto:cja...@emolecules.com>>:
On Tue, Apr 10, 2018 at 12:21 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På tirsdag 10. april 2018 kl. 04:36:27,
skrev Craig James mailto:cja...@emolecules.com>>:
On
stem peaks at about 7000 TPS from pgbench.
With what arguments (also initialization)?
--
Andreas Joseph Krogh
u've not told us anything about table/index-size but I believe reading those
from disk is the culprit here.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
untime-config-query.html#GUC-EFFECTIVE-CACHE-SIZE
-- Andreas Joseph Krogh
21 matches
Mail list logo
