From: Usama Munir Dar <usama.munir@enterprisedb.com>
To: Shadkam Islam <shadkam@ba-sys.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Windows XP selects are very slow
Date: Wed, 28 Nov 2007 21:15:09 +0500
Message-ID: <474D940D.2060005@enterprisedb.com> (raw)
In-Reply-To: <D764CF6CE2435E448699508704B3A73D177C66@orion.ba-sys.com>
References: <D764CF6CE2435E448699508704B3A73D177C66@orion.ba-sys.com>
PG generally comes with very basic default settings, one *start* maybe
this page for you
http://www.webservices.uiuc.edu/postgresql/
Then obviously you will need to work though your query plans and iterate.
Shadkam Islam wrote:
> Hi All,
>
> We are having a table whose data we need to bucketize and show. This is
> a continuously growing table (archival is a way to trim it to size).
> We are facing 2 issues here:
>
> 1. When the records in the table are in the range of 10K, it works fine
> for some time after starting postgres server. But as time passes, the
> entire machine becomes slower and slower - to the extent that we need to
> go for a restart. Though taskmgr does not show any process consuming
> extra-ordinary amount of CPU / Memory. After a restart of postgres
> server, things come back to normal. What may be going wrong here?
>
> 2. When the records cross 200K, the queries (even "select count(*) from
> _TABLE_") start taking minutes, and sometimes does not return back at
> all. We were previously using MySql and at least this query used to work
> OK there. [Our queries are of the form "select sum(col1), sum(col2),
> count(col3) ... where .... group by ... " ]. Any suggestions ...
>
> Below is the tuning parameter changes thet we did with the help from
> internet:
>
> We are starting postgres with the options [-o "-B 4096"], later we added
>
> a "-S 1024" as well - without any visible improvement.
> Machine has 1GB RAM.
>
> shadkam
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
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: usama.munir@enterprisedb.com, shadkam@ba-sys.com
Subject: Re: Windows XP selects are very slow
In-Reply-To: <474D940D.2060005@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