Postgres Pro
Downloads
Home   >   mailing lists

What is faster? - Mailing list pgsql-sql

From ON.KG
Subject What is faster?
Date
Msg-id 17434586625.20050606202531@on.kg
Whole thread Raw
In response to Re: how to store more than 3 MB of character data in Postgres  (Richard Huxton <dev@archonet.com>)
Responses Re: What is faster?  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Tree view 
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)?

Thank You

pgsql-sql by date:

Previous
From: Markus Bertheau ☭
Date:
Subject: Re: ARRAY() returning NULL instead of ARRAY[] resp. {}
Next
From: Tom Lane
Date:
Subject: Re: how to store more than 3 MB of character data in Postgres Varchar field