Hi PSQL Hackers,

I have done the following Post to PSQL Performance, but Richard Huxton
say it
might be a better Idea to post it again on you List so i forward the
message.

apoc9009@yahoo.de wrote:

> Hi all,
>
> Ia a Guy from Germany an a strong Postgres believer!
> It is the best OpenSource Database i have ever have bee tasted and i
> try to using
> it in any Database Environments.
>
> It is exiting to see thadt Verison 8.0 has Tablespaces like ORACLE and
> DB/2,
> but i need Partitioning on a few very large Tables.


I believe these are being worked on at the moment. You might want to
search the archives of the hackers mailing list to see if the plans will
suit your needs.

--
Richard Huxton
Archonet Ltd


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

<apoc9009@yahoo.de> writes
> I have done the following Post to PSQL Performance, but Richard Huxton
> say it
> might be a better Idea to post it again on you List so i forward the
> message.
....
> It is exiting to see thadt Verison 8.0 has Tablespaces like ORACLE and
> DB/2,
> but i need Partitioning on a few very large Tables.
....

Richard said you can *search* in this list ... Here are two links might be
of your interests:

http://archives.postgresql.org/pgsql...2/msg00101.php - how
to do horizonal partition using inheritance;

http://archives.postgresql.org/pgsql...3/msg00370.php - a
long list of discussing the future partition implementation;


Regards,
Qingqing

Ok!
The Links your posted are great and i guessing it will help me a lot!

But the other Question (if Tablepartitioning under Developemt and will
it be supported generally)
is still alive.

Josh

Qingqing Zhou wrote:

><apoc9009@yahoo.de> writes
>
>
>>I have done the following Post to PSQL Performance, but Richard Huxton
>>say it
>>might be a better Idea to post it again on you List so i forward the
>>message.
>>
>>
>...
>
>
>>It is exiting to see thadt Verison 8.0 has Tablespaces like ORACLE and
>>DB/2,
>>but i need Partitioning on a few very large Tables.
>>
>>
>...
>
>Richard said you can *search* in this list ... Here are two links might be
>of your interests:
>
>http://archives.postgresql.org/pgsql...2/msg00101.php - how
>to do horizonal partition using inheritance;
>
>http://archives.postgresql.org/pgsql...3/msg00370.php - a
>long list of discussing the future partition implementation;
>
>
>Regards,
>Qingqing
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
*




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

There is a fairly lengthy discussion going on right now on the bizgres
mailing list about this topic, if your interested in helping out you
might want to join that list.

Robert Treat

On Tue, 2005-04-26 at 05:43, apoc9009@yahoo.de wrote:
> Ok!
> The Links your posted are great and i guessing it will help me a lot!
>
> But the other Question (if Tablepartitioning under Developemt and will
> it be supported generally)
> is still alive.
>
> Josh
>
> Qingqing Zhou wrote:
>
> ><apoc9009@yahoo.de> writes
> >
> >
> >>I have done the following Post to PSQL Performance, but Richard Huxton
> >>say it
> >>might be a better Idea to post it again on you List so i forward the
> >>message.
> >>
> >>
> >...
> >
> >
> >>It is exiting to see thadt Verison 8.0 has Tablespaces like ORACLE and
> >>DB/2,
> >>but i need Partitioning on a few very large Tables.
> >>
> >>
> >...
> >
> >Richard said you can *search* in this list ... Here are two links might be
> >of your interests:
> >
> >http://archives.postgresql.org/pgsql...2/msg00101.php - how
> >to do horizonal partition using inheritance;
> >
> >http://archives.postgresql.org/pgsql...3/msg00370.php - a
> >long list of discussing the future partition implementation;
> >
> >
> >Regards,
> >Qingqing
> >
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >
> >
> >
> *
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

On T, 2005-04-26 at 16:52 -0400, Robert Treat wrote:
> There is a fairly lengthy discussion going on right now on the bizgres
> mailing list about this topic, if your interested in helping out you
> might want to join that list.

Wow! there is a BizGres mailinglist !?

And this is where the table-partitioning discussion is!

Where is this mailing list ? I found nothing about it on bizgres
website.

I'd be definitely interested!

--
Hannu Krosing <hannu@tm.ee>

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Hannu,

> > There is a fairly lengthy discussion going on right now on the bizgres
> > mailing list about this topic, if your interested in helping out you
> > might want to join that list.
>
> Wow! there is a BizGres mailinglist !?
>
> And this is where the table-partitioning discussion is!
>
> Where is this mailing list ? I found nothing about it on bizgres
> website.

Yes, it's under Developer/Projects. I need to provide more links on stuff.

>
> I'd be definitely interested!

http://www.pgfoundry.org/projects/bizgres

--Josh

--
__Aglio Database Solutions_______________
Josh Berkus Consultant
josh@agliodbs.com www.agliodbs.com
Ph: 415-752-2500 Fax: 415-752-2387
2166 Hayes Suite 200 San Francisco, CA

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On K, 2005-04-27 at 15:40 -0700, Josh Berkus wrote:
> Hannu,
>
> > > There is a fairly lengthy discussion going on right now on the bizgres
> > > mailing list about this topic, if your interested in helping out you
> > > might want to join that list.
> >
> > Wow! there is a BizGres mailinglist !?
> >
> > And this is where the table-partitioning discussion is!
> >
> > Where is this mailing list ? I found nothing about it on bizgres
> > website.
>
> Yes, it's under Developer/Projects. I need to provide more links on stuff.

Jap. Already found and subscribed once I learned that I have to search
under bizgres .

Thanks!

--
Hannu Krosing <hannu@skype.net>


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

> There is a fairly lengthy discussion going on right now on the bizgres
> mailing list about this topic, if your interested in helping out you
> might want to join that list.

What's the point of keeping such backend development discussion separate
from the -hackers list? It's always been a mistake in the past...

Chris

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Christopher Kings-Lynne wrote:
> > There is a fairly lengthy discussion going on right now on the bizgres
> > mailing list about this topic, if your interested in helping out you
> > might want to join that list.
>
> What's the point of keeping such backend development discussion separate
> from the -hackers list? It's always been a mistake in the past...

That was my impression too.

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Christopher Kings-Lynne wrote:
> What's the point of keeping such backend development discussion separate
> from the -hackers list? It's always been a mistake in the past...

Yeah, it struck me as a bad idea as well.

-Neil

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match