Partitioning tables...

Поиск
Список
Период
Сортировка
Искать

Partitioning tables...

От:
Joe Maldonado <jmaldonado@webehosting.biz>
Дата:
Hello all,
	I currently have a project which will store roughly 10B  records in
postgres which will be inserted at a rate of about 40K/s.  While we have
adequate disk storage it is paramount that subsets of the data be
queryable quickly, without hindering the insert process to a crawl.

	I know in Oracle you can partition the tables into logical subsets and
was wondering if this was also possible in postgres.

Thanks in advance,
	-Joe

Re: Partitioning tables...

От:
Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
Дата:
On Thu, 31 Jul 2003, Joe Maldonado wrote:

> 	I know in Oracle you can partition the tables into logical subsets and
> was wondering if this was also possible in postgres.

I *think* that a partial index is probably your best bet.

-- 

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University
FAQ