Re: [HACKERS] swapcache-style cache?

2012-02-29 Thread Andrea Suisani
On 02/28/2012 08:54 AM, Andrea Suisani wrote: On 02/28/2012 04:52 AM, Rob Wultsch wrote: On Wed, Feb 22, 2012 at 2:31 PM, jamesja...@mansionfamily.plus.com wrote: Has anyone considered managing a system like the DragonFLY swapcache for a DBMS like PostgreSQL?

Re: [HACKERS] swapcache-style cache?

2012-02-29 Thread Rob Wultsch
On Mon, Feb 27, 2012 at 11:54 PM, Andrea Suisani sick...@opinioni.net wrote: On 02/28/2012 04:52 AM, Rob Wultsch wrote: On Wed, Feb 22, 2012 at 2:31 PM, jamesja...@mansionfamily.plus.com  wrote: Has anyone considered managing a system like the DragonFLY swapcache for a DBMS like

Re: [HACKERS] swapcache-style cache?

2012-02-28 Thread karavelov
- Цитат от Andrea Suisani (sick...@opinioni.net), на 28.02.2012 в 09:54 - On 02/28/2012 04:52 AM, Rob Wultsch wrote: On Wed, Feb 22, 2012 at 2:31 PM, jamesja...@mansionfamily.plus.com wrote: Has anyone considered managing a system like the DragonFLY swapcache for a DBMS like

Re: [HACKERS] swapcache-style cache?

2012-02-27 Thread Jan Lentfer
Am 23.02.2012 21:57, schrieb Greg Smith: On 02/22/2012 05:31 PM, james wrote: Has anyone considered managing a system like the DragonFLY swapcache for a DBMS like PostgreSQL? ie where the admin can assign drives with good random read behaviour (but perhaps also-ran random write) such as SSDs

Re: [HACKERS] swapcache-style cache?

2012-02-27 Thread Greg Smith
On 02/27/2012 03:24 PM, Jan Lentfer wrote: And, yes.. it does effect pgsql performance on read loads seriously. See BSD Mag 5/2011 http://bsdmag.org/magazine/1691-embedded-bsd-freebsd-alix and http://www.shiningsilence.com/dbsdlog/2011/04/12/7586.html Caching on the read-only pgbench is a

Re: [HACKERS] swapcache-style cache?

2012-02-27 Thread Rob Wultsch
On Wed, Feb 22, 2012 at 2:31 PM, james ja...@mansionfamily.plus.com wrote: Has anyone considered managing a system like the DragonFLY swapcache for a DBMS like PostgreSQL? https://www.facebook.com/note.php?note_id=388112370932 -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers

Re: [HACKERS] swapcache-style cache?

2012-02-27 Thread Andrea Suisani
On 02/28/2012 04:52 AM, Rob Wultsch wrote: On Wed, Feb 22, 2012 at 2:31 PM, jamesja...@mansionfamily.plus.com wrote: Has anyone considered managing a system like the DragonFLY swapcache for a DBMS like PostgreSQL? https://www.facebook.com/note.php?note_id=388112370932 in the same vein:

Re: [HACKERS] swapcache-style cache?

2012-02-23 Thread Greg Smith
On 02/22/2012 05:31 PM, james wrote: Has anyone considered managing a system like the DragonFLY swapcache for a DBMS like PostgreSQL? ie where the admin can assign drives with good random read behaviour (but perhaps also-ran random write) such as SSDs to provide a cache for blocks that were

[HACKERS] swapcache-style cache?

2012-02-22 Thread james
Has anyone considered managing a system like the DragonFLY swapcache for a DBMS like PostgreSQL? ie where the admin can assign drives with good random read behaviour (but perhaps also-ran random write) such as SSDs to provide a cache for blocks that were dirtied, with async write that