Skip site navigation (1) Skip section navigation (2)

Re: indexes and big tables

From: Robert Vojta <vojta(at)ipex(dot)cz>
To: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: indexes and big tables
Date: 2001-07-27 12:30:53
Message-ID: 20010727143053.D6382@ipex.cz (view raw or flat)
Thread:
Lists: pgsql-hackers
> I would guess the problem is the restriction on counterstamp, because 
> written like that, it probably can't use the index.
> 
> try something where you avoid the use of the date_part function e.g.:
> 	AND counterstamp > '2001-07-26 00:00:00.0'

  I will try it, but it use the index when there is a few amount of rows.
When I insert a lot of rows like me (in milions), index isn't used. I don't
know the number of rows which makes border between using and don't using
index and I can discover it if you want. Going to try your suggestions ...

Best regards,
  Robert

-- 
   _
  |-|  __      Robert Vojta <vojta-at-ipex.cz>          -= Oo.oO =-
  |=| [Ll]     IPEX, s.r.o.
  "^" ====`o

In response to

pgsql-hackers by date

Next:From: Colin 't HartDate: 2001-07-27 12:33:33
Subject: Re: Re: Re: Storing XML in PostgreSQL
Previous:From: mlwDate: 2001-07-27 11:40:38
Subject: From TODO, XML?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group