On May 22, 2013, at 4:06 PM, Greg Smith wrote:
> And there are some other products with interesting price/performance/capacity
> combinations that are also sensitive to wearout. Seagate's hybrid drives
> have turned interesting now that they cache writes safely for example.
> There's no cheap
On Mar 13, 2013, at 3:23 PM, Steve Crawford wrote:
> On 03/13/2013 09:15 AM, John Lister wrote:
>> On 13/03/2013 15:50, Greg Jaskiewicz wrote:
>>> SSDs have much shorter life then spinning drives, so what do you do when
>>> one inevitably fails in your system ?
>> Define much shorter? I accept th
Considering this list is where I first learned of the Intel 320 drives (AFAIK,
the only non-enterprise SSDs that are power-failure safe), I thought I'd see if
any of the folks here that tend to test new stuff have got their hands on these
yet.
I had no idea these drives were out (but they still
Hello,
Time for a broad question. I'm aware of some specific select queries that will
generate disk writes - for example, a sort operation when there's not enough
work_mem can cause PG to write out some temp tables (not the correct
terminology?). That scenario is easily remedied by enabling "
For the top-post scanners, I updated the ssd test to include
changing the zfs recordsize to 8k.
On Feb 11, 2012, at 1:35 AM, CSS wrote:
>
> On Feb 3, 2012, at 6:23 AM, Ivan Voras wrote:
>
>> On 31/01/2012 09:07, CSS wrote:
>>> Hello all,
>>>
>>> J
On Feb 3, 2012, at 6:23 AM, Ivan Voras wrote:
> On 31/01/2012 09:07, CSS wrote:
>> Hello all,
>>
>> Just wanted to share some results from some very basic benchmarking
>> runs comparing three disk configurations on the same hardware:
>>
>> http://m
Hello all,
Just wanted to share some results from some very basic benchmarking
runs comparing three disk configurations on the same hardware:
http://morefoo.com/bench.html
Before I launch into any questions about the results (I don't see
anything particularly shocking here), I'll describe the ha
On Nov 19, 2011, at 11:21 AM, Greg Smith wrote:
> On 11/18/2011 04:55 AM, CSS wrote:
>> I'm also curious about benchmarking using my own data. I tried something
>> long ago that at least gave the illusion of working, but didn't seem quite
>> right to me. I ena
Hello,
I'm going to be testing some new hardware (see
http://archives.postgresql.org/pgsql-performance/2011-11/msg00230.php) and
while I've done some very rudimentary before/after tests with pgbench, I'm
looking to pull more info than I have in the past, and I'd really like to
automate things
Resurrecting this long-dormant thread...
On Oct 14, 2011, at 6:41 AM, Arjen van der Meijden wrote:
> On 14-10-2011 10:23, CSS wrote:
>> -I'm calling our combined databases at 133GB "small", fair
>> assumption? -Is there any chance that a server with dual quad core
Hello all,
I've spent some time looking through previous posts regarding
postgres and SSD drives and have also been reading up on the
subject of SSDs in general elsewhere.
Some quick background:
We're currently looking at changing our basic database setup as we
migrate away from some rather old
11 matches
Mail list logo
