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
query use its index
on the primary key.
Thank you,
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
,
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
| Europe/Jersey
update_process_title | off
wal_buffers | 128kB
work_mem | 24MB
Thanks for any help,
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