On Fri, Apr 4, 2014 at 5:20 PM, Scott Marlowe wrote:
> The real danger with consumer drives is they don't have supercaps and
> can and will therefore corrupt your data on power failure. The actual
> write cycles aren't a big deal for many uses, as now even consumer
> drives have very long write cy
On Fri, Apr 4, 2014 at 10:15 AM, Merlin Moncure wrote:
> For all around performance, the
> S3700 (2.5$/gb) IMO held the crown for most of 2013 and I think is
> still the one to buy. The s3500 (1.25$/gb) came out and also looks
> like a pretty good deal
The S3500 can be had for $1.00/GB now these
On Thu, Apr 3, 2014 at 12:44 PM, Brent Wood wrote:
> Does the RAID 1 array give any performance benefits over a single drive? I'd
> guess
> that writes may be slower, reads may be faster (if balanced) but data
> security is improved.
Unfortunately I didn't test a single drive as that's not a
co
On Thu, Apr 3, 2014 at 12:13 PM, Merlin Moncure wrote:
> On Wed, Apr 2, 2014 at 2:37 PM, Bret Stern
> wrote:
>> Any opinions/comments on using SSD drives with postgresql?
>
> Here's a single S3700 smoking an array of 16 15k drives (poster didn't
> realize that; was to focused on synthetic numbers
On Wed, Mar 20, 2013 at 12:37 PM, David Rees wrote:
> PostgreSQL 8.4.16 on CentOS 5.9.
>
> I've run into a situation where executing a \COPY from psql will hang
> and at that point it's impossible to terminate the COPY command.
Some additional notes:
Running psql on the sa
On Wed, Mar 20, 2013 at 1:12 PM, Martín Marqués
wrote:
> What happens if you use COPY ... FROM with the same data?
I will try that, but if you look at pg_stat_activity the full command
is a COPY ( Are you sure the process hangs (strange thing is that you can't
> terminate the backend)? Could it
PostgreSQL 8.4.16 on CentOS 5.9.
I've run into a situation where executing a \COPY from psql will hang
and at that point it's impossible to terminate the COPY command.
I've tried pg_cancel_backend and pg_terminalte_backend - even sending
the process itself a TERM signal.
Sending the process KILL
