[GENERAL] Maintenance commands on standby servers

2011-02-07 Thread Sylvain Rabot
imary" [1]. [1] http://www.postgresql.org/docs/9.0/static/hot-standby.html#HOT-STANDBY-ADMIN Regards. -- Sylvain Rabot signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Maintenance commands on standby servers

2011-02-08 Thread Sylvain Rabot
On Tue, 2011-02-08 at 21:05 +0900, Fujii Masao wrote: > On Tue, Feb 8, 2011 at 4:04 AM, Sylvain Rabot wrote: > > Is it possible to run maintenance commands like ANALYZE, VACUUM, CLUSTER > > on a standby server ? > > No. > > Since the effect of the maintenance command

[GENERAL] Partitioning and constraint exclusion

2011-06-21 Thread Sylvain Rabot
Hi list, I'm trying to do some partitioning on a table but I have a problem with constraint exclusion. Here the following code : https://gist.github.com/1038133 (this code is just an example to explain the problem) As you can see I declare a fake immutable function in order to make constraint e

Re: [GENERAL] Partitioning and constraint exclusion

2011-06-21 Thread Sylvain Rabot
On Tue, 2011-06-21 at 12:25 -0400, Tom Lane wrote: > Sylvain Rabot writes: > > On Postgres 9.1beta2 when i run this code the first select will use > > contraint exclusion but the second will not. > > This apparently has something to do with the size of the array > > ret