write banks - Search results in mailing lists
Mailing lists >> pgsql-performance >> Thread
2012-02-07 15:26:55 | Re: Index with all necessary columns - Postgres vs MSSQL (Merlin Moncure)
write once or read mostly tables will see a lot more benefit than high traffic oltp type tables. regarding postgresql 9.2 by june, the official release schedule has 9.2 going into beta by april
Mailing lists >> pgsql-performance >> Thread
2011-11-17 23:45:07 | Re: SSD options, small database, ZFS (CSS)
banks. If I understand it correctly, this is due to the memory controller moving from the south(?)bridge to being integrated in the CPU. That's an interesting point, I'd not even considered
Mailing lists >> pgsql-performance >> Thread
2011-07-10 04:37:44 | Re: DELETE taking too much memory (French, Martin)
write this query ? Would postgres 8.4/9.0 handle things better ? Thanks in advance. -- Vincent de Phily -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http:///mailpref/pgsql-performance ___________________________________________________ This email is intended
Mailing lists >> pgsql-performance >> Thread
2011-06-21 19:17:46 | Re: Contemplating SSD Hardware RAID (Greg Smith)
banks of SSD will buy Intel, and the "Enterprise" feature set seems completely enough that it doesn't set off any alarms to them. The same is not true of OCZ, which unfortunately means
Mailing lists >> pgsql-performance >> Thread
2010-11-13 14:38:59 | Re: MVCC performance issue (Mladen Gogala)
banks. The example is plain silly. Here is what I have in mind as "write
Mailing lists >> pgsql-performance >> Thread
2009-11-13 16:22:33 | Re: SSD + RAID (Dave Crooke)
write performance, and terrible performance in degraded mode - there are a few edge cases, but in almost all cases you should be using RAID-10 for a database. - Like most apps, the ultimate
Mailing lists >> pgsql-performance >> Thread
2009-09-14 20:13:44 | Re: CLUSTER and a problem (Tom Lane)
writes: So this is the slow bit: It's doing a scan in descending datazaw order and hoping to find a row that has both telekredytid = 328650 and bank
Mailing lists >> pgsql-performance >> Thread
2009-03-11 14:06:59 | Re: random_page_cost vs ssd? (Scott Carey)
write performance are doing it, with advanced LBA to physical dynamic mapping. As for the random_page_cost I'd make sure to set it virtually the same as the sequential cost. Perhaps
Mailing lists >> pgsql-performance >> Thread
2008-06-26 13:14:14 | Re: Hardware vs Software RAID (Matthew Wakeling)
writes was no longer true these days? Matthew -- I work for an investment bank. I have
Mailing lists >> pgsql-performance >> Thread
2008-03-03 10:53:55 | Re: How to allocate 8 disks (Craig James)
banking system. And as far as zero write traffic, I don't know where that
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2004-07-25 20:09:40 | Re: Working on huge RAM based datasets (Andy Ballingall)
write speeds to improve, which would add to the gains which I am fishing for here. My scenario assumes nothing about how the data is stored, but you are right to flag the problems that
Mailing lists >> pgsql-performance >> Thread
2003-08-06 09:43:29 | Re: PostgreSQL performance problem -> tuning (Yaroslav Mazurak)
write 25 numbers. :) I'm also worried for errors. I think that cost estimator "pushed into very strange corner" by himself. OK, all unnecessary "LIKEs" replaced by "=", JOIN removed too: CREATE OR REPLACE FUNCTION showcalc