Re: Question about partitioned query behavior

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ranga,

* Ranga Gopalan (ranga_gopalan@xxxxxxxxxxx) wrote:
> It seems that this is an issue faced by others as well - Please see this link: http://stackoverflow.com/questions/2236776/efficient-querying-of-multi-partition-postgres-table
> 
> Is this a known bug? Is this something that someone is working on or is there a known work around?

Actually, if you look at that, the problem the original poster had was
that they didn't have constraint_exclusion turned on.  Then they were
complaining about having the (empty) master table and the needed
partition included (which, really, shouldn't be that big a deal).

Did you look at what the other reply suggested?  Do you have
constraint_exclusion = 'on' in your postgresql.conf?

	Thanks,

		Stephen

Attachment: signature.asc
Description: Digital signature


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux