Re: Linux/PostgreSQL scalability issue - problem with 8 cores

From: Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Date: 2008-01-15 12:26:10
Message-ID: 478CA662.4060505@careerjunction.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi

> > I can think of three things that might be producing this:
>
> we've found it: TRUNCATE

I haven't been following this thread. Can someone please explain to me
why TRUNCATE causes these spikes?

--
Adrian Moisey
System Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian(at)careerjunction(dot)co(dot)za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-01-15 15:20:59 Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Previous Message Jakub Ouhrabka 2008-01-15 12:09:18 Re: Linux/PostgreSQL scalability issue - problem with 8 cores