Re: [PERFORM] need to repeat the same condition on joined tables in order to choose the proper plan

2011-06-15 Thread Svetlin Manavski
key in the other. That should be massively common in every non trivial DB application. Maybe it does make sense to consider that specific case in the planner, doesn't it? Thank you, Svetlin Manavski On Tue, Jun 14, 2011 at 5:29 PM, Tom Lane t...@sss.pgh.pa.us wrote: Svetlin Manavski

[PERFORM] seq scan in the case of max() on the primary key column

2011-06-16 Thread Svetlin Manavski
query use its index on the primary key. Thank you, Svetlin Manavski

Re: [PERFORM] seq scan in the case of max() on the primary key column

2011-06-17 Thread Svetlin Manavski
Yes, confirmed that the problem is in the partitioned table. Shaun, that solution is brilliant. Thank you, Svetlin Manavski On Thu, Jun 16, 2011 at 7:36 PM, Shaun Thomas stho...@peak6.com wrote: On 06/16/2011 12:25 PM, Magnus Hagander wrote: PostgreSQL 9.0 is unable to use an index scan

[PERFORM] is parallel union all possible over dblink?

2011-06-29 Thread Svetlin Manavski
, Svetlin Manavski

Re: [PERFORM] is parallel union all possible over dblink?

2011-07-01 Thread Svetlin Manavski
-II in its current state is good only for very simple applications, which are not supposed to be reliable at all. Thank you, Svetlin Manavski On Wed, Jun 29, 2011 at 8:14 PM, Greg Spiegelberg gspiegelb...@gmail.comwrote: This does work however you'll need to add a little more to it to ensure

[PERFORM] Join over two tables of 50K records takes 2 hours

2011-10-13 Thread Svetlin Manavski
| Europe/Jersey update_process_title | off wal_buffers | 128kB work_mem | 24MB Thanks for any help, Svetlin Manavski

Re: [PERFORM] Join over two tables of 50K records takes 2 hours

2011-10-14 Thread Svetlin Manavski
that routine was failing to perform analyze on appqosdata.icmptraffic and its children due to another issue... Regards, Svetlin Manavski On Fri, Oct 14, 2011 at 5:37 AM, Tom Lane t...@sss.pgh.pa.us wrote: Svetlin Manavski svetlin.manav...@gmail.com writes: I am running 9.03 with the settings