[GENERAL] Table partitioning?

[Gerald Gutierrez]

I was browsing some database mailing lists and found this message available 
at:

--
(http://www.phpbuilder.com/forum/read.php3?num=2&id=139678&thread=139671)
I don't know MSSQL, but if it tries to compete with Oracle, it should have 
this funcitonality (which oracle does):

divide tables into smaller tables that are searched on queries based on a 
set field/rule.

An example of this would be:  given the first character of a text column, 
insert the row into the table partition that has other rows with the same 
letter.   When a query is done where mycol = 'axxs'; the first thing Oracle 
does is decide which table partition to use and then does the rest of the 
where statement.

You should be able to design a database application without ever caring how 
many rows will be in each table...as I said, dealing with that is a DBA issue.
--

It seems that, depending on how data is actually stored on disk and 
accessed, this method of partitioning a table internally in the database 
could be a benefit. Has anyone investigated this for PostgreSQL?


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] Compiling to RPM setup/filesystem layout

[Gerald Gutierrez]

Hi all. Thanks for all the good advice on how to deal with the source and 
the RPMs. The PostgreSQL RPM "god" has just spoken, so I think I'll be 
waiting until Saturday to get the new RPMs. But I'll be saving the messages 
for when the next version of PostgreSQL comes out and I can't wait for the 
prepackaged binaries.

:)

Gerald.

At 04:26 PM 5/31/2001 -0400, Lamar Owen wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>On Thursday 31 May 2001 15:59, Gerald Gutierrez wrote:
> > I'm patiently waiting for the 7.1.2 RPMs to be released. Since there's no
> > indication when they may be ready, I'd like to try compiling PostgreSQL
> > myself.
>
>Oooo... Saturday afternoon.  I'm making a few changes to the build that I
>need to test before releasing, so expect a release Saturday.


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html