Greg Smith wrote:
Joseph S wrote:
Greg Smith wrote:
Joseph S wrote:
So I run "select count(*) from large_table" and I see in xosview a
solid block of write activity. Runtime is 28125.644 ms for the first
run. The second run does not show a block of write activity and
takes 3327.441 ms
http
Joseph S wrote:
Greg Smith wrote:
Joseph S wrote:
So I run "select count(*) from large_table" and I see in xosview a
solid block of write activity. Runtime is 28125.644 ms for the first
run. The second run does not show a block of write activity and
takes 3327.441 ms
http://wiki.postgresql.
Greg Smith wrote:
Joseph S wrote:
So I run "select count(*) from large_table" and I see in xosview a
solid block of write activity. Runtime is 28125.644 ms for the first
run. The second run does not show a block of write activity and takes
3327.441 ms
http://wiki.postgresql.org/wiki/Hint_Bit
Joseph S wrote:
So I run "select count(*) from large_table" and I see in xosview a
solid block of write activity. Runtime is 28125.644 ms for the first
run. The second run does not show a block of write activity and takes
3327.441 ms
http://wiki.postgresql.org/wiki/Hint_Bits
--
Greg Smith
Hint bit I/O?
Ken
On Wed, Dec 09, 2009 at 01:29:00PM -0500, Joseph S wrote:
> I just installed a shiny new database server with pg 8.4.1 running on
> CentOS 5.4. After using slony to replicate over my database I decided to
> do some basic performance tests to see how spiffy my shiny new server
I just installed a shiny new database server with pg 8.4.1 running on
CentOS 5.4. After using slony to replicate over my database I decided to
do some basic performance tests to see how spiffy my shiny new server
is. This machine has 32G ram, over 31 of which is used for the system
file cache
On 12/07/2009 12:12 PM, Ben Brehmer wrote:
Hello All,
I'm in the process of loading a massive amount of data (500 GB). After
some initial timings, I'm looking at 260 hours to load the entire 500GB.
10 days seems like an awfully long time so I'm searching for ways to
speed this up. The load is ha