Dear all
I have successfully installed POWA (http://dalibo.github.io/powa),
including all required extensions, see the following Printscreen of its
operation of end email.
But when executing queries in psql- comand line, this queries are not
monitored by powa. I have checked that only Postgresql
Neto
2017-10-31 15:19 GMT-02:00 Anthony Sotolongo :
> Hi Neto, maybe HypoPG
> Can help you:
>
> https://github.com/dalibo/hypopg
>
> El 31 oct. 2017 2:13 PM, "Neto pr" escribió:
>
>>
>> Hello All I'm researching on Index-Advisor Tools t
Hello All I'm researching on Index-Advisor Tools to be applied in SQL
queries. At first I found this: - EnterpriseDB -
https://www.enterprisedb.com/docs/en/9.5/asguide/EDB_Postgres_Advanced_Server_Guide.1.56.html
Someone would know of other tools for this purpose. I'd appreciate it if
you can help
L.mode, c.relname, locktype, l.GRANTED, l.transactionid,
virtualtransaction
FROM pg_locks l, pg_class c
where c.oid = l.relation
screen result after concurrency: https://i.stack.imgur.com/htzIY.jpg
Now, I'm waiting to finish creating the index.
2017-10-11 19:54 GMT-03:00 Neto pr :
> H
Tomas Vondra :
>
>
> On 10/11/2017 04:11 PM, Neto pr wrote:
> >
> > 2017-10-11 10:46 GMT-03:00 Laurenz Albe > <mailto:laurenz.a...@cybertec.at>>:
> >
> > Neto pr wrote:
> > > When creating index on table of approximately 10GB of dat
2017-10-11 10:46 GMT-03:00 Laurenz Albe :
> Neto pr wrote:
> > When creating index on table of approximately 10GB of data, the DBMS
> hangs (I think),
> > because even after waiting 10 hours there was no return of the command.
> > It happened by creating Hash inde
Hello all,
My scenario is: postgresql 10, Processor Xeon 2.8GHz / 4-core- 8gb Ram, OS
Debian 8.
When creating index on table of approximately 10GB of data, the DBMS hangs
(I think), because even after waiting 10 hours there was no return of the
command. It happened by creating Hash indexes and B
2:52 PM, Neto pr wrote:
> > I am using Postgresql extension pageinspect.
> >
> > Could someone tell me the meaning of these columns: magic, version, root,
> > level, fastroot, fastlevel of the bt_metap function.
> >
> > This information is not presents in the doc
Hello All
I am using Postgresql extension pageinspect.
Could someone tell me the meaning of these columns: magic, version, root,
level, fastroot, fastlevel of the bt_metap function.
This information is not presents in the documentation.
The height of the b-tree (position of node farthest from r
, referring to the
height of the index tree?
Regards
2017-09-08 6:44 GMT-07:00 Tom Lane :
> Neto pr writes:
> > After analyzing, I saw that in some places of the plan, it is being used
> > Parallelism. Does this explain why the final value spent (in minutes) to
> go
> > throug
ce-
> ow...@postgresql.org] *On Behalf Of *Neto pr
> *Sent:* Thursday, September 07, 2017 11:17 PM
> *To:* pgsql-performance@postgresql.org
> *Subject:* [PERFORM] Explain Analyze - actual time in loops
>
>
>
> …
>
> ##
Dear,
I'm trying to interpret an Explain Analyze, but I did not understand this:
-> According to the Postgresql documentation at: https://www.postgresql.org/
docs/9.6/static/using-explain.html
" the loops value reports the total number of executions of the node, and
the actual time and rows value
2017-08-25 5:31 GMT-03:00 Neto pr :
> Dear all
>
> Someone help me analyze the execution plans below, is the query 12 of
> TPC-H benchmark [1].
> I need to find out why the query without index runs faster (7 times)
> than with index, although the costs are smaller (see tabl
Dear all
Someone help me analyze the execution plans below, is the query 12 of
TPC-H benchmark [1].
I need to find out why the query without index runs faster (7 times)
than with index, although the costs are smaller (see table).
I have other cases that happened in the same situation. The server
14 matches
Mail list logo