DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Partitioning Peoplesoft tables

  1. 10-09-2003, 07:23 AM #1
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

    Partitioning Peoplesoft tables

    Hi

    Has anyone used partitioning in Peoplesoft (v8) tables?

    Cheers
    Reply With Quote Reply With Quote
  2. 10-09-2003, 11:55 AM #2
    stmontgo's Avatar
    stmontgo
    stmontgo is offline Senior Advisor
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    ps_proj_resourcce an 80gb little bitty table in PS finacials

    steve
    I'm stmontgo and I approve of this message
    Reply With Quote Reply With Quote
  3. 10-09-2003, 11:56 AM #3
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    I have been using Peoplesoft 8.1.4 very extensively for a very big company is US. The DB size is around 600 GB now.
    There are about 20 big tables partitioned.

    What is up?

    Tamil
    Reply With Quote Reply With Quote
  4. 10-09-2003, 12:01 PM #4
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hi

    A collegue is working with Peoplesoft CRM (The old Vantive), there are a couple of tables which are quite big (around 300 million of rows) and we are thinking to use partitions for these tables. What partitioning options did you guys use? Range, Hash?
    Reply With Quote Reply With Quote
  5. 10-09-2003, 12:59 PM #5
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Range Partition.

    Tamil
    Reply With Quote Reply With Quote
  6. 10-09-2003, 02:07 PM #6
    stmontgo's Avatar
    stmontgo
    stmontgo is offline Senior Advisor
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    it's been a few months but I think we did range by effective date

    steve
    I'm stmontgo and I approve of this message
    Reply With Quote Reply With Quote
  7. 10-10-2003, 04:03 AM #7
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ok, will have a look at that column


    cheers
    Reply With Quote Reply With Quote
  8. 10-10-2003, 08:34 AM #8
    stmontgo's Avatar
    stmontgo
    stmontgo is offline Senior Advisor
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by stmontgo
    it's been a few months but I think we did range by effective date

    steve
    range partition by month i beleive on effective date.
    I'm stmontgo and I approve of this message
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width