-----Original Message-----
From: Robert Haas [mailto:robertmhaas@gmail.com]
Sent: Tuesday, January 18, 2011 2:53 PM
To: Simone Aiken
Cc: Alvaro Herrera; pgsql-hackers
Subject: Re: [HACKERS] ToDo List Item - System Table Index Clustering
>Sure - my point is just that we usually have as a criteria for any
>performance related patch that it actually does improve performance.
Sorry wasn't arguing your point. Conceding it actually. =)
I wasn't explaining why I chose it anyway to contest your statements,
but as an invitation for you to point me towards something more useful
that fit what I was looking for in a task.
>
> Uh... I don't know what this means.
>
Pages like this one have column comments for the system tables:
http://www.psql.it/manuale/8.3/catalog-pg-attribute.html
But in my database when I look for comments they aren't there:
qcc=> \d+ pg_attribute Table "pg_catalog.pg_attribute" Column | Type | Modifiers | Description
---------------+----------+-----------+-------------attrelid | oid | not null |attname | name |
notnull |atttypid | oid | not null |attstattarget | integer | not null |attlen | smallint | not
null |attnum | smallint | not null |attndims | integer | not null |attcacheoff | integer | not null
|atttypmod | integer | not null |attbyval | boolean | not null |attstorage | "char" | not null
|attalign | "char" | not null |attnotnull | boolean | not null |atthasdef | boolean | not null
|attisdropped | boolean | not null |attislocal | boolean | not null |attinhcount | integer | not null |
So I have to fire up a web browser and start googling to learn
about the columns. Putting them in pg_description would be
more handy, no?
-Simone Aiken