is file size relevant in choosing index or table scan?

From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: is file size relevant in choosing index or table scan?
Date: 2007-05-22 09:29:46
Message-ID: A3D1526C98B7C1409A687E0943EAC410605FF1@obelix.askesis.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

I have a table with a file size of 400 MB with an index of 100 MB. Does PostgreSQL take the file sizes of both the table and the index into account when determing if it should do a table or an index scan?

TIA

Joost

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2007-05-22 09:42:18 Re: is file size relevant in choosing index or table scan?
Previous Message Richard Huxton 2007-05-22 09:21:43 Re: Key/Value reference table generation: INSERT/UPDATE performance