Re: PGSQL with high number of database rows? - Mailing list pgsql-general

From Harvey, Allan AC
Subject Re: PGSQL with high number of database rows?
Date
Msg-id E97A5BB7699CAD48BE2711E712471165536AE0@ntlmsg03.onesteel.com
Whole thread Raw
In response to PGSQL with high number of database rows?  (Tim Perrett <hello@timperrett.com>)
List pgsql-general
Tim,
> massive, around 20,000 new rows in one of the tables per day. 
As an example...
I'm doing about 4000 inserts spread across about 1800 tables per minute.
Pisses it in with fsync off and the PC ( IBM x3650 1 CPU, 1 Gig memory ) on a UPS.

Allan


The material contained in this email may be confidential, privileged or copyrighted. If you are not the intended
recipient,use, disclosure or copying of this information is prohibited. If you have received this document in error,
pleaseadvise the sender and delete the document. Neither OneSteel nor the sender accept responsibility for any viruses
containedin this email or any attachments.
 

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: assistance needed for autovacuum on the windows version of 8.2.3
Next
From: Philip Hallstrom
Date:
Subject: Re: Nice, web-based SNMP-Frontend for pgsnmpd?