Re: select count(*) performance (vacuum did not help)

From: "Dave Dutcher" <dave(at)tridecap(dot)com>
To: 'Gábor Farkas' <gabor(at)nekomancer(dot)net>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: select count(*) performance (vacuum did not help)
Date: 2007-09-24 15:37:42
Message-ID: 02d201c7fec0$d95a2cd0$cb00a8c0@tridecap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Niklas Johansson 2007-09-24 16:00:29 Re: TEXT or LONGTEXT?
Previous Message Csaba Nagy 2007-09-24 15:34:16 Re: select count(*) performance (vacuum did not help)