Re: [PATCHES] Including Snapshot Info with Indexes - Mailing list pgsql-hackers

From Gokulakannan Somasundaram
Subject Re: [PATCHES] Including Snapshot Info with Indexes
Date
Msg-id 9362e74e0710280327x6890fd61l88d3abbd7465e340@mail.gmail.com
Whole thread Raw
In response to Re: [PATCHES] Including Snapshot Info with Indexes  (Hannu Krosing <hannu@skype.net>)
List pgsql-hackers


On 10/28/07, Hannu Krosing <hannu@skype.net> wrote:
Ühel kenal päeval, R, 2007-10-26 kell 16:46, kirjutas Gokulakannan
Somasundaram:
>         What does the numbers look like if the the tables are small
>         enough to
>         fit in RAM?
>
> I don't know whether this is a valid production setup, against which
> we need to benchmark.

Often the production setup may have at least most of indexes in RAM, if
not the whole data.

My test happened to be something where the base folder size was less than RAM. So this test case has been covered, although without my intention.

Thanks,
Gokul.

--------------
Hannu






--
Thanks,
Gokul.
CertoSQL Project,
Allied Solution Groups.
(www.alliedgroups.com )

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [COMMITTERS] pgsql: Allow an autovacuum worker to be interrupted automatically when
Next
From: Volkan YAZICI
Date:
Subject: BK-Tree Implementation on top of GiST