Re: Optimizing >= and <= for numbers and dates - Mailing list pgsql-performance

From scott.marlowe
Subject Re: Optimizing >= and <= for numbers and dates
Date
Msg-id Pine.LNX.4.33.0310011303350.22235-100000@css120.ihs.com
Whole thread Raw
In response to Re: Optimizing >= and <= for numbers and dates  ("Dimitri Nagiev" <dnagiev@gmx.de>)
List 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.)


pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Optimizing >= and <= for numbers and dates
Next
From: Oleg Lebedev
Date:
Subject: Re: TPC-R benchmarks