Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL versus MySQL for GPS Data - Mailing list pgsql-general

From Gregory Stark
Subject Re: PostgreSQL versus MySQL for GPS Data
Date
Msg-id 87d4cff3bw.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: PostgreSQL versus MySQL for GPS Data  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 
Merlin Moncure <mmoncure@gmail.com> writes:

> A good rule of thumb for large is table size > working ram.  Huge
> (really large) is 10x ram.

Or better yet, large is data > working ram. Very large is data > directly
attached drives... That means that without fairly expensive hardware you start
talking about "very large" at about 4-10 TB.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's PostGIS support!

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: PostgreSql with or without Plus?
Next
From: Bill Moran
Date:
Subject: Re: Query 4-5 times slower after ANALYZE