Thread: Beta, alpha pages for 9.6b1 release

Beta, alpha pages for 9.6b1 release

From
Josh berkus
Date:
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

Re: Beta, alpha pages for 9.6b1 release

From
"David G. Johnston"
Date:
<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> 

Re: Beta, alpha pages for 9.6b1 release

From
Josh berkus
Date:
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

Re: Beta, alpha pages for 9.6b1 release

From
"David G. Johnston"
Date:
On Mon, May 9, 2016 at 5:11 PM, Josh berkus <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.

David J.

Re: Beta, alpha pages for 9.6b1 release

From
Josh berkus
Date:
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

Stadisticas

From
Enrique Escobar
Date:

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

 

Re: Stadisticas

From
"David G. Johnston"
Date:
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.

Re: Stadisticas

From
Enrique Escobar
Date:

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.

Re: Stadisticas

From
"David G. Johnston"
Date:
On Mon, May 9, 2016 at 6:50 PM, Enrique Escobar <ekurth@live.com.mx> wrote:

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?



​That looks just like what Google Translate showed me.....​

The only thing I can tell from the above is that you sending this email to the mailing list for topics related to the PostgreSQL website is wrong.

Also, on these lists the convention is to bottom-post - like I am doing now.

​If you wish to post in English I'd suggest directing your inquiry to:

pgsql-admin
​Otherwise I've already told you where you can hopefully find more help with a reduced language barrier.

David J.

Re: Stadisticas

From
Justin Clift
Date:
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




Re: Stadisticas

From
Melvin Davidson
Date:
<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>