Re: Optimizing >= and <= for numbers and dates

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Dimitri Nagiev <dnagiev(at)gmx(dot)de>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Optimizing >= and <= for numbers and dates
Date: 2003-10-01 19:04:56
Message-ID: Pine.LNX.4.33.0310011303350.22235-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Oh, to followup on my previously sent post, make sure you've got
effective_cache_size set right BEFORE you go trying to set
random_page_cost, and you might wanna run a select * from table to load
the table into kernel buffer cache before testing, then also test it with
the cache cleared out (select * from a_different_really_huge_table will
usually do that.)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Manfred Koizar 2003-10-01 19:06:17 Re: Optimizing >= and <= for numbers and dates
Previous Message scott.marlowe 2003-10-01 19:03:21 Re: Optimizing >= and <= for numbers and dates