pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Indices
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
  2001-12-11 18:46 ` Re: Indices Stephan Szabo <sszabo@megazone23.bigpanda.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 03:48 Indices sharmad@goatelecom.com
@ 2001-12-11 18:46 ` Stephan Szabo <sszabo@megazone23.bigpanda.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