pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
indexes
4+ messages / 4 participants
[nested] [flat]

* indexes
@ 2001-11-22 09:37 Martins Zarins <mark@vestnesis.lv>
  0 siblings, 0 replies; 4+ messages in thread

From: Martins Zarins @ 2001-11-22 09:37 UTC (permalink / raw)
  To: pgsql-admin

Hi All!

Is REINDEX TABLE xxx; the same as 
DROP INDEX ... ;
CREATE INDEX ... on xxx (..);

or there are differences?

Mark



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* indexes
@ 2003-02-28 15:47 Jodi Kanter <jkanter@virginia.edu>
  0 siblings, 0 replies; 4+ messages in thread

From: Jodi Kanter @ 2003-02-28 15:47 UTC (permalink / raw)
  To: pgsql-admin

I have three tables that are queried frequently together. I have indexes on the PK values in each table as these are the fields that are typically used in the where clauses. Do I need to also have indexes on the corresponding FK values to improve performance?
Thanks,
Jodi
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu



 

 

 

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* INDEXes
@ 2005-11-04 22:26 Leonia Zaj¹c <lea03@poczta.onet.pl>
  2005-11-04 23:08 ` Re: INDEXes Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Leonia Zaj¹c @ 2005-11-04 22:26 UTC (permalink / raw)
  To: pgsql-admin

LiœcieHi !

Can anybody say, HOW does the postgre sql query planer, or executer,  prepers the query plan, if i have several indexes on my table ?


Best Regards
Leo

Attachments:

Leaves Bkgrd.jpg (image/jpeg, 4.3K) download view image
^ permalink raw reply [nested|flat] 4+ messages in thread

* Re: INDEXes
  2005-11-04 22:26 INDEXes Leonia Zaj¹c <lea03@poczta.onet.pl>
@ 2005-11-04 23:08 ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 2005-11-04 23:08 UTC (permalink / raw)
  To: Leonia Zaj¹c <lea03@poczta.onet.pl>; +Cc: pgsql-admin

Leonia Zaj¹c wrote:
> Li?cieHi !
> 
> Can anybody say, HOW does the postgre sql query planer, or executer,
> prepers the query plan, if i have several indexes on my table ?

You can look at EXPLAIN to see the index chosen.  I have an "Internals
through Pictures" PDF on my home page below that outlines how the
decisions are made, plus there is the source code and various README
files that go into details about the optimizer.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-11-04 23:08 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-11-22 09:37 indexes Martins Zarins <mark@vestnesis.lv>
2003-02-28 15:47 indexes Jodi Kanter <jkanter@virginia.edu>
2005-11-04 22:26 INDEXes Leonia Zaj¹c <lea03@poczta.onet.pl>
2005-11-04 23:08 ` Re: INDEXes Bruce Momjian <pgman@candle.pha.pa.us>

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