Does anyone have suggestions that could improve performance?
If you have doubled your ram you could definately increase your
effective_cache.
As you also doubled your memory you could increase your work_mem but be
careful with this setting.
Also just to be certain are you running 32bit or 64bit PostgreSQL?
Sincerely,
Joshua D. Drake
------------------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
