Postgres Pro
Downloads
Home   >   mailing lists

Re: The database is very slow ! - Mailing list pgsql-general

From Tom Lane
Subject Re: The database is very slow !
Date
Msg-id 5624.1060441903@sss.pgh.pa.us
Whole thread Raw
In response to The database is very slow !  (proghome@silesky.com (krystoffff))
List pgsql-general
Tree view 
proghome@silesky.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

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: PostgreSQL and ACID properties support
Next
From: Tom Lane
Date:
Subject: Re: Temporary table