Re: Re: Suggestions for the best strategy to emulate returning multiple sets of results
| От | Seref Arikan |
|---|---|
| Тема | Re: Re: Suggestions for the best strategy to emulate returning multiple sets of results |
| Дата | |
| Msg-id | CA+4ThdqMkVjpArTReetbbPAq666F7+WtxzEH42RbgGbfD2xXTA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Suggestions for the best strategy to emulate returning multiple sets of results (Jasen Betts <jasen@xnet.co.nz>) |
| Список | pgsql-general |
Jasen,
Thanks for this. My last use of ramdisk was ages ago and I've always had the idea that it was just a disk in ram with no capability to spill over to disk.
It appears the mind refuses to acknowledge that this has been the situation many years ago :)
Some google searches returned others asking the same question, surely someone must have properly established this under *nix. I'll keep searching, and post my solution for feedback.
Kind regards
Seref
Thanks for this. My last use of ramdisk was ages ago and I've always had the idea that it was just a disk in ram with no capability to spill over to disk.
It appears the mind refuses to acknowledge that this has been the situation many years ago :)
Some google searches returned others asking the same question, surely someone must have properly established this under *nix. I'll keep searching, and post my solution for feedback.
Kind regards
Seref
On Sun, Oct 14, 2012 at 5:54 AM, Jasen Betts <jasen@xnet.co.nz> wrote:
On 2012-10-10, Seref Arikan <serefarikan@kurumsalteknoloji.com> wrote:
> --f46d0443048225e0e704cbb5e0ee
> Content-Type: text/plain; charset=ISO-8859-1>That's what operating systems are for, ramdisk is only ever a hint,
> Thanks Bret,
> I'm concerned about what happens when my functions under high load fills
> the ramdrive with temporary tables I'm using. The advantage of telling
> postgres to use ram with an option to fall back to disk is significantly
> better in terms of uptime.
> However, I was thinking about some mechanism in the middle tier that
> watches the space in the ram drive and redirects queries to functions that
> create temp tables on disk, if ram drive is close to full. That may help me
> accomplish what I'm trying to
is ram is short it will wind up in swap, if ram is plentiful a disk
table will be fully buffered in ram.
--
⚂⚃ 100% natural
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: