Re: What is faster?

From: Richard Huxton <dev(at)archonet(dot)com>
To: "ON(dot)KG" <skyer(at)on(dot)kg>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: What is faster?
Date: 2005-06-06 14:45:02
Message-ID: 42A4616E.8070101@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

ON.KG wrote:
> Hi All!
>
> What is faster - SLECTion data from one large table (200 000 - 300 000
> records), or SELECTion from a few small tables (example, 2 tables 150
> 000 records each)?

It depends. Are you selecting all records? One record? A few records? If
one or a few, do you have a suitable index on the table(s)? Is the table
clustered? Expected to be cached in RAM?

Do you have a specific problem, or reason to believe you may encounter one?

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Bertheau ☭ 2005-06-06 14:54:59 Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {}
Previous Message Tom Lane 2005-06-06 14:44:49 Re: ARRAY() returning NULL instead of ARRAY[] resp. {}