From: Adrian Moisey <adrian@careerjunction.co.za>
To: Jared Mauch <jared@puck.nether.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: big database performance
Date: Thu, 10 Jan 2008 10:57:46 +0200
Message-ID: <4785DE0A.6020501@careerjunction.co.za> (raw)
In-Reply-To: <20080109174243.GA8915@puck.nether.net>
References: <4784835A.8070604@careerjunction.co.za>
<47848575.8000007@commandprompt.com>
<20080109174243.GA8915@puck.nether.net>
Hi
> I do large databases in Pg, like 300GB/day of new data. Need a lot
> more data on what you're having issues with.
That is big!
What sort of information do you need from me ?
> Is your problem with performance database reads?
> writes? (insert/copy?) How many indicies do you have?
I think the problem is related to load. Everything is slow because
there are way too many connections. So everything is making everything
else slow. Not much detail, is it?
We have 345 indicies on the db.
--
Adrian Moisey
System Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842
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: adrian@careerjunction.co.za, jared@puck.nether.net
Subject: Re: big database performance
In-Reply-To: <4785DE0A.6020501@careerjunction.co.za>
* 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