| From: | "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com> |
|---|---|
| To: | "Hannu Krosing" <hannu(at)skype(dot)net> |
| Cc: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [PATCHES] Including Snapshot Info with Indexes |
| Date: | 2007-10-28 10:27:57 |
| Message-ID: | 9362e74e0710280327x6890fd61l88d3abbd7465e340@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
On 10/28/07, Hannu Krosing <hannu(at)skype(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Volkan YAZICI | 2007-10-28 11:56:34 | BK-Tree Implementation on top of GiST |
| Previous Message | Simon Riggs | 2007-10-28 09:06:51 | Re: pgsql: Allow an autovacuum worker to be interrupted automatically when |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-10-28 17:27:38 | Re: updated hash functions for postgresql v1 |
| Previous Message | Simon Riggs | 2007-10-28 08:46:32 | Re: Autovacuum cancellation |