Thanks, naming conventions, and count()

First off I just wanted to give a big 'thank you' to all the developers and contributors
who have made PostgreSQL what it is today. I haven't come across a single thing
since my first experience with it a few years ago that hasn't been corrected, sped
up, or otherwise postively enhanced!

In working with 7.1 over the past couple weeks, I've noted the following mods may
add to usability and speed:

o v7.1 changed the database naming convention to be all numeric; I suggest having
the DB engine create symbolic links when creating a new DB and subsequent tables.
For instance, in creating a database 'foo' with table 'bar' the /path/to/pgsql/data/base
folder will have a new folder named something like '18720'; this folder could also
have a symbolic link to 'foo'. Then in the '18720' folder rather than just having
numeric files for each table, pk, index, etc. there could be symbolic links following
the naming convention 'bar', 'pk_foo_pkey', 'field1_foo_ukey', 'field2_foo_key'.

Maybe this would work best as configurable flag that could be set during compilation or
in the conf file.

o count() should use index scans for tables with a PK; scans would be on the PK index;
even after running 'vacuum analyze' such a query still uses a sequential scan. For
instance, "select count(*) from bar" and even "select(pk_name) from bar" both use
sequential scans. Likewise, scans on fields with indexes should use the index.

I hope this input is useful; keep up the excellent work,

Casey Lyon
Systems Engineer
Earthcars.com, Inc
www.earthcars.com
casey(at)earthcars(dot)com