Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: select count(*) performance (vacuum did not help)
- From: Gábor Farkas <gabor(at)nekomancer(dot)net>
- To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: select count(*) performance (vacuum did not help)
- Date: Mon, 24 Sep 2007 17:14:27 +0200
Heikki Linnakangas wrote:
Gábor Farkas wrote:if i do a full vacuum to that table only, will the database still serve data from the other tables at a normal speed?Yes. The extra I/O load vacuum full generates while it's running might disrupt other activity, though.
i see.will i achieve the same thing by simply dropping that table and re-creating it?
gabor
- Follow-Ups:
- Re: select count(*) performance (vacuum did not help)
- From: Dave Dutcher
- Re: select count(*) performance (vacuum did not help)
- From: Csaba Nagy
- Re: select count(*) performance (vacuum did not help)
- From: Bill Moran
- Re: select count(*) performance (vacuum did not help)
- 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
- select count(*) performance (vacuum did not help)
- Prev by Date: Re: select count(*) performance (vacuum did not help)
- Next by Date: TEXT or LONGTEXT?
- Previous by thread: Re: select count(*) performance (vacuum did not help)
- Next by thread: Re: select count(*) performance (vacuum did not help)
- Indexes: