Re: Partitioning tables...

From: Sam Barnett-Cormack <s(dot)barnett-cormack(at)lancaster(dot)ac(dot)uk>
To: Joe Maldonado <jmaldonado(at)webehosting(dot)biz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Partitioning tables...
Date: 2003-08-01 08:43:22
Message-ID: Pine.LNX.4.50.0308010942590.5023-100000@short.lancs.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Barnett-Cormack 2003-08-01 08:56:47 VACUUM/VACUUM FULL/REINDEX
Previous Message Mauri Sahlberg 2003-08-01 06:54:39 Re: Parallel transactions failing oddly