Postgres Pro
Downloads
Home   >   mailing lists

Re: Linux/PostgreSQL scalability issue - problem with 8 cores - Mailing list pgsql-performance

From Adrian Moisey
Subject Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Date
Msg-id 478CA662.4060505@careerjunction.co.za
Whole thread Raw
In response to Re: Linux/PostgreSQL scalability issue - problem with 8 cores  (Jakub Ouhrabka <kuba@comgate.cz>)
Responses Re: Linux/PostgreSQL scalability issue - problem with 8 cores
List pgsql-performance
Tree view 
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@careerjunction.co.za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

pgsql-performance by date:

Previous
From: Jakub Ouhrabka
Date:
Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Next
From: Tom Lane
Date:
Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores