Re: Permance issues with migrated db

On Tue, 2007-05-22 at 19:03 +0100, Richard Huxton wrote:
> 4. We're still 5 x slower than MS-SQL (with the count). That might
> well
> be down to having to check visibility on each row with our MVCC
> rather
> than just going to the index.

Tips? I'd love to know how to see inside MVCC. I really appreciate the
help!

>
> Hmm... How much of your machine is PG getting to use vs. MS-SQL? What
> are your shared_buffers, work_mem, effective_cache_size (and how much
> RAM on this box)?

3.5GB of RAM on a Xeon 2.8GHz server. I have default shared_buffers
32MB, no defaults changed except listen_addresses. How can I check
work_mem and effective_cache_size?

--
Robert