On 2011-09-03 00:04, Stefan Keller wrote:
2011/9/2 Scott Marlowe:
On Tue, Aug 30, 2011 at 11:23 AM, Stefan Keller wrote:
How big is your DB?
What kind of reads are most common, random access or sequential?
How big of a dataset do you pull out at once with a query.
SSDs are usually not a big wi
Here goesI think it might be difficult to go through all these
definitions..
PRGMEMACCMST
Table "public.prgmemaccmst"
Column|Type | Modifiers
--+-+---
cmpcod | character varying(5)
2011/9/2 Scott Marlowe :
> On Tue, Aug 30, 2011 at 11:23 AM, Stefan Keller wrote:
> How big is your DB?
> What kind of reads are most common, random access or sequential?
> How big of a dataset do you pull out at once with a query.
>
> SSDs are usually not a big winner for read only databases.
> I
On 09/01/2011 11:14 PM, Jesper Krogh wrote:
It is "really expensive" to go over 512GB memory and the performance
regression for just hitting disk in a system where you assume
everything is in memory is really huge. SSD makes the "edge" be a bit
smoother than rotating drives do.
Ironically, th
