pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedStatistics
14+ messages / 10 participants
[nested] [flat]
* Statistics
@ 2002-04-01 16:15 Hunter, Ray <rhunter@enterasys.com>
2002-04-01 16:24 ` Re: Statistics Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 14+ messages in thread
From: Hunter, Ray @ 2002-04-01 16:15 UTC (permalink / raw)
To: pgsql-sql
In the postgresql.conf file there is the option for statistics. Where are
the statistics posted or recorded at?
Thank you,
Ray Hunter
Firmware Engineer
ENTERASYS NETWORKS
Internal: 53888
External: 801 887-9888
Email: rhunter@enterasys.com
www: www.enterasys.com
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Statistics
2002-04-01 16:15 Statistics Hunter, Ray <rhunter@enterasys.com>
@ 2002-04-01 16:24 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 14+ messages in thread
From: Bruce Momjian @ 2002-04-01 16:24 UTC (permalink / raw)
To: Hunter, Ray <rhunter@enterasys.com>; +Cc: pgsql-sql
Hunter, Ray wrote:
> In the postgresql.conf file there is the option for statistics. Where are
> the statistics posted or recorded at?
They appear in system tables pg_stat*.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Statistics
@ 2002-04-01 16:25 Hunter, Ray <rhunter@enterasys.com>
2002-04-01 17:35 ` Re: Statistics Marin Dimitrov <marin.dimitrov@sirma.bg>
0 siblings, 1 reply; 14+ messages in thread
From: Hunter, Ray @ 2002-04-01 16:25 UTC (permalink / raw)
To: 'Bruce Momjian' <pgman@candle.pha.pa.us>; +Cc: pgsql-sql
Is there some additional documentation of configuring the postgresql.conf
file?
Thank you,
Ray Hunter
Firmware Engineer
ENTERASYS NETWORKS
> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> Sent: Monday, April 01, 2002 9:24 AM
> To: Hunter, Ray
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Statistics
>
>
> Hunter, Ray wrote:
> > In the postgresql.conf file there is the option for
> statistics. Where
> > are the statistics posted or recorded at?
>
> They appear in system tables pg_stat*.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill,
> Pennsylvania 19026
>
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Statistics
2002-04-01 16:25 Re: Statistics Hunter, Ray <rhunter@enterasys.com>
@ 2002-04-01 17:35 ` Marin Dimitrov <marin.dimitrov@sirma.bg>
0 siblings, 0 replies; 14+ messages in thread
From: Marin Dimitrov @ 2002-04-01 17:35 UTC (permalink / raw)
To: Hunter, Ray <rhunter@enterasys.com>; +Cc: pgsql-sql
RE: [SQL] Statistics
chapter 3.4 "Runtime configuration" from the Administrator's Guide (http://www.ca.postgresql.org/users-lounge/docs/#7.2) describes the parameters in the postgresql.conf file
hth,
Marin
----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "
----- Original Message -----
From: Hunter, Ray
To: 'Bruce Momjian'
Cc: pgsql-sql@postgresql.org
Sent: Monday, April 01, 2002 19:25
Subject: Re: [SQL] Statistics
Is there some additional documentation of configuring the postgresql.conf file?
^ permalink raw reply [nested|flat] 14+ messages in thread
* STATISTICS?
@ 2002-08-03 19:26 Josh Berkus <josh@agliodbs.com>
2002-08-03 19:58 ` Re: STATISTICS? mallah@trade-india.com
0 siblings, 1 reply; 14+ messages in thread
From: Josh Berkus @ 2002-08-03 19:26 UTC (permalink / raw)
To: pgsql-sql
Folks,
Can anyone point me to documentation on the new STATISTICS features of
7.2? I can't seem to find anything in the online docs, except the
barest mention of ALTER TABLE SET STATISTICS (which doesn't explain
what to do with the info).
-Josh Berkus
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: STATISTICS?
2002-08-03 19:26 STATISTICS? Josh Berkus <josh@agliodbs.com>
@ 2002-08-03 19:58 ` mallah@trade-india.com
2002-08-04 00:31 ` Re: STATISTICS? Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 14+ messages in thread
From: mallah@trade-india.com @ 2002-08-03 19:58 UTC (permalink / raw)
To: josh@agliodbs.com; +Cc: pgsql-sql
do you need
http://www.postgresql.org/idocs/index.php?monitoring-stats.html ?
Folks,
>
> Can anyone point me to documentation on the new STATISTICS features of 7.2? I can't seem to
> find anything in the online docs, except the barest mention of ALTER TABLE SET STATISTICS
> (which doesn't explain what to do with the info).
>
> -Josh Berkus
>
> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you
> searched our list archives?
>
> http://archives.postgresql.org
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: STATISTICS?
2002-08-03 19:26 STATISTICS? Josh Berkus <josh@agliodbs.com>
2002-08-03 19:58 ` Re: STATISTICS? mallah@trade-india.com
@ 2002-08-04 00:31 ` Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 14+ messages in thread
From: Josh Berkus @ 2002-08-04 00:31 UTC (permalink / raw)
To: mallah@trade-india.com; josh@agliodbs.com; +Cc: pgsql-sql
Mallah,
> do you need
> http://www.postgresql.org/idocs/index.php?monitoring-stats.html ?
Yes, thank you! That was exactly what I was looking for.
-Josh Berkus
^ permalink raw reply [nested|flat] 14+ messages in thread
* Statistics
@ 2007-03-09 17:22 Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2007-03-09 17:35 ` Re: [SQL] Statistics Joe <dev@freedomcircle.net>
0 siblings, 1 reply; 14+ messages in thread
From: Ezequias Rodrigues da Rocha @ 2007-03-09 17:22 UTC (permalink / raw)
To: pgsql-sql; Pgadmin-Support <pgadmin-support@postgresql.org>
Hi list,
Does someone have statistcs from PostgreSQL ? Numbers from the list,
performance statistics. I must argue with another person the idea of do not
put Oracle in our organization.
We are quite well with postgresql and I have no plans to change my
plataform.
Regards
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [SQL] Statistics
2007-03-09 17:22 Statistics Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
@ 2007-03-09 17:35 ` Joe <dev@freedomcircle.net>
2007-03-09 17:40 ` Statistics Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2007-03-09 18:00 ` Re: [SQL] Statistics Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
0 siblings, 2 replies; 14+ messages in thread
From: Joe @ 2007-03-09 17:35 UTC (permalink / raw)
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>; +Cc: pgsql-sql; Pgadmin-Support <pgadmin-support@postgresql.org>
On Fri, 2007-03-09 at 14:22 -0300, Ezequias Rodrigues da Rocha wrote:
> Does someone have statistcs from PostgreSQL ? Numbers from the list,
> performance statistics. I must argue with another person the idea of
> do not put Oracle in our organization.
>
> We are quite well with postgresql and I have no plans to change my
> plataform.
Allow me to quote from my response to your previous message back in
November:
On Fri, 2006-11-24 at 11:07 -0200, Ezequias Rodrigues da Rocha wrote:
> Does anybody have numbers of PostgreSQL in action ?
>
> Numbers like the biggest insert in mileseconds, the larger database
etc ?
First, you may want to post this in the GENERAL or in the PERFORMANCE
lists since this isn't really about SQL.
Second, you may want to look at the case studies page:
http://www.postgresql.org/about/casestudies/.
Third, the companies like EnterpriseDB and Pervasive may have some of
what you're looking for since they have to measure themselves against
the competition.
And remember to take any numbers with a large grain of salt, YMMV, etc.
Joe
^ permalink raw reply [nested|flat] 14+ messages in thread
* Statistics
2007-03-09 17:22 Statistics Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2007-03-09 17:35 ` Re: [SQL] Statistics Joe <dev@freedomcircle.net>
@ 2007-03-09 17:40 ` Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2007-03-10 01:16 ` Re: Statistics Jeff Davis <pgsql@j-davis.com>
1 sibling, 1 reply; 14+ messages in thread
From: Ezequias Rodrigues da Rocha @ 2007-03-09 17:40 UTC (permalink / raw)
To: pgsql general <pgsql-general@postgresql.org>
On Fri, 2007-03-09 at 14:22 -0300, Ezequias Rodrigues da Rocha wrote:
Does someone have statistcs from PostgreSQL ? Numbers from the list,
performance statistics. I must argue with another person the idea of
do not put Oracle in our organization.
We are quite well with postgresql and I have no plans to change my
plataform.
Ezequias
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Statistics
2007-03-09 17:22 Statistics Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2007-03-09 17:35 ` Re: [SQL] Statistics Joe <dev@freedomcircle.net>
2007-03-09 17:40 ` Statistics Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
@ 2007-03-10 01:16 ` Jeff Davis <pgsql@j-davis.com>
0 siblings, 0 replies; 14+ messages in thread
From: Jeff Davis @ 2007-03-10 01:16 UTC (permalink / raw)
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>; +Cc: pgsql general <pgsql-general@postgresql.org>
On Fri, 2007-03-09 at 14:40 -0300, Ezequias Rodrigues da Rocha wrote:
>
> On Fri, 2007-03-09 at 14:22 -0300, Ezequias Rodrigues da Rocha wrote:
> Does someone have statistcs from PostgreSQL ? Numbers from the list,
> performance statistics. I must argue with another person the idea of
>
> do not put Oracle in our organization.
>
> We are quite well with postgresql and I have no plans to change my
> plataform.
>
If PostgreSQL is working well, then continue using it.
If you (or another person) are concerned about scalability for the
future, call one of the commercial PostgreSQL support companies listed
here:
http://www.postgresql.org/support/professional_support
They can guide you through the process to make sure that your
implementation scales according to your needs.
Or, just ask more specific questions on this list, and people will be
glad to help.
Regards,
Jeff Davis
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [SQL] Statistics
2007-03-09 17:22 Statistics Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2007-03-09 17:35 ` Re: [SQL] Statistics Joe <dev@freedomcircle.net>
@ 2007-03-09 18:00 ` Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
1 sibling, 0 replies; 14+ messages in thread
From: Hiltibidal, Robert @ 2007-03-09 18:00 UTC (permalink / raw)
To: Joe <dev@freedomcircle.net>; Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>; +Cc: pgsql-sql; Pgadmin-Support <pgadmin-support@postgresql.org>
Joe is quite right about comparing stats. Unless things are equal across
the board (database, tables, data, hardware, software) results will
always differ.
Another consideration and this may be painful, is consider what Oracle
support may be able to offer. Executives do not want to hear the core of
their operations went down at 3 am and are still down pending answer to
e-mail based support questions. There is benefit when IBM/Oracle can
have someone onsite in off hours if that level of support is needed.
DBA's/sysadmins/developers are always looking for the best way to
accomplish a goal depending on hardware/software/skillset availability.
Bean counters are always looking for the best way to accomplish a goal
balancing operational costs with profitability. Open source isn't always
the most profitable solution.
Good profitability is usually a balance between open source and
commercial.
-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Joe
Sent: Friday, March 09, 2007 11:36 AM
To: Ezequias Rodrigues da Rocha
Cc: PostgreSQL; Pgadmin-Support
Subject: Re: [SQL] Statistics
On Fri, 2007-03-09 at 14:22 -0300, Ezequias Rodrigues da Rocha wrote:
> Does someone have statistcs from PostgreSQL ? Numbers from the list,
> performance statistics. I must argue with another person the idea of
> do not put Oracle in our organization.
>
> We are quite well with postgresql and I have no plans to change my
> plataform.
Allow me to quote from my response to your previous message back in
November:
On Fri, 2006-11-24 at 11:07 -0200, Ezequias Rodrigues da Rocha wrote:
> Does anybody have numbers of PostgreSQL in action ?
>
> Numbers like the biggest insert in mileseconds, the larger database
etc ?
First, you may want to post this in the GENERAL or in the PERFORMANCE
lists since this isn't really about SQL.
Second, you may want to look at the case studies page:
http://www.postgresql.org/about/casestudies/.
Third, the companies like EnterpriseDB and Pervasive may have some of
what you're looking for since they have to measure themselves against
the competition.
And remember to take any numbers with a large grain of salt, YMMV, etc.
Joe
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
PRIVILEGED AND CONFIDENTIAL
This email transmission contains privileged and confidential information intended only for the use of the individual or entity named above. If the reader of the email is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any use, dissemination or copying of this email transmission is strictly prohibited by the sender. If you have received this transmission in error, please delete the email and immediately notify the sender via the email return address or mailto:postmaster@argushealth.com. Thank you.
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Statistics
@ 2007-03-09 17:59 Frank Bax <fbax@sympatico.ca>
2007-03-09 18:07 ` Re: Statistics Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
0 siblings, 1 reply; 14+ messages in thread
From: Frank Bax @ 2007-03-09 17:59 UTC (permalink / raw)
To: pgsql-sql
At 12:22 PM 3/9/07, Ezequias Rodrigues da Rocha wrote:
>Does someone have statistcs from PostgreSQL ? Numbers from the list,
>performance statistics. I must argue with another person the idea of do
>not put Oracle in our organization.
Performance should not be the *only* consideration when comparing products.
Any test to compare products done by someone else may not reflect the type
of work you plan to do with the product. Different tests could easily
favour different products. Your hardware and OS might favour a different
result than my hardware and OS. Therefore, only your own comparisons
(performance or otherwise) can produce meaningful results.
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Statistics
2007-03-09 17:59 Re: Statistics Frank Bax <fbax@sympatico.ca>
@ 2007-03-09 18:07 ` Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
0 siblings, 0 replies; 14+ messages in thread
From: Ezequias Rodrigues da Rocha @ 2007-03-09 18:07 UTC (permalink / raw)
To: Frank Bax <fbax@sympatico.ca>; +Cc: pgsql-sql
Thank you all. Those are quite important questions to considerate. About the
late time of requisitions. I allways have replyes becouse 3:00 am in brazil
does not means 3:00 in many other countries.
I experiment it in other free communities too.
My Brat Regards
Ezequias
2007/3/9, Frank Bax <fbax@sympatico.ca>:
>
> At 12:22 PM 3/9/07, Ezequias Rodrigues da Rocha wrote:
> >Does someone have statistcs from PostgreSQL ? Numbers from the list,
> >performance statistics. I must argue with another person the idea of do
> >not put Oracle in our organization.
>
>
> Performance should not be the *only* consideration when comparing
> products.
>
> Any test to compare products done by someone else may not reflect the type
> of work you plan to do with the product. Different tests could easily
> favour different products. Your hardware and OS might favour a different
> result than my hardware and OS. Therefore, only your own comparisons
> (performance or otherwise) can produce meaningful results.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/
^ permalink raw reply [nested|flat] 14+ messages in thread
end of thread, other threads:[~2007-03-10 01:16 UTC | newest]
Thread overview: 14+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-01 16:15 Statistics Hunter, Ray <rhunter@enterasys.com>
2002-04-01 16:24 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-04-01 16:25 Re: Statistics Hunter, Ray <rhunter@enterasys.com>
2002-04-01 17:35 ` Marin Dimitrov <marin.dimitrov@sirma.bg>
2002-08-03 19:26 STATISTICS? Josh Berkus <josh@agliodbs.com>
2002-08-03 19:58 ` Re: STATISTICS? mallah@trade-india.com
2002-08-04 00:31 ` Re: STATISTICS? Josh Berkus <josh@agliodbs.com>
2007-03-09 17:22 Statistics Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2007-03-09 17:35 ` Joe <dev@freedomcircle.net>
2007-03-09 17:40 ` Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2007-03-10 01:16 ` Jeff Davis <pgsql@j-davis.com>
2007-03-09 18:00 ` Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
2007-03-09 17:59 Re: Statistics Frank Bax <fbax@sympatico.ca>
2007-03-09 18:07 ` Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox