Re: [pgadmin-support] Statistics view for indexes does not show correct index sizes

2010-12-23 Thread Guillaume Lelarge
Le 23/12/2010 17:05, Valentine Gogichashvili a écrit : > I am on pgAdmin III 1.12.1 (rev:REL-1_12_1) > > When opening Statistics tab for the list of table indeces, index sizes are > the same and equal to the index size of one of the indeces in the list. > This is fixed in 1.12.2 (which is alre

[pgadmin-support] Statistics view for indexes does not show correct index sizes

2010-12-23 Thread Valentine Gogichashvili
I am on pgAdmin III 1.12.1 (rev:REL-1_12_1) When opening Statistics tab for the list of table indeces, index sizes are the same and equal to the index size of one of the indeces in the list. With best regards, -- Valentine -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql

Re: [pgadmin-support] Statistics

2007-03-23 Thread Dave Page
Ezequias R. da Rocha wrote: Now it is ok with analyse. I must do it everytime ? No - but your maintenance procedures should include regular ANALYZE's (or autovacuum should be running with appropriate settings) otherwise your performance will be far from optimal. Regards, Dave. ---

Re: [pgadmin-support] Statistics

2007-03-23 Thread Ezequias R. da Rocha
Now it is ok with analyse. I must do it everytime ? Ezequias Dave Page escreveu: Ezequias R. da Rocha wrote: Hi, I would like to know if it is normal to not see the statistics of my fields in a specific schema. When I see the statistics of my fields of other table in the public schema it

Re: [pgadmin-support] Statistics

2007-03-23 Thread Dave Page
Ezequias R. da Rocha wrote: Hi, I would like to know if it is normal to not see the statistics of my fields in a specific schema. When I see the statistics of my fields of other table in the public schema it appears. Works for me. Have you ANALYZEd the table? If you haven't there won't b

[pgadmin-support] Statistics

2007-03-23 Thread Ezequias R. da Rocha
Hi, I would like to know if it is normal to not see the statistics of my fields in a specific schema. When I see the statistics of my fields of other table in the public schema it appears. Is it correct ? -- Atenciosamente Ezequias Rodrigues da Rocha ---(end of br

[pgadmin-support] 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: [pgadmin-support] Statistics logging of auto update http queries

2004-12-04 Thread Dave Page
> -Original Message- > From: Cheetah [mailto:[EMAIL PROTECTED] > Sent: 04 December 2004 19:37 > To: Dave Page > Subject: Re: [pgadmin-support] Statistics logging of auto > update http queries > > On Fri, 3 Dec 2004 13:53:10 -, Dave Page >

[pgadmin-support] Statistics on indexes and primary keys

2004-09-13 Thread Cheetah
[ I've tried this with postgres 7.4.5 and pgadmin3 1.0.2 and recent cvs snapshot in pgadmin's debian repository ] Looking at the pg_stat[io]_{user,all}_indexes views, I can see statistics on all my indexes and primary keys, but selecting any index or primary key in pgadmin3 and going to the statis