Partitions and prepared statements?

From: Dave Johansen <davejohansen(at)gmail(dot)com>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Partitions and prepared statements?
Date: 2014-03-27 20:42:39
Message-ID: CAAcYxUfdcCKWw1+hA_gV3OUgZggBqpv1O4YER8Wa--_1DXt4wQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I'm working with a large database using 8.4 that's partitioned on 4 week
boundaries and when I use a prepared statement that limits by time as one
of the bind parameters the planner seems to not select just the partitions
of interest but wants to scan all of them. From reading the documentation
of 9.3 ( http://www.postgresql.org/docs/9.3/static/sql-prepare.html ), it
seems that this sort of limitation has been fixed. Is that a correct
interpretation of the documentation?
Thanks,
Dave

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2014-03-29 21:20:37 Re: Connection pooling - Number of connections
Previous Message Gudmundsson Martin (mg) 2014-03-27 07:38:51 Re: Stalls on PGSemaphoreLock