Great, creating new tablespace for indexes worked! Now the question is
whether existing tables/index can be moved to the new tablespace using an
alter command or the only way possible is to drop and recreate them?
Azad
On 9/14/07, Jean-David Beyer <[EMAIL PROTECTED]> wrote:
>
> Hars
ROTECTED]> wrote:
>
> On Fri, 2007-09-14 at 08:20 +0530, Harsh Azad wrote:
> > Hi,
> >
> > Where are the database index files located in the $PGDATA directory? I
> > was thinking on soft linking them to another physical hard disk array.
>
> you have to search thro
Hi,
Where are the database index files located in the $PGDATA directory? I was
thinking on soft linking them to another physical hard disk array.
Thanks,
Azad
not nessasarily. direct attached doesn't mean in the same chassis,
> external drive shelves attached via SCSI are still DAS
>
> you can even have DAS attached to a pair of machines, with the second box
> configured to mount the drives only if the first one dies.
>
> David Lang
>
> ---(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
>
--
Harsh Azad
===
[EMAIL PROTECTED]
Hi,
How about the Dell Perc 5/i card, 512MB battery backed cache or IBM
ServeRAID-8k Adapter?
I hope I am sending relevant information here, I am not too well versed with
RAID controllers.
Regards,
Harsh
On 9/6/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>
> On 9/6/07, Harsh
<[EMAIL PROTECTED]> wrote:
>
> On 9/6/07, Harsh Azad <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > We are currently running our DB on a DualCore, Dual Proc 3.Ghz Xeon, 8GB
> > RAM, 4x SAS 146 GB 15K RPM on RAID 5.
> >
> > The current data size is
On 9/6/07, Mark Lewis <[EMAIL PROTECTED]> wrote:
>
> On Thu, 2007-09-06 at 18:05 +0530, Harsh Azad wrote:
> > Hi,
> >
> > We are currently running our DB on a DualCore, Dual Proc 3.Ghz Xeon,
> > 8GB RAM, 4x SAS 146 GB 15K RPM on RAID 5.
> >
> >
Hi,
We are currently running our DB on a DualCore, Dual Proc 3.Ghz Xeon, 8GB
RAM, 4x SAS 146 GB 15K RPM on RAID 5.
The current data size is about 50GB, but we want to purchase the hardware to
scale to about 1TB as we think our business will need to support that much
soon.
- Currently we have a 80
