Re: [PERFORM] PGSQL Capacity

2005-05-10 Thread Jim C. Nasby
http://stats.distributed.net has a table that's 130M rows. http://stats.distributed.net/participant/phistory.php?project_id=8&id=39622 is a page that hits that table, and as you can see it's quite fast. This is on a dual opteron with 4G of memory. Unless you're looking for sub millisecond response

Re: [PERFORM] PGSQL Capacity

2005-05-09 Thread Chris Browne
[EMAIL PROTECTED] writes: > How can i know a capacity of a pg database ? > How many records my table can have ? > I saw in a message that someone have 50 000 records it's possible in a table ? > (My table have 8 string field (length 32 car)). > Thanks for your response. The capacity is much more l

Re: [PERFORM] PGSQL Capacity

2005-05-09 Thread Steinar H. Gunderson
On Mon, May 09, 2005 at 09:22:40PM +0200, [EMAIL PROTECTED] wrote: > How can i know a capacity of a pg database ? > How many records my table can have ? > I saw in a message that someone have 50 000 records it's possible in a table ? > (My table have 8 string field (length 32 car)). > Thanks for yo

Re: [PERFORM] PGSQL Capacity

2005-05-09 Thread Dave Held
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, May 09, 2005 2:23 PM > To: pgsql-performance@postgresql.org > Subject: [PERFORM] PGSQL Capacity > > How can i know a capacity of a pg database ? > How many records my table

Re: [PERFORM] PGSQL Capacity

2005-05-09 Thread John A Meinel
[EMAIL PROTECTED] wrote: Hello How can i know a capacity of a pg database ? How many records my table can have ? I saw in a message that someone have 50 000 records it's possible in a table ? (My table have 8 string field (length 32 car)). Thanks for your response. Nanou The capacity for a PG datab

[PERFORM] PGSQL Capacity

2005-05-09 Thread bouchia . nazha
Hello How can i know a capacity of a pg database ? How many records my table can have ? I saw in a message that someone have 50 000 records it's possible in a table ? (My table have 8 string field (length 32 car)). Thanks for your response. Nanou ---(end of broadcast)-