[GENERAL] The database is very slow !

2003-08-14 Thread krystoffff
I currently have PostgreSQL 7.1 installed on a server with about 700 Mb of RAM. I have many problems of speed with a database I created. For example, it took almost 12 sec to run the query "select * from table" directly from PostgreSQL, on a table with 4000 records and 60 fields ... And the whole

Re: [GENERAL] The database is very slow !

2003-08-14 Thread Tom Lane
[EMAIL PROTECTED] (krysto) writes: > I have many problems of speed with a database I created. For example, > it took almost 12 sec to run the query "select * from table" directly > from PostgreSQL, on a table with 4000 records and 60 fields ... When did you last VACUUM this table?