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
Ответ на
Re: Out of memory on SELECT in 8.3.5 (Matt Magoffin)
Список
Дерево обсуждения
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 по дате отправления