Re: [SQL] Statistics

2007-03-09 Thread Ezequias Rodrigues da Rocha
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 <[EMA

Re: [SQL] Statistics

2007-03-09 Thread Frank Bax
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 compa

Re: [SQL] Statistics

2007-03-09 Thread Joe
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 h

[SQL] Statistics

2007-03-09 Thread Ezequias Rodrigues da Rocha
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

Re: [SQL] Statistics from Sequences

2005-09-08 Thread Michael Fuhr
[Again, please copy the mailing list on replies so others can participate in and learn from the discussion.] On Thu, Sep 08, 2005 at 06:25:33PM -0300, Joÿffe3o Carvalho wrote: > There's one thing. If the sequence name was fooseq in uppercase > (FOOSEQ) it does not work. In that case it ret

Re: [SQL] Statistics from Sequences

2005-09-08 Thread Joÿffffffffffe3o Carvalho
Michael Fuhr <[EMAIL PROTECTED]> escreveu: [Please copy the mailing list on replies so others can participatein and learn from the discussion.]On Thu, Sep 08, 2005 at 02:32:12PM -0300, Joÿffe3o Carvalho wrote:> Can you give me a help about:> > > The min value> > The max value> > The increm

Re: [SQL] Statistics from Sequences

2005-09-08 Thread Michael Fuhr
[Please copy the mailing list on replies so others can participate in and learn from the discussion.] On Thu, Sep 08, 2005 at 02:32:12PM -0300, Joÿffe3o Carvalho wrote: > Can you give me a help about: > > >The min value > >The max value > >The increment value > >The last u

Re: [SQL] Statistics from Sequences

2005-09-06 Thread Bruno Wolff III
On Tue, Sep 06, 2005 at 23:43:44 -0300, Joÿffe3o Carvalho <[EMAIL PROTECTED]> wrote: > Is it possible to get from a sequence: > >The sequence owner >The min value >The max value >The increment value >The last used number Yes. Associated with each sequence is a one ro

Re: [SQL] Statistics from Sequences

2005-09-06 Thread Michael Fuhr
On Tue, Sep 06, 2005 at 11:43:44PM -0300, Joÿffe3o Carvalho wrote: > Is it possible to get from a sequence: > >The sequence owner >The min value >The max value >The increment value >The last used number See the output from the following example: CREATE SEQUENCE fooseq

[SQL] Statistics from Sequences

2005-09-06 Thread Joÿffffffffffe3o Carvalho
Is it possible to get from a sequence: The sequence owner The min value The max value The increment value The last used number ??? Regards Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!

Re: [SQL] STATISTICS?

2002-08-03 Thread Josh Berkus
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 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an app

Re: [SQL] STATISTICS?

2002-08-03 Thread mallah
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

[SQL] STATISTICS?

2002-08-03 Thread Josh Berkus
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 broadca