RE: Hardware for writing/updating 12,000,000 rows per hour

2019-07-28 Thread farjad . farid
mail.com>> Cc: Tom Lane mailto:t...@sss.pgh.pa.us>>; Ron mailto:ronljohnso...@gmail.com>>; pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org> Subject: Re: Hardware for writing/updating 12,000,000 rows per hour On 2019-Jul-26, Arya F wrote: > I think I can

Re: Hardware for writing/updating 12,000,000 rows per hour

2019-07-27 Thread Neil
F mailto:arya6...@gmail.com>> > Cc: Tom Lane mailto:t...@sss.pgh.pa.us>>; Ron > mailto:ronljohnso...@gmail.com>>; > pgsql-general@lists.postgresql.org <mailto:pgsql-general@lists.postgresql.org> > Subject: Re: Hardware for writing/updating 12,000,000 rows per hou

RE: Hardware for writing/updating 12,000,000 rows per hour

2019-07-27 Thread farjad . farid
July 27 17:56 To: farjad.farid Cc: Alvaro Herrera ; Tom Lane ; Ron ; pgsql-general@lists.postgresql.org Subject: Re: Hardware for writing/updating 12,000,000 rows per hour On Sat, Jul 27, 2019 at 11:49 AM farjad.farid mailto:farjad.fa...@checknetworks.com>> wrote: With this kind of

Re: Hardware for writing/updating 12,000,000 rows per hour

2019-07-27 Thread Arya F
of some kind, depending > on the budget is worth the effort. > > > > -Original Message- > From: Alvaro Herrera > Sent: 2019 July 26 22:39 > To: Arya F > Cc: Tom Lane ; Ron ; > pgsql-general@lists.postgresql.org > Subject: Re: Hardware for writing/updating 1

RE: Hardware for writing/updating 12,000,000 rows per hour

2019-07-27 Thread farjad . farid
a Sent: 2019 July 26 22:39 To: Arya F Cc: Tom Lane ; Ron ; pgsql-general@lists.postgresql.org Subject: Re: Hardware for writing/updating 12,000,000 rows per hour On 2019-Jul-26, Arya F wrote: > I think I can modify my application to do a batch update. Right now > the server has an HDD

Re: Hardware for writing/updating 12,000,000 rows per hour

2019-07-26 Thread Alvaro Herrera
On 2019-Jul-26, Arya F wrote: > I think I can modify my application to do a batch update. Right now the > server has an HDD and it really can't handle a lot of updates and inserts > per second. Would changing to a regular SSD be able to easily do 3000 > updates per second? That's a pretty hard qu

Re: Hardware for writing/updating 12,000,000 rows per hour

2019-07-26 Thread Arya F
On Fri, Jul 26, 2019 at 3:24 PM Tom Lane wrote: > [ please don't top-post ] > > Arya F writes: > > On Fri, Jul 26, 2019 at 3:03 PM Ron wrote: > >> On 7/26/19 2:56 PM, Arya F wrote: > >>> Would it be possible to achieve 12,000,000 writes/updates on a single > >>> server? If so what kind of hardw

Re: Hardware for writing/updating 12,000,000 rows per hour

2019-07-26 Thread Tom Lane
[ please don't top-post ] Arya F writes: > On Fri, Jul 26, 2019 at 3:03 PM Ron wrote: >> On 7/26/19 2:56 PM, Arya F wrote: >>> Would it be possible to achieve 12,000,000 writes/updates on a single >>> server? If so what kind of hardware should I be looking for? >> That's only 3,333 modification

Re: Hardware for writing/updating 12,000,000 rows per hour

2019-07-26 Thread Arya F
As most about 2000 characters. On Fri, Jul 26, 2019 at 3:03 PM Ron wrote: > On 7/26/19 2:56 PM, Arya F wrote: > > Would it be possible to achieve 12,000,000 writes/updates on a single > > server? If so what kind of hardware should I be looking for? > > That's only 3,333 modifications/second. Ho

Re: Hardware for writing/updating 12,000,000 rows per hour

2019-07-26 Thread Ron
On 7/26/19 2:56 PM, Arya F wrote: Would it be possible to achieve 12,000,000 writes/updates on a single server? If so what kind of hardware should I be looking for? That's only 3,333 modifications/second.  How big are your records? -- Angular momentum makes the world go 'round.

Hardware for writing/updating 12,000,000 rows per hour

2019-07-26 Thread Arya F
Would it be possible to achieve 12,000,000 writes/updates on a single server? If so what kind of hardware should I be looking for?