Re: [BUGS] BUG #7524: Partitioning

2012-09-10 Thread Kevin Grittner
[Adding the OP back to CC, in case he's not subscribed to the list] Mark Kirkwood wrote: > On 09/09/12 14:01, Kevin Grittner wrote: >> "Pieter Viljoen Sr." wrote: >> >>> The TWO most important factors in hindering us to convert to >>> Postgres are the following: >>> >>> Parallel execution of qu

Re: [BUGS] BUG #7524: Partitioning

2012-09-09 Thread John R Pierce
On 09/09/12 9:31 PM, John R Pierce wrote: 2/ Is anyone working on parallel query execution? someone presented a FOSS project on the pg-general list the other day that implements parallel execution using a postgres based engine, but it only supports fairly simple queries. I can't say I reme

Re: [BUGS] BUG #7524: Partitioning

2012-09-09 Thread John R Pierce
On 09/09/12 6:04 PM, Mark Kirkwood wrote: 1/ What is the current state of table partitioning...is anyone working on something a bit more native than abusing inheritance? enterpriseDB's commercial 'oracle compatible' fork has the Oracle DDL for creating and managing partitions, but afaik, it us

Re: [BUGS] BUG #7524: Partitioning

2012-09-09 Thread Mark Kirkwood
On 09/09/12 14:01, Kevin Grittner wrote: wrote: The TWO most important factors in hindering us to convert to Postgres are the following: Parallel execution of queries. No Table Partitioning Not a bug, so off-topic for this list. If you need help figuring out how best to use PostgreSQL, or

Re: [BUGS] BUG #7524: Partitioning

2012-09-08 Thread Kevin Grittner
wrote: > The TWO most important factors in hindering us to convert to > Postgres are the following: > > Parallel execution of queries. > > No Table Partitioning Not a bug, so off-topic for this list. If you need help figuring out how best to use PostgreSQL, or whether it is a good fit for yo

[BUGS] BUG #7524: Partitioning

2012-09-07 Thread pieter
The following bug has been logged on the website: Bug reference: 7524 Logged by: Pieter Viljoen Email address: pie...@infomet.com PostgreSQL version: 9.1.5 Operating system: WIndows Enterprise Server Description: The TWO most important factors in hindering us to conve