Thread: Beta, alpha pages for 9.6b1 release
Patch attached. Also available from my github if that's easier: https://github.com/jberkus/pgweb -- -- Josh Berkus Red Hat OSAS (any opinions are my own)
Attachment
<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Link text for the ftp should reflect9.6beta; it says 9.5 RC</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br /></div><divclass="gmail_default" style="font-family:arial,helvetica,sans-serif">(I made a line edit on GitHub...then figuredposting here would save the next person effort).</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br/></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">DavidJ.</div></div><div class="gmail_extra"><br /><div class="gmail_quote">OnMon, May 9, 2016 at 4:41 PM, Josh berkus <span dir="ltr"><<a href="mailto:josh@agliodbs.com" target="_blank">josh@agliodbs.com</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px#ccc solid;padding-left:1ex">Patch attached.<br /><br /> Also available from my github if that's easier:<br/><a href="https://github.com/jberkus/pgweb" rel="noreferrer" target="_blank">https://github.com/jberkus/pgweb</a><br/><span class="HOEnZb"><font color="#888888"><br /> --<br /> --<br/> Josh Berkus<br /> Red Hat OSAS<br /> (any opinions are my own)<br /></font></span><br /><br /> --<br /> Sent viapgsql-www mailing list (<a href="mailto:pgsql-www@postgresql.org">pgsql-www@postgresql.org</a>)<br /> To make changesto your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-www" rel="noreferrer" target="_blank">http://www.postgresql.org/mailpref/pgsql-www</a><br/><br /></blockquote></div><br /></div>
On 05/09/2016 04:52 PM, David G. Johnston wrote: > Link text for the ftp should reflect 9.6beta; it says 9.5 RC > > (I made a line edit on GitHub...then figured posting here would save the > next person effort). New patch attached. -- -- Josh Berkus Red Hat OSAS (any opinions are my own)
Attachment
On 05/09/2016 04:52 PM, David G. Johnston wrote:
> Link text for the ftp should reflect 9.6beta; it says 9.5 RC
>
> (I made a line edit on GitHub...then figured posting here would save the
> next person effort).
New patch attached.
On 05/09/2016 05:52 PM, David G. Johnston wrote: > On Mon, May 9, 2016 at 5:11 PM, Josh berkus <josh@agliodbs.com > <mailto:josh@agliodbs.com>>wrote: > > On 05/09/2016 04:52 PM, David G. Johnston wrote: > > Link text for the ftp should reflect 9.6beta; it says 9.5 RC > > > > (I made a line edit on GitHub...then figured posting here would save the > > next person effort). > > New patch attached. > > Close... > > " > Download 9.6 Release Candidate 1 source code > " > > We will eventually have a RC1 - but this is not it. This is a Beta1. -- -- Josh Berkus Red Hat OSAS (any opinions are my own)
Attachment
Hola Lista.
Ando buscando una forma para medir por dia la carga de mis bases. Lo que deseo hacer es lo siguiente. (suma de peticiones, al server)
Ejemplo
1.- Peticion de inserción y no inserta porque x motivo ejemplo registro duplicado. (seria 1 movimiento)
2.- Consulta de registro. (Seria 2 movimientos).
3.- Peticion de inserción y lo inserta ala base (Seria 3 movimientos)
4.- Borrado de registro (seria 4 movimientos)
En total serian 4 registros, aunque si me voy a los registros solo veria 2 la inserción y el borrado. Estuve leyendo los siguientes link.
http://www.postgresql.org/docs/current/interactive/monitoring-stats.html
http://www.postgresql.org/docs/current/interactive/runtime-config-statistics.html
y no he logrado encontrar una forma para tener una stadistica de cómo hcaerlo, alguien lo a hecho?
Gracias
Enrique Escobar
Hola Lista.
Ando buscando una forma para medir por dia la carga de mis bases. Lo que deseo hacer es lo siguiente. (suma de peticiones, al server)
Ejemplo
1.- Peticion de inserción y no inserta porque x motivo ejemplo registro duplicado. (seria 1 movimiento)
2.- Consulta de registro. (Seria 2 movimientos).
3.- Peticion de inserción y lo inserta ala base (Seria 3 movimientos)
4.- Borrado de registro (seria 4 movimientos)
En total serian 4 registros, aunque si me voy a los registros solo veria 2 la inserción y el borrado. Estuve leyendo los siguientes link.
http://www.postgresql.org/docs/current/interactive/monitoring-stats.html
http://www.postgresql.org/docs/current/interactive/runtime-config-statistics.html
y no he logrado encontrar una forma para tener una stadistica de cómo hcaerlo, alguien lo a hecho?
Sorry.. (Language Error)....
Hello
I am seeking a way to measure the load by day of my bases. What I need is. (Sum of total requests to the server)
Example
1. insertion request and not inserted because x reason example duplicate record. ( 1 )
2. Consultation registration. ( 2 ).
3. Request insertion and inserts to the base (3)
4. Deleting registration (4)
Total would 4 requests. I was reading the following link.
http://www.postgresql.org/docs/current/interactive/monitoring-stats.html
http://www.postgresql.org/docs/current/interactive/runtime-config-statistics.html
and I have not managed to find a way to have a stadistica of requests to the server, someone else to do?
Gracias
Enrique Escobar
De: pgsql-www-owner@postgresql.org [mailto:pgsql-www-owner@postgresql.org] En nombre de David G. Johnston
Enviado el: lunes, 09 de mayo de 2016 20:30
Para: Enrique Escobar
CC: Josh berkus; PostgreSQL www
Asunto: Re: [pgsql-www] Stadisticas
2016-05-09 18:20 GMT-07:00 Enrique Escobar <ekurth@live.com.mx>:
Hola Lista.
Ando buscando una forma para medir por dia la carga de mis bases. Lo que deseo hacer es lo siguiente. (suma de peticiones, al server)
Ejemplo
1.- Peticion de inserción y no inserta porque x motivo ejemplo registro duplicado. (seria 1 movimiento)
2.- Consulta de registro. (Seria 2 movimientos).
3.- Peticion de inserción y lo inserta ala base (Seria 3 movimientos)
4.- Borrado de registro (seria 4 movimientos)
En total serian 4 registros, aunque si me voy a los registros solo veria 2 la inserción y el borrado. Estuve leyendo los siguientes link.
http://www.postgresql.org/docs/current/interactive/monitoring-stats.html
http://www.postgresql.org/docs/current/interactive/runtime-config-statistics.html
y no he logrado encontrar una forma para tener una stadistica de cómo hcaerlo, alguien lo a hecho?
Yeah...doing a reply-to-all on an unrelated thread
on an inappropriate list doesn't really endear you to people.
I speak zero Spanish and what Google Translate gives me isn't something I can reliably help with.
You should try the regional list(s).
What I can read says you need to learn how to output data to the log file and process it. For the most part you will need to use external to PostgreSQL tools to do so.
Some of these things seem application oriented and should be generated explicitly via events and not gleaned from transaction logs.
David J.
Sorry.. (Language Error)....
Hello
I am seeking a way to measure the load by day of my bases. What I need is. (Sum of total requests to the server)
Example
1. insertion request and not inserted because x reason example duplicate record. ( 1 )
2. Consultation registration. ( 2 ).
3. Request insertion and inserts to the base (3)
4. Deleting registration (4)
Total would 4 requests. I was reading the following link.
http://www.postgresql.org/docs/current/interactive/monitoring-stats.htmlhttp://www.postgresql.org/docs/current/interactive/runtime-config-statistics.html
and I have not managed to find a way to have a stadistica of requests to the server, someone else to do?
Hola Enrique, As David mentioned, this is the wrong mailing list for this stuff. ;) But, you are close. This is probably the one you want: http://www.postgresql.org/list/pgsql-es-ayuda/ You can subscribe to that using the page here: http://www.postgresql.org/community/lists/subscribe/ Hope that helps. :) Regards and best wishes, Justin Clift -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
<div dir="ltr"><br /><div class="gmail_extra"><br /><div class="gmail_quote">On Tue, May 10, 2016 at 1:25 PM, Justin Clift<span dir="ltr"><<a href="mailto:justin@postgresql.org" target="_blank">justin@postgresql.org</a>></span> wrote:<br/><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hola Enrique,<br/><br /> As David mentioned, this is the wrong mailing list for this stuff. ;)<br /><br /> But, you are close. This is probably the one you want:<br /><br /> <a href="http://www.postgresql.org/list/pgsql-es-ayuda/" rel="noreferrer"target="_blank">http://www.postgresql.org/list/pgsql-es-ayuda/</a><br /><br /> You can subscribe to thatusing the page here:<br /><br /> <a href="http://www.postgresql.org/community/lists/subscribe/" rel="noreferrer" target="_blank">http://www.postgresql.org/community/lists/subscribe/</a><br/><br /> Hope that helps. :)<br /><br /> Regardsand best wishes,<br /><br /> Justin Clift<br /><br /> --<br /> "My grandfather once told me that there are two kindsof people: those<br /> who work and those who take the credit. He told me to try to be in the<br /> first group; therewas less competition there."<br /> - Indira Gandhi<br /><span class="HOEnZb"><font color="#888888"><br /><br /><br />--<br /> Sent via pgsql-www mailing list (<a href="mailto:pgsql-www@postgresql.org">pgsql-www@postgresql.org</a>)<br />To make changes to your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-www" rel="noreferrer" target="_blank">http://www.postgresql.org/mailpref/pgsql-www</a><br/></font></span></blockquote></div><br /></div><div class="gmail_extra">Inaddition to previous advice, I strongly recommend you look into PgBadger <a href="https://dalibo.github.io/pgbadger/">https://dalibo.github.io/pgbadger/</a><br/></div><div class="gmail_extra">It willgive you a lot more insight into your queries, above and beyond pg_stats. Download from here <a href="https://sourceforge.net/projects/pgbadger/">https://sourceforge.net/projects/pgbadger/</a><brclear="all" /></div><divclass="gmail_extra"><br />-- <br /><div class="gmail_signature"><div dir="ltr"><font size="4"><b><span style="font-family:couriernew,monospace">Melvin Davidson</span></b></font><br /><font size="3" style="font-weight:bold"><spanstyle="color:rgb(128,0,255)">I reserve the right to fantasize. Whether or not you </span><brstyle="color:rgb(128,0,255)" /><span style="color:rgb(128,0,255)">wish to share my fantasy is entirely up to you.</span><img src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif" style="color:rgb(128,0,255)" /></font><br/></div></div></div></div>