Re: counting rows

From: greg(at)turnstep(dot)com
To: pgsql-admin(at)postgresql(dot)org
Cc: pgboy(at)guthrie(dot)charm(dot)net
Subject: Re: counting rows
Date: 2003-08-06 13:55:41
Message-ID: 34bd55e0b98d860469d786c8a3391880@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> i need to get a row count on a large table. it appears that
> select count(*) from <table>;
> always does a table scan, whether i have an index or not, and that is too
> slow.

http://www.gtsm.com/oscon2003/findrows.html

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200308060951
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE/MQgmvJuQZxSWSsgRAkFDAJwPz5C7OljCg4TYqxvw4/WjLr8TlgCgovtS
xQPuL/l+QCPgmwVDeX0yocM=
=XtnA
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-08-06 14:06:27 Re: syslog enabled causes random hangs?
Previous Message Andreas Schmitz 2003-08-06 13:50:52 Re: Postgresql slow on XEON 2.4ghz/1gb ram