I'd suggest you run it on a large ramdisk with fsync turned off on a 32 core computer, see what you get, that will be a good indication of a maximum.
Keep in mind though that 'postgres' with fsync (vs. without) is such a different creature that the comparison isn't meaningful. Similarly 'postgres' on volatile backing store vs. non-volatile isn't really a meaningful comparison. There's also a question here about the 't' in TPS. If you have no fsync and volatile storage, are you really doing 'transactions'? Depending on the definition you take, a transaction may have some sense of 'reliability' or atomicity which isn't reflected well in a ramdisk/no-fsync benchmark. It's probably not ideal to fill a mailing list with numbers that have no meaning attached to them, so why not set up a little web database or Google doc to record max TPS and how it was achieved? For example, imagine I tell you that the highest I've achieved is 1240000 tps. How does it help you if I say that? Graeme Bell On 10 Feb 2015, at 11:48, Luis Antonio Dias de Sá Junior <luisjunior...@gmail.com> wrote: > No problem with this. If anyone want to specify more details. > > But I want to know how far postgres can go. No matter OS or other variables. > > Gavin, you got more than 12000 TPS? > > 2015-02-09 19:29 GMT-02:00 Gavin Flower <gavinflo...@archidevsys.co.nz>: > On 10/02/15 08:30, Luis Antonio Dias de Sá Junior wrote: > Hi, > > A survay: with pgbench using TPS-B, what is the maximum TPS you're ever seen? > > For me: 12000 TPS. > > -- > Luis Antonio Dias de Sá Junior > Important to specify: > > 1. O/S > 2. version of PostgreSQL > 3. PostgreSQL configuration > 4. hardware configuration > 5. anything else that might affect performance > > I suspect that Linux will out perform Microsoft on the same hardware, and > optimum configuration for both O/S's... > > > Cheers, > Gavin > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > > > > -- > Luis Antonio Dias de Sá Junior -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
