Skip site navigation (1) Skip section navigation (2)

Re: Getting even more insert performance (250m+rows/day)

From: "Daniel J(dot) Luke" <dluke(at)geeklair(dot)net>
To: Larry Rosenman <lrosenman(at)pervasive(dot)com>
Cc: "Dave Dutcher" <dave(at)tridecap(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Getting even more insert performance (250m+rows/day)
Date: 2006-05-24 20:29:25
Message-ID: 4D7AF15D-0F5D-4AAA-85F7-B06089F826B1@geeklair.net (view raw or flat)
Thread:
Lists: pgsql-performance
On May 24, 2006, at 4:24 PM, Larry Rosenman wrote:
> Also, is pg_xlog on the same or different spindles from the rest of  
> the
> PG Data directory?

It's sitting on the same disk array (but I'm doing 1 transaction  
every 5 minutes, and I'm not near the array's sustained write  
capacity, so I don't think that's currently limiting performance).

--
Daniel J. Luke
+========================================================+
| *---------------- dluke(at)geeklair(dot)net ----------------* |
| *-------------- http://www.geeklair.net -------------* |
+========================================================+
|   Opinions expressed are mine and do not necessarily   |
|          reflect the opinions of my employer.          |
+========================================================+


In response to

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2006-05-24 21:32:25
Subject: Re: Getting even more insert performance (250m+rows/day)
Previous:From: Larry RosenmanDate: 2006-05-24 20:24:20
Subject: Re: Getting even more insert performance (250m+rows/day)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group