RES: [GENERAL] SELECT COUNT(*) execution time on large tables (v9.0.4-1)

Rua Tenente Gomes Ribeiro, 78 Vila Clementino (Próximo ao Metro Santa Cruz) São Paulo - SP 04038-040 -Mensagem original- De: David Johnston [mailto:pol...@yahoo.com] Enviada em: sexta-feira, 27 de maio de 2011 17:49 Para: 'Carlos Sotto Maior (SIM)'; pgsql-general@postgresql.org A

[GENERAL] SELECT COUNT(*) execution time on large tables (v9.0.4-1)

Hi, My application has a frequent need to issue a select count(*) on tables. Some have a large row count. (The example below are from a 5.7 M row; Some are larger). Issuing either SELECT COUNT(*) or SELECT COUNT() yelds a sequential scan on table; I have browsed catalog tables, digging for a

[GENERAL] "pg_control version number" after 9.0.4 installation

This is just a notice: After installing 9.0.4 I noticed that I get “pg_control version number = 903” when pg_controldata is run. Thanks, Carlos Sotto Maior +55 11 8244-7899 cso...@sistemassim.com.br Sistemas Sim Serviços e Tecnologia Ltda. +55 11