Postgres Pro
Downloads
Home   >   mailing lists

is file size relevant in choosing index or table scan? - Mailing list pgsql-performance

From Joost Kraaijeveld
Subject is file size relevant in choosing index or table scan?
Date
Msg-id A3D1526C98B7C1409A687E0943EAC410605FF1@obelix.askesis.nl
Whole thread Raw
Responses Re: is file size relevant in choosing index or table scan?
List pgsql-performance
Tree view 
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
tableand the index into account when determing if it should do a table or an index scan?  

TIA

Joost

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Key/Value reference table generation: INSERT/UPDATE performance
Next
From: Richard Huxton
Date:
Subject: Re: is file size relevant in choosing index or table scan?