From: Ragnar <gnari@hive.is>
To: Doron Baranes <doron.baranes@dbnet.co.il>
Cc: pgsql-performance@postgresql.org
Subject: Re:
Date: Sun, 09 Apr 2006 11:10:16 +0000
Message-ID: <1144581016.32289.131.camel@localhost.localdomain> (raw)
In-Reply-To: <0BA77301DFF4B24C9C5DAA74138BF95001E1E7@exchange-1.dbnet.co.il>
References: <0BA77301DFF4B24C9C5DAA74138BF95001E1E7@exchange-1.dbnet.co.il>
On sun, 2006-04-09 at 12:47 +0200, Doron Baranes wrote:
> Hi
>
> I am running on postgres 7.4.6 on a pineapp with 512MB RAM.
>
> I did a database vacuum analyze and rebuild my indexes.
If you have previously done a lot of deletes or updates
without regular vacuums, you may have to do a
VACUUM FULL ANALYZE
once to get the table into normal state.
After this, regular normal VACUUM ANALYZE should be
enough.
> When I perform queries on tables of 2M-10M of rows it takes several
> minutes and
We would need to see the output of EXPLAIN ANALYZE
for your query, along with some information about
the schema of the tables involved, such as what indexes
have been created.
Also, let us know about any non-default configuration.
gnari
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: gnari@hive.is, doron.baranes@dbnet.co.il
Subject: Re:
In-Reply-To: <1144581016.32289.131.camel@localhost.localdomain>
* 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