Request for comment... 
Author Message
 Request for comment...

My previous post was a knee jerk reaction to a crash of Postmaster.  I did not list it
but Postmaster was named in the crash dump.  The top of the message is repeated
here...

        Unable to handle kernel NULL pointer dereference at virtual address
00000073
        *pde = 00000000
        Oops = 0002
        cpu = 0
        eip = 0010:[<e080c060>]
        eflags = 00010206
        ...
        ...
        ...

My request for comment is comprised of three parts...

1.)  What hardware should I consider when looking at Linux?  I know this is a broad
question but the answer is simple.  What hardware are you using to run you Linux
implementation?

2.)  What Linux distribution is best suited for running PostgreSQL?  Again, what
distro are you using?

3.)  Is PostgreSQL well suited for the acquisition and storage of 24/7 insert-once,
never-update-or-delete data?  (Approximately 4 million records inserted from Jan 1
to Mar 31)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Mon, 20 Sep 2004 02:55:17 GMT
 Request for comment...

Bonjour William Meloney
Quote:

> My request for comment is comprised of three parts...

> 1.)  What hardware should I consider when looking at Linux?  I know this is a broad
> question but the answer is simple.  What hardware are you using to run you Linux
> implementation?

        Dual Processor Pentium III, SCSI, 512 Meg ram
Quote:

> 2.)  What Linux distribution is best suited for running PostgreSQL?  Again, what
> distro are you using?
        RedHat-7.2

> 3.)  Is PostgreSQL well suited for the acquisition and storage of 24/7 insert-once,
> never-update-or-delete data?  (Approximately 4 million records inserted from Jan 1
> to Mar 31)

        Yes, our Application (Regulus) is working 24/7, taking
        a lot of transaction.
        (I just checked, on our live demo, new version installed
         Marsh 22 we recorded 358992 transactions)
        Hope that help.

A bientot
==========================================================================

SAFE Inc.                       Phone: (514) 493-4280  Fax: (514) 493-1946
       REGULUS,  a real time accounting/billing package for ISP
           REGULUS' Home base <"http://www.regulus.safe.ca">
==========================================================================

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Mon, 20 Sep 2004 03:23:10 GMT
 Request for comment...
RedHat 7.2
PostgreSQL 7.2
Dual Pentium III, with 256MB RAM (really need 512MB as a minimum), SCSI
drives.

4 Million insert in one month and still going.

Remeber to VACUUM ANALYZE (very important for the planner).  Use the
tuning tips to tune at least shared_buffers, and sort_mem.

Quote:

> My previous post was a knee jerk reaction to a crash of Postmaster.  I did not list it
> but Postmaster was named in the crash dump.  The top of the message is repeated
> here...

>    Unable to handle kernel NULL pointer dereference at virtual address
> 00000073
>    *pde = 00000000
>    Oops = 0002
>    cpu = 0
>    eip = 0010:[<e080c060>]
>    eflags = 00010206
>    ...
>    ...
>    ...

> My request for comment is comprised of three parts...

> 1.)  What hardware should I consider when looking at Linux?  I know this is a broad
> question but the answer is simple.  What hardware are you using to run you Linux
> implementation?

> 2.)  What Linux distribution is best suited for running PostgreSQL?  Again, what
> distro are you using?

> 3.)  Is PostgreSQL well suited for the acquisition and storage of 24/7 insert-once,
> never-update-or-delete data?  (Approximately 4 million records inserted from Jan 1
> to Mar 31)

> ------------------------------

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Mon, 20 Sep 2004 22:26:14 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. A Thesaurus-based Search Engine for Images: Request for Comment

2. ASP: Request for Comment: Image retrieval database

3. OraFocus.com: Request for comments on DBA Tool

4. OraFocus.com: Request for comments on DBA Tool

5. A Thesaurus-based Search Engine for Images: Request for Comment

6. Request for Comment on OODBTG Final Technical Report

7. ASP: Request for Comment: Image retrieval database

8. Request For Comment: E-DUMP & E-LOAD

9. jBase and Universe request for comments

10. Request For Comments: Wish List for a CASE Environment

11. Accessing DBMSs via CORBA: request for comments


 
Powered by phpBB® Forum Software