pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedindexes
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>
0 siblings, 1 reply; 4+ messages in thread
From: Leonia Zaj¹c @ 2005-11-04 22:26 UTC (permalink / raw)
To: pgsql-admin
LicieHi !
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 23:08 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Leonia Zaj¹c <lea03@poczta.onet.pl>
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