On Tue, Aug 3, 2010 at 6:27 AM, Sim Zacks <s...@compulab.co.il> wrote: > >> So, about how big is your db? How many users are likely to be running >> queries at once? How big of a chunk of data are those users likely to >> each need for sorts etc? >> > The database is 400MB (using du on the base folder), I have 10 active > users who run queries and functions that generally take less then 1 > second each to run.
Then a couple gigabytes should be enough to run it smoothly, assuming that those queries aren't doing things that need 100s of megabytes for sorting for each query. I'd start with a 2 or 3Gig VM, give 400 or so to shared_buffers, and set work_mem to something like 8 or 16Meg and see how it runs. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
