Re: [HACKERS] Partitions implementation with views

2003-12-01 Thread Greg Stark
Jonathan Gardner [EMAIL PROTECTED] writes: Usually, it is data that is related to each other somehow. I guess an example would be for an internet host who wants to provide a common shopping cart functionality for all of its customers, but put their specific data on a specific partition for

Re: [HACKERS] Partitions implementation with views

2003-12-01 Thread Hannu Krosing
Greg Stark kirjutas E, 01.12.2003 kell 18:15: Separate OS partitions is a reasonable use of partitioned tables, but the biggest advantage is being able to drop and load partitions very quickly, and without impacting performance at all. loading or dropping millions of records becomes a simple

Re: [HACKERS] Partitions implementation with views

2003-12-01 Thread Greg Stark
Hannu Krosing [EMAIL PROTECTED] writes: Greg Stark kirjutas E, 01.12.2003 kell 18:15: Separate OS partitions is a reasonable use of partitioned tables, but the biggest advantage is being able to drop and load partitions very quickly, and without impacting performance at all. loading or

[HACKERS] Partitions implementation with views

2003-11-30 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've seen a lot about partitions recently, and I had a bright idea. I am by no means a database expert, so perhaps this is utter nonsense. A partition, as I understand it, contains only a select subset of a table. Usually, it is data that is