Re: [GENERAL] How to move tables in another physial place

2007-05-22 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/22/07 12:58, Michelle Konzack wrote: > Am 2007-05-22 12:45:23, schrieb Ron Johnson: >> Your subject says "physial place", but then you ask about moving a >> table to another partition. >> >> Since partitions are sub-sections of tables, I don't un

Re: [GENERAL] How to move tables in another physial place

2007-05-22 Thread Michelle Konzack
Am 2007-05-22 12:45:23, schrieb Ron Johnson: > Your subject says "physial place", but then you ask about moving a > table to another partition. > > Since partitions are sub-sections of tables, I don't understand what > you are asking. :-) INSIDE the postgresql I use table partitioning but the wh

Re: [GENERAL] How to move tables in another physial place

2007-05-22 Thread Joshua D. Drake
Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/22/07 12:01, Michelle Konzack wrote: Hello, I am using Debian GNU/Linux 4.0 with postgresql 8.2. Now I have splited my Monster-Table of 580 GByte (historical timeline) into one table per year (= several 100 now) and use ta

Re: [GENERAL] How to move tables in another physial place

2007-05-22 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/22/07 12:01, Michelle Konzack wrote: > Hello, > > I am using Debian GNU/Linux 4.0 with postgresql 8.2. > > Now I have splited my Monster-Table of 580 GByte (historical timeline) > into one table per year (= several 100 now) and use table partit

Re: [GENERAL] How to move tables in another physial place

2007-05-22 Thread Joshua D. Drake
Michelle Konzack wrote: Hello, I am using Debian GNU/Linux 4.0 with postgresql 8.2. Now I have splited my Monster-Table of 580 GByte (historical timeline) into one table per year (= several 100 now) and use table partitioning. (Cool for pg_dump since I can dump singel tables and burn it now on