> Do you think an Index or Seq. scan should be used?
That was way too much data for way too simple a question. ;-)
The answer is: depends on how many rows you have. With any significant
number of rows, yes.
However, you probably only need to index the first 3-5 columns; that's
"A developer of Very Little Brain"
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Jason Coene||Date: 2004-08-12 00:29:04|
|Subject: Re: Hardware upgrade for a high-traffic database |
|Previous:||From: Gaetano Mendola||Date: 2004-08-12 00:06:31|
|Subject: Re: [HACKERS] fsync vs open_sync|