From: Richard Huxton <dev@archonet.com>
To: Joel Fradkin <jfradkin@wazagua.com>
Cc: gsstark@mit.edu, pgsql-sql@postgresql.org, ac@wazagua.com, 'Steve Goldsmith' <SGoldsmith@fcci-group.com>
Subject: Re: same question little different test MSSQL vrs Postgres
Date: Wed, 26 Jan 2005 17:39:08 +0000
Message-ID: <41F7D5BC.7050000@archonet.com> (raw)
In-Reply-To: <000001c503c9$0d2e38d0$797ba8c0@jfradkin>
References: <000001c503c9$0d2e38d0$797ba8c0@jfradkin>
Joel Fradkin wrote:
> Thank you I will look at that info.
> I did do an EXPLAIN ANALYSE on the view and could see it was doing the seq
> scan on 3 fields, so I did an index for the three fields and it then chose
> an index scan and ran in 27 seconds.
>
> I also did adjust my defaults to much smaller numbers on shared buffers (per
> the tidbits page recommendation like 8 meg for my memory size). I looked at
> http://www.desknow.com/kb/idx/0/061/article/ which recommended doing a
> vacuum verbose to determine the exact max_fsm_pages and I set the cache to
> use 25% of my available memory per the recommendation on tid bits.
Note that the effective_cache_size (if I've spelt it right) just tells
PG what your cache size is. You should set it based on what "free" tells
you about your system's use of memory.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, jfradkin@wazagua.com, SGoldsmith@fcci-group.com
Subject: Re: same question little different test MSSQL vrs Postgres
In-Reply-To: <41F7D5BC.7050000@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox