[H-GEN] Database Indexing

[Nikolai Lusan]

[ Humbug *General* list - semi-serious discussions about Humbug and     ]
[ Unix-related topics. Posts from non-subscribed addresses will vanish. ]

On Mon, 9 Sep 2002, Greg Black wrote:

> My approach to this (as with many similar questions) is to use
> the default (on the grounds that it is the default for a reason
> that its authors have considered in depth).  If I encounter some
> actual performance problem, I then profile the application to
> see where the bottleneck is and I attend to that.  So far, with
> PostgreSQL, it has never been index performance, so I've stuck
> to the defaults.  Do you have a performance problem, or is this
> just a general question?

I'm pretty much in the same boat, although the only performance hits I
took were fixed by indexing the tables :)

This question is just general, my piddly little cd/mp3 database is
hardly going to bring a machine to its knees.

Nikolai


--
* This is list (humbug) general handled by majordomo at lists.humbug.org.au .
* Postings to this list are only accepted from subscribed addresses of
* lists 'general' or 'general-post'.  See http://www.humbug.org.au/