| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | asif ali <asif_icrossing(at)yahoo(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: VACUUM FULL does not works....... |
| Date: | 2006-12-06 17:20:43 |
| Message-ID: | 1165425643.14565.471.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, 2006-12-06 at 11:07, asif ali 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.
More than likely you've got a long running transaction that the vacuum
can't vacuum around.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luke Lonergan | 2006-12-06 17:40:25 | Re: File Systems Compared |
| Previous Message | Jean-Max Reymond | 2006-12-06 17:13:07 | Re: VACUUM FULL does not works....... |