Re: postgresql performance

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: SPMLINGAM <spmlingam(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql performance
Date: 2008-03-05 10:39:45
Message-ID: 20080305103945.GA3673@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Mar 05, 2008 at 02:27:08AM -0800, SPMLINGAM wrote:
> I have a table with 50 lakhs records, the table has more then 10
> fields, i have primary key, i have select query with count(*) without any
> condition, it takes 17 seconds.

Without knowing what a "lakhs" record is, it's pretty obvious that you
haven't vacuumed in a very long time. Run VACUUM FULL on your tables, then
instate regular (non-FULL) VACUUMs or enable autovacuum.

/* Steinar */
--
Homepage: http://www.sesse.net/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Franck Routier 2008-03-05 10:52:26 Re: postgresql performance
Previous Message petchimuthu lingam 2008-03-05 10:38:00 Confirmação de envio / Sending confirmation (captchaid:13266b111e1d)