Re: PostgreSQL HardWare

I mean seventy thousand in fact...

the main question is that i have 70.000 records in one table, 90.000 in the
other one, but there it's a lot of backend process like triggers, pgsql
functions, inserts, updates. So simple querys works very good but what about
some hard work?, what you say it's that ammount of records it's not a problem?

> i'm guessing he meant what he said, 70.000, which
> to american audiences reads as seventy thousand
> and is written as 70,000. european countries use
> a period as the thousands separator rather than a
> comma like we do.
>
> rjsjr
>
> > -----Original Message-----
> > From: pgsql-general-owner(at)postgresql(dot)org
> > [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of
> > Troy(dot)Campano(at)LibertyMutual(dot)com
> > Sent: Friday, January 04, 2002 1:30 PM
> > To: jwbaker(at)acm(dot)org; snmartin(at)galilea(dot)cl
> > Cc: pgsql-general(at)postgresql(dot)org
> > Subject: Re: [GENERAL] PostgreSQL HardWare
> >
> >
> > Well did he mean 70.000 records or 70,000 records?
> >
> >
> >
> >
> > -----Original Message-----
> > From: Jeffrey W. Baker [mailto:jwbaker(at)acm(dot)org]
> > Sent: Friday, January 04, 2002 2:02 PM
> > To: Fernando San Martín Woerner
> > Cc: pgsql-general(at)postgresql(dot)org
> > Subject: Re: [GENERAL] PostgreSQL HardWare
> >
> >
> >
> >
> > On Fri, 4 Jan 2002, Fernando San Martín Woerner wrote:
> >
> > > I need to build a postgresql database with 2 tables containing 70.000
> > > records each one, but they'll increase their size in 4.000 records
> > > monthly and some triggers and functions will be running on this tables
> > > plus other smaller tables less than 40.000 records.
> >
> > That's a really small database. You should be able to run it on
> > practically
> > any hardware, and probably store all the data in memory.
> >
> > -jwb
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
Galilea S.A.