Re: R: [HACKERS] Table Partitioning is in 8.1
On Fri, 2005-09-23 at 12:30 +0200, Paolo Magnoli wrote: It would be good to have an insert behaviour similar to Oracle by default. OK, thanks. Also I see that the original table is always scanned, partition exclusion happens only on the derived tables, is this correct? Yes, though if you avoid placing any rows in that table it is quick. I expect to remove that restriction in 8.2 by declarative SQL. Best Regards, Simon Riggs ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: R: [HACKERS] Table Partitioning is in 8.1
Paolo Magnoli wrote: Hi, I seem to recall that in Oracle you load into specific partitions without specifically naming them in insert statements (in other words you insert into table, the engine redirects data to the corrisponding partition), This is correct -- ___ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. ___ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster