Re: Out of memory on SELECT in 8.3.5

Поиск
Список
Период
Сортировка
Искать
От
Grzegorz Jaśkiewicz
Тема
Re: Out of memory on SELECT in 8.3.5
Дата
Msg-id
2f4958ff0902090101r415442d6m3fbf3775381074dd@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Tom Lane <tgl@sss.pgh.pa.us>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Tom Lane <tgl@sss.pgh.pa.us>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 Tom Lane <tgl@sss.pgh.pa.us>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Tom Lane <tgl@sss.pgh.pa.us>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Tom Lane <tgl@sss.pgh.pa.us>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 Scott Marlowe <scott.marlowe@gmail.com>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Scott Marlowe <scott.marlowe@gmail.com>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 Scott Marlowe <scott.marlowe@gmail.com>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 Tom Lane <tgl@sss.pgh.pa.us>
Re: Out of memory on SELECT in 8.3.5 Scott Marlowe <scott.marlowe@gmail.com>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Scott Marlowe <scott.marlowe@gmail.com>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Scott Marlowe <scott.marlowe@gmail.com>
Re: Out of memory on SELECT in 8.3.5 Scott Marlowe <scott.marlowe@gmail.com>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 John R Pierce <pierce@hogranch.com>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <matt@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Scott Marlowe <scott.marlowe@gmail.com>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
Re: Out of memory on SELECT in 8.3.5 Stephen Frost <sfrost@snowman.net>
Re: Out of memory on SELECT in 8.3.5 "Matt Magoffin" <postgresql.org@msqr.us>
On Mon, Feb 9, 2009 at 8:53 AM, Matt Magoffin  wrote:
>>> We have 100+ postgres processes running, so for an individual process,
>>> could the 1024 file limit be doing anything to this query? Or would I
>>> see
>>> an explicit error message regarding this condition?
>>
>> you would get one of "Open files rlimit 1024 reached for uid xxxx" in
>> syslog (which you should checkout anyhow).
>
> No... nothing like this in syslog.
>

So did the backend crashed on this one, or just produced 'out of
memory ' message ?

-- 
GJ
В списке pgsql-general по дате отправления
От: Matt Magoffin
Дата:
От: Scara Maccai
Дата:
FAQ