Postgres Pro
Downloads
Home   >   mailing lists

Re: ANALYZE sampling is too good - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ANALYZE sampling is too good
Date
Msg-id 31233.1386634629@sss.pgh.pa.us
Whole thread Raw
In response to Re: ANALYZE sampling is too good  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-hackers
Tree view 
Mark Kirkwood <mark.kirkwood@catalyst.net.nz> writes:
> I did a test run:

> pgbench scale 2000 (pgbench_accounts approx 25GB).
> postgres 9.4

> i7 3.5Ghz Cpu
> 16GB Ram
> 500 GB Velociraptor 10K

> (cold os and pg cache both runs)
> Without patch:  ANALYZE pgbench_accounts    90s
> With patch: ANALYZE pgbench_accounts  91s

> So I'm essentially seeing no difference :-(

What OS and filesystem?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: ANALYZE sampling is too good
Next
From: Jim Nasby
Date:
Subject: Re: [RFC] Shouldn't we remove annoying FATAL messages from server log?