On Fri, 29 Mar 2002, Nicholay P. Chuprynin wrote:
>
> Hello, All!
> Resently I had to create and manage the (relatively) large table.
> In the mean time it's about 8 million rows, and surely will grow above
> this size.
> The problem is that queries takes absolutely not acceptable time.
> Databa
Thanks a lot!
Although I wasn't clear enough in my questions I got pretty informative
answers.
Now I see, that I need faster hardware or to rethink the whole problem,
which is somewhat cheaper and much more interesting.
Thanks again for your answers.
Nicholay
---(end
Fred Moyer wrote:
> Your UDMA 33 bus will limit disk reads to 33 Mbytes/sec so there is your
> first bottleneck. Get a 66 mhz PCI ide adapter (Promise is cheap) and that
> will increase your disk speed dramatically.
> Also you won't be able to do much with 128 Mb of ram, put in as much as you
>
x27;t forget to (man) hdparm to maximize your I/O.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Peter Eisentraut
Sent: Friday, March 29, 2002 10:43 AM
To: Nicholay P. Chuprynin
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Postgres & large tables on average
Nicholay P. Chuprynin writes:
> Resently I had to create and manage the (relatively) large table.
> In the mean time it's about 8 million rows, and surely will grow above
> this size.
> The problem is that queries takes absolutely not acceptable time.
> Database located on average Celeron 400 mac
Hello, All!
Resently I had to create and manage the (relatively) large table.
In the mean time it's about 8 million rows, and surely will grow above
this size.
The problem is that queries takes absolutely not acceptable time.
Database located on average Celeron 400 machine with 128 Mb of RAM and
