From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Gopal <gopal@getmapping.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres scalability and performance on windows
Date: Thu, 23 Nov 2006 22:50:45 +0000
Message-ID: <456625C5.1050601@enterprisedb.com> (raw)
In-Reply-To: <A5DE6132B8D812419321747E42710E2204C05F@EXCHANGE01.gm.local>
References: <A5DE6132B8D812419321747E42710E2204C05F@EXCHANGE01.gm.local>
Gopal wrote:
> Functions : Simple coordinate reprojection and intersection query +
> inner join of table1 and table2.
>
> I think I have all the right indexes defined and indeed the performance
> for queries under low loads is fast.
Can you do a EXPLAIN ANALYZE on your queries, and send the results back
to the list just to be sure?
> SQL server caches all the data in memory which is making it faster(uses
> about 1.2GB memory- which is fine).
>
> But postgres has everything spread across 10-15 processes, with each
> process using about 10-30MB, not nearly enough to cache all the data and
> ends up doing a lot of disk reads.
I don't know Windows memory management very well, but let me just say
that it's not that simple.
> I've read that postgres depends on OS to cache the files, I wonder if
> this is not happenning on windows.
Using the Task Manager, or whatever it's called these days, you can see
how much memory is used for caching.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
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-performance@postgresql.org
Cc: heikki@enterprisedb.com, gopal@getmapping.com
Subject: Re: Postgres scalability and performance on windows
In-Reply-To: <456625C5.1050601@enterprisedb.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