From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: asif ali <asif_icrossing@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: VACUUM FULL does not works.......
Date: Wed, 6 Dec 2006 23:17:10 +0530
Message-ID: <a97c77030612060947g7265aba0nef60588f2070cae@mail.gmail.com> (raw)
In-Reply-To: <155293.25526.qm@web58414.mail.re3.yahoo.com>
References: <155293.25526.qm@web58414.mail.re3.yahoo.com>
On 12/6/06, asif ali <asif_icrossing@yahoo.com> wrote:
> Hi,
> I have a "product" table having 350 records. It takes approx 1.8 seconds to
> get all records from this table. I copies this table to a "product_temp"
> table and run the same query to select all records; and it took 10ms(much
> faster).
> I did "VACUUM FULL" on "product" table but It did not work.
>
> I checked the file size of these two tables.
> "product" table's file size is "32mb" and
> "product_temp" table's file size is "72k".
>
> So, it seems that "VACUUM FULL" is not doing anything.
> Please suggest.
It is desirable that PostgreSQL version be reported in problem descriptions.
Older versions of pgsql had problem of index bloat. It is interesting to
find out why VACUUM FULL does not work in your case(wait for the experts) ,
but most probably CLUSTERING the table on primary key is going to
solve the query performance problem (temporarily)
>
> asif ali
> icrossing inc.
>
> ________________________________
> Have a burning question? Go to Yahoo! Answers and get answers from real
> people who know.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mallah.rajesh@gmail.com, asif_icrossing@yahoo.com
Subject: Re: VACUUM FULL does not works.......
In-Reply-To: <a97c77030612060947g7265aba0nef60588f2070cae@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox