Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 24 Sep 2007 10:37:42 -0500
> -----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
- References:
- select count(*) performance (vacuum did not help)
- From: Gábor Farkas
- Re: select count(*) performance (vacuum did not help)
- From: Heikki Linnakangas
- Re: select count(*) performance (vacuum did not help)
- From: Gábor Farkas
- Re: select count(*) performance (vacuum did not help)
- From: Heikki Linnakangas
- Re: select count(*) performance (vacuum did not help)
- From: Gábor Farkas
- select count(*) performance (vacuum did not help)
- Prev by Date: Re: select count(*) performance (vacuum did not help)
- Next by Date: Re: TEXT or LONGTEXT?
- Previous by thread: Re: select count(*) performance (vacuum did not help)
- Next by thread: TEXT or LONGTEXT?
- Indexes: