Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.8.8/8.7.5) with ESMTP id HAA22570 for ; Sun, 12 Jul 1998 07:03:57 -0400 (EDT) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.5/8.8.5) with ESMTP id OAA08234 for ; Sun, 12 Jul 1998 14:03:51 +0300 (IDT) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Sun, 12 Jul 1998 14:03:56 +0300 To: pgsql-sql@postgreSQL.org From: Herouth Maoz Subject: RE: [SQL] Single vs. multiple indexes At 20:37 +0300 on 10/7/98, Jackson, DeJuan wrote: > > > But let's not forget one of the wonders of PostgreSQL. In this world > you can have your cake and eat it to. So, create all 4 indices and let > the optimizer sort em out for your queries. Yes, but whenever you update or insert a row, it's that much slower. One should always remember not to go wild with indexing - they carry a penalty on INSERT and UPDATE. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma