Re: [pgadmin-support] Statistics

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

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

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

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

Re: [pgadmin-support] adminpack install

[EMAIL PROTECTED] wrote: > I've installed the admin functions per the README.adminpack under > PostgreSQL 8.2.3's contrib/adminpack directory, but PgAdmin (1.6.2) still > says the functions are not installed on the server. This happens even > after restarting both PostgreSQL and PgAdmin. > > A

[pgadmin-support] adminpack install

I've installed the admin functions per the README.adminpack under PostgreSQL 8.2.3's contrib/adminpack directory, but PgAdmin (1.6.2) still says the functions are not installed on the server. This happens even after restarting both PostgreSQL and PgAdmin. Any thoughts as to what I may be missi

Re: [pgadmin-support] Insert (large sql file)

Ezequias R. da Rocha wrote: Hi list, I would like to know if it is possible to load a large insert statement (.sql file) without need to open it in the Query Tool on pgAdmin. I am waitting for more than 30 minuts to load it on wordpad to copy small ammounts of this insert. My sql file has

[pgadmin-support] Insert (large sql file)

Hi list, I would like to know if it is possible to load a large insert statement (.sql file) without need to open it in the Query Tool on pgAdmin. I am waitting for more than 30 minuts to load it on wordpad to copy small ammounts of this insert. My sql file has 171 Mb size. ps: I have no