Re: select count(*) performance (vacuum did not help) - Mailing list pgsql-performance

From Dave Dutcher
Subject Re: select count(*) performance (vacuum did not help)
Date
Msg-id 02d201c7fec0$d95a2cd0$cb00a8c0@tridecap.com
Whole thread Raw
In response to Re: select count(*) performance (vacuum did not help)  (Gábor Farkas <gabor@nekomancer.net>)
List pgsql-performance
> -----Original Message-----
> From: Gábor Farkas
>
>
> i see.
>
> will i achieve the same thing by simply dropping that table
> and re-creating it?

Yes.  Or even easier (if you don't need the data anymore) you can use the
truncate command.  Which deletes everything in the table including dead
rows.

Dave


pgsql-performance by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: select count(*) performance (vacuum did not help)
Next
From: Niklas Johansson
Date:
Subject: Re: TEXT or LONGTEXT?