From: | Nick Eubank <nickeubank(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Tuning Postgres for Single connection use |
Date: | 2014-04-14 21:46:04 |
Message-ID: | CAFWQgOmjM=KWxBwhK+gZtc6WeFKCYCPjAOg8P=wVs6buzQMoPQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Any rules of thumb for work_mem, maintenance_work_mem, shared_buffer, etc.
for a database that DOESN'T anticipate concurrent connections and that is
doing lots of aggregate functions on large tables? All the advice I can
find online on tuning
(this<http://wiki.postgresql.org/wiki/Performance_Optimization>
, this<http://media.revsys.com/talks/djangocon/2011/secrets-of-postgresql-performance.pdf>
, this <http://www.revsys.com/writings/postgresql-performance.html> etc.)
is written for people anticipating lots of concurrent connections.
I'm a social scientist looking to use Postgres not as a database to be
shared by multiple users, but rather as my own tool for manipulating a
massive data set (I have 5 billion transaction records (600gb in csv) and
want to pull out unique user pairs, estimate aggregates for individual
users, etc.). This also means almost no writing, except to creation of new
tables based on selections from the main table.
I'm on a Windows 8 VM with 16gb ram, SCSI VMware HD, and 3 cores if that's
important.
Thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Mel Llaguno | 2014-04-14 22:32:38 | HFS+ pg_test_fsync performance |
Previous Message | Vincent Veyron | 2014-04-14 21:35:53 | Re: Approach to Data Summary and Analysis |