Well, we're not running PGSQL on a Netapp over NFS, but a DB2 Database.
But nevertheless, it runs quite well. NFS is not a bad choice for your
database, the big memory buffer that allocates the raid6 blocks makes it
all very quick, like you're working directly on a 1+ TB ramdisk.
One important thi
ERStudio
Toad Data Modeller
And you might try searching sourceforge or freshmeat.
sathiya psql wrote:
> Is there any tool to draw ER diagram from SQL schema file...
>
>
> no other groups are replying.
--
Easyflex diensten b.v.
Acaciastraat 16
4921 MA MADE
T: 0162 - 690410
F: 0162 - 69041
Apart from the disks, you might also investigate using Opterons instead
of Xeons. there appears to be some significant dent in performance
between Opteron and Xeon. Xeons appear to spend more time in passing
around ownership of memory cache lines in case of a spinlock.
It's not yet clear whether or
Ketema wrote:
> RAM? The more the merrier right? Understanding shmmax and the pg
> config file parameters for shared mem has to be adjusted to use it.
> Disks? standard Raid rules right? 1 for safety 5 for best mix of
> performance and safety?
> Any preference of SCSI over SATA? What about us