The following bug has been logged online: Bug reference: 5491 Logged by: Piergiorgio Buongiovanni Email address: piergiorgio.buongiova...@netspa.it PostgreSQL version: 8.4.3 Operating system: x86_64-redhat-linux-gnu Description: Queries performing slowly Details:
Hereby our production environment: PostgreSQL 8.4.3 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit The problem we have is simply queries perform very slowly. I simply ask the DB SELECT * FROM business.Subject and the response time is 640555ms for 86 rows extracted. It's unbelievable! Do I have any way to analyze the problem and the possibility to see anything in the log? At the moment I am not able to understand the problem as the database was built following best practices. This is our Enterprise Information portal database and we must understand what is the problem. Could you suggest me something to do? Thank yo uin advance Regards -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs