From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
---|---|
To: | Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: [NOVICE] Extreme high load averages |
Date: | 2003-07-10 06:30:16 |
Message-ID: | 3F0D5550.21678.4E122CF@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-performance |
On 9 Jul 2003 at 23:37, Martin Foster wrote:
> By fixing the script and doing the appropriate full vacuum and re-index,
> the system is behaving much more like it should. Even if the process
> may seem a bit odd to some.
>
> The reason for removing rows on a daily basis is due to the perishable
> nature of the information. Since this is a chat site, posts over a day
> old are rarely needed for any reason. Which is why they are archived
> into dumps in case we really need to retrieve the information itself and
> this gives us the added bonus of smaller backup sizes and smaller
> database sizes.
I have an idea.
How about creating a table for each day. Use it for a while and rename it.
Since you can rename a table in transaction, it should not be a problem.
You can use inheritance if you want to query all of them. Using indexes and
foregin keys on inherited tables is a problem though.
That way deletion would be avoided and so would vacuum. It should be mich
lighter on the system overall as well.
Tell us if it works.
Bye
Shridhar
--
Kaufman's Law: A policy is a restrictive document to prevent a recurrence of a
single incident, in which that incident is never mentioned.
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Foster | 2003-07-10 06:43:22 | Re: [NOVICE] Extreme high load averages |
Previous Message | Martin Foster | 2003-07-10 05:37:50 | Re: [PERFORM] Extreme high load averages |
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Foster | 2003-07-10 06:43:22 | Re: [NOVICE] Extreme high load averages |
Previous Message | Martin Foster | 2003-07-10 05:37:50 | Re: [PERFORM] Extreme high load averages |