Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: more problems with count(*) on large table
- From: "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: more problems with count(*) on large table
- Date: Fri, 28 Sep 2007 18:38:17 +0200
am Fri, dem 28.09.2007, um 11:56:46 -0400 mailte Mike Charnoky folgendes: > Hi, > > I am still having problems performing a count(*) on a large table. This > > Now, certain count(*) queries are failing to complete for certain time > ranges (I killed the query after about 24 hours). The table is indexed > on a timestamp field. Here is one query that hangs: Again: an index can't help! Because of MVCC: 'select count(*)' without WHERE-condition forces an seq. table-scan. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
- Follow-Ups:
- Re: more problems with count(*) on large table
- From: Alvaro Herrera
- Re: more problems with count(*) on large table
- References:
- more problems with count(*) on large table
- From: Mike Charnoky
- more problems with count(*) on large table
- Prev by Date: Re: row->ARRAY or row->table casting?
- Next by Date: Re: more problems with count(*) on large table
- Previous by thread: more problems with count(*) on large table
- Next by thread: Re: more problems with count(*) on large table
- Indexes: