pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedIndices
3+ messages / 3 participants
[nested] [flat]
* Indices
@ 2001-01-19 10:55 Nikolaj Lundsgaard <Nikolaj@kampsax.dtu.dk>
0 siblings, 0 replies; 3+ messages in thread
From: Nikolaj Lundsgaard @ 2001-01-19 10:55 UTC (permalink / raw)
To: pgsql-sql
Maybe a wrong mailinglist to ask this, but...
Are there any plans on writing a chapter in the documentation about the implementation of indices. I know from M$ SQL Server that it is no picnic determining which indices are useful, and thick books can be written on how to make the right indices for the right query.
I have no idea if postgres has similar strange ways of using indices, but even so, that should be written in the documentation. However I find it highly probable that I am not the only one having trouble designing indices. Often I see questions on this mailinglist sounding like: "Why is my query not using the index". These would perhaps be less frequent in the future if such a chapter was written.
Have a nice week-end
Regards, Nikolaj
^ permalink raw reply [nested|flat] 3+ messages in thread
* Indices
@ 2001-12-11 03:48 sharmad@goatelecom.com
0 siblings, 1 reply; 3+ messages in thread
From: sharmad@goatelecom.com @ 2001-12-11 03:48 UTC (permalink / raw)
To: pgsql-sql
Hi,
Having to manny indices to a table,does it effect the performance of a table.Like
a table having following structure
Name :
First name,
Second Name,
Third name,
Age,
Address.
Is it good here to have multiple indices like on only first name, only second
name,only third name and all other combination of first ,second and third name
or the performance increases when we have only 1 indice of all first ,second
and third name
Thanks
-Sharmad
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Indices
@ 2001-12-11 18:46 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: sharmad@goatelecom.com
0 siblings, 0 replies; 3+ messages in thread
From: Stephan Szabo @ 2001-12-11 18:46 UTC (permalink / raw)
To: sharmad@goatelecom.com; +Cc: pgsql-sql
On Tue, 11 Dec 2001 sharmad@goatelecom.com wrote:
> Hi,
> Having to manny indices to a table,does it effect the performance of a table.Like
> a table having following structure
Generally it'll affect the speed of transactions that write to the table.
>
> Name :
> First name,
> Second Name,
> Third name,
> Age,
> Address.
>
> Is it good here to have multiple indices like on only first name, only second
> name,only third name and all other combination of first ,second and third name
> or the performance increases when we have only 1 indice of all first ,second
> and third name
It mostly depends on what you're searching for in your queries.
PostgreSQL will attempt to use multi-column indexes for prefixing columns
(so an index on (a,b,c) can be used for queries that constrain a, but not
for queries that don't, a query that constrains a and c probably only
uses the index to constrain a, etc...)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-12-11 18:46 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-19 10:55 Indices Nikolaj Lundsgaard <Nikolaj@kampsax.dtu.dk>
2001-12-11 03:48 Indices sharmad@goatelecom.com
2001-12-11 18:46 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox