Hello great gurus of performance:
Our 'esteemed' Engr group recently informed a customer that in their testing,
upgrading to 8.2.x improved the performance of our J2EE
application approximately 20%, so of course, the customer then tasked me
with upgrading them. We dumped their db, removed
On Sat, Jun 02, 2007 at 09:13:32AM -0400, Douglas J Hunley wrote:
Our 'esteemed' Engr group recently informed a customer that in their testing,
upgrading to 8.2.x improved the performance of our J2EE
application approximately 20%, so of course, the customer then tasked me
with upgrading
Douglas J Hunley wrote:
Hello
The DB server in question does nothing else, is running CentOS 4.5, kernel
2.6.9-55.ELsmp. Hyperthreading is disabled in the BIOS and there are 2 Xeon
3.4Ghz cpus. There is 8Gb of RAM in the machine, and another 8Gb of swap.
After a very quick read of your
Douglas J Hunley [EMAIL PROTECTED] writes:
... We dumped their db, removed pgsql, installed the 8.2.4
rpms from postgresql.org, did an initdb, and the pg_restored their data. It's
been about a week now, and the customer is complaining that in their testing,
they are seeing a 30% /decrease/
Michael Fuhr wrote:
On Sat, Jun 02, 2007 at 09:13:32AM -0400, Douglas J Hunley wrote:
Our 'esteemed' Engr group recently informed a customer that in their
testing,
upgrading to 8.2.x improved the performance of our J2EE
application approximately 20%, so of course, the customer then tasked
Any luck on appending two table in PostgreSQL.
Below are two table with same schema that have different values. In this
case EmpID is unique value.
tabelA
EmpId (Int) EmpName (String)
1 Hanu
2 Alvaro
tabelB
EmpId (Int) EmpName (String)
3
There are two solutions:
You can insert all data from tableB in tableA using a simple insert
select-statement like so:
INSERT INTO tabelA SELECT EmpId, EmpName FROM tabelB;
Or you can visually combine them without actually putting the records in
a single table. That can be with a normal
Arjen van der Meijden [EMAIL PROTECTED] writes:
There are two solutions:
...
Or you can visually combine them without actually putting the records in a
single table. That can be with a normal select-union statement or with a view,
something like this:
SELECT EmpId, EmpName FROM tabelA UNION
PFC,
Thanks for doing those graphs. They've been used by Simon Heikki, and
now me, to show our main issue with PostgreSQL performance: consistency.
That is, our median response time beats MySQL and even Oracle, but our
bottom 10% does not, and is in fact intolerably bad.
If you want us to
Thanks for quick answer.
Previsoly I have exported table records into employee.csv file using COPY
command which has 36,00, records.
After that I have added few more entries in database and EmpId is
incremented.
I want put the exported data back into database with re-generating new
EmpId.
10 matches
Mail list logo