Re: The database is very slow !

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: proghome(at)silesky(dot)com (krystoffff)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: The database is very slow !
Date: 2003-08-09 15:11:43
Message-ID: 5624.1060441903@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

proghome(at)silesky(dot)com (krystoffff) 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?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-08-09 15:18:17 Re: PostgreSQL and ACID properties support
Previous Message Thomas T. Thai 2003-08-09 03:44:20 Re: Random via Subselect or Temporary Table