I figure this subject belongs on the performance mailing list because it is
about partitioning, which is a performance issue.
I'm working on partitioning some of the tables used by an application that
uses OpenJPA. It turns out that OpenJPA is sensitive to the numbers
returned when you do an inse
I have the same problem in PG 8.2
To resolve this issue I had to create a new table with the same
structure than the partitioned table with a trigger for insert and
update. All the operations the application have to do are directed to
this new table.
When a new record is inserted in the new table
Inheritted a number of servers and I am starting to look into the hardware.
So far what I know from a few of the servers
Redhat servers.
15K rpm disks, 12GB to 32GB of RAM.
Adaptec 2120 SCSI controller (64MB of cache).
The servers have mostly have 12 drives in RAID 10.
We are going to redo one m
On Mon, 12 May 2008 22:04:03 -0400
Francisco Reyes <[EMAIL PROTECTED]> wrote:
> Inheritted a number of servers and I am starting to look into the
> hardware.
>
> So far what I know from a few of the servers
> Redhat servers.
> 15K rpm disks, 12GB to 32GB of RAM.
> Adaptec 2120 SCSI controller (64
Joshua D. Drake writes:
Most likely you have a scsi onboard as well I am guessing.
Will check.
shouldn't bother with the 2120. My tests show it is a horrible
controller for random writes.
Thanks for the feedback..
Comparing software raid on an LSI onboard for an IBM 345 versus a 2120s
u
If I can't find an answer in the next day or so I'll crack open OpenJPA and
disable that check. Its a very simple, if ugly, hack.
--Nik
On 5/12/08, Neil Peter Braggio <[EMAIL PROTECTED]> wrote:
>
> I have the same problem in PG 8.2
>
> To resolve this issue I had to create a new table with the
Joshua,
did you try to run the 345 on an IBM ServeRAID 6i?
I have one in mine, but I never actually ran any speed test.
Do you have any benchmarks that I could run and compare?
best regards,
chris
--
chris ruprecht
database grunt and bit pusher extraordinaíre
On May 12, 2008, at 22:11, Josh
Chris Ruprecht wrote:
Joshua,
did you try to run the 345 on an IBM ServeRAID 6i?
No the only controllers I had at the time were the 2120 and the LSI on
board that is limited to RAID 1. I put the drives on the LSI in JBOD and
used Linux software raid.
The key identifier for me was using a s
Francisco Reyes wrote:
Joshua D. Drake writes:
Any PCI controller you have had good experience with?
I don't have any PCI test data.
How any other PCI-X/PCI-e controller that you have had good results?
http://www.commandprompt.com/blogs/joshua_drake/2008/04/is_that_performance_i_smell_ext
On Mon, 12 May 2008, Francisco Reyes wrote:
We are going to redo one machine to compare RAID 10 vs RAID 50. Mostly to
see if the perfomance is close, the space gain may be usefull.
Good luck with that, you'll need it.
Will it pay to go to a controller with higher memory for existing
machine
Hi,
We want to migrate from postgres 8.1.3 to postgres 8.3.1.
Can anybody list out the installation steps to be followed for migration.
Do we require to take care of something specially.
Thanks in advance
~ Gauri
> We want to migrate from postgres 8.1.3 to postgres 8.3.1.
> Can anybody list out the installation steps to be followed for migration.
> Do we require to take care of something specially.
Perform a pg_dump, do a restore and validate your sql-queries on a test-server.
--
regards
Claus
When leni
12 matches
Mail list logo
