Re: [BUGS] BUG #3494: may be Query Error: subplan does not executed

2007-07-28 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > Sergey Burladyan wrote: >> i have query with join of two table and 'where' filter it result by subplan >> which have references to join result, but this subplan not executed and >> result is incorrect. This subplan also not exist in explain analyze o

[BUGS] BUG #3495: PostgreSQL does not use POSIX SHM or SEM in place of SYSV equivalents

2007-07-28 Thread Roger Leigh
The following bug has been logged online: Bug reference: 3495 Logged by: Roger Leigh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Debian GNU/Linux (glibc 2.6, linux 2.6.22) Description:PostgreSQL does not use POSIX SHM or SEM in place o

Re: [BUGS] BUG #3495: PostgreSQL does not use POSIX SHM or SEM in place of SYSV equivalents

2007-07-28 Thread Heikki Linnakangas
Roger Leigh wrote: > The following bug has been logged online: Not a bug, but a feature request... > PostgreSQL is using the old SYSV shared memory and semaphores, as evidenced > by ipcs: > ... > However, the SYSV memory limit is set in-kernel and while it can be easily > changed, it is rather le

Re: [BUGS] BUG #3495: PostgreSQL does not use POSIX SHM or SEM in place of SYSV equivalents

2007-07-28 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > Roger Leigh wrote: >> PostgreSQL is using the old SYSV shared memory and semaphores, as evidenced >> by ipcs: > A patch to do that submitted was submitted in Spring, but it was not > accepted for 8.3 because there was some issues with it. More str