Results 1 to 3 of 3

Thread: Infinite Query

  1. #1
    Join Date
    Aug 2010
    Posts
    1

    Unanswered: Infinite Query

    Hi.
    Im Running PostgreSQL 8.4.1 on a Red Hat Enterprise Linux Server release 5.4 (Tikanga).
    I need to run an Infinite Query (or at least one that takes a lot of time to process) to test a Monitoring Server i've installed on another Computer.
    The databases i'm using are small, so using Vacumms/Reindex doesnt help (they dont take too much...).

    Any ideas?

    Thanks in advance.
    Bye!

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Code:
    SELECT i, j, i + ji
    FROM generate_series(1, 10000) i
    CROSS JOIN generate_series(1, 10000) j
    ORDER BY 3

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    That's a nice one, that'll probably really take a long time

Posting Permissions

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