Hello !
We had a database server on Mysql and we move to postgres last month.
But there is problems that i don't understand !
When i runthe "top" command the load average is very high :
'load average: 3.23' or some times higher than that.
And yestaerday i look to a 'top' and i found something
On Mon, 20 Nov 2000, Mickaël Jouanne wrote:
We had a database server on Mysql and we move to postgres last month.
Not enough. You need to specify the exact version, and also the version of
your operating system. Let's assume Linux.
'load average: 3.23' or some times higher than that.
Who is
Hi Bryan,
Try this:
select * from t where date_part('days', 'now'::timestamp - s) = ?;
Subtracting two timestamps in this way returns an 'interval', which
(unless you use the 'age' function) doesn't figure out the months and
the years - so 3 months would be rendered as "92 00:00"
Also, note
Thanks Tom for your emails and persistence to help me going. I'm eager to
see what this database can do for my business now.
:)
Jason
Off of Slashdot:
http://www.phpbuilder.com/columns/tim20001112.php3
is an article that is quite favorable to PostgreSQL, about
PostgreSQL vs. MySQL on Sourceforge's database. Across-the-board
positive.
--titus
Speaking of MySQL, has anyone looked at www.mysql.org recently?
They have a big news article:
MySQL wins Linux Journal Readers Choice Award again!
For the third Year in a row MySQL won the Readers Choice Award in Linux
Journal. Considering that MySQL earlier this fall won the Linux Magazine
Hi everybody!
Is this a bug?:
When I'm executing this (see below) query I have unexpected backend
closing. When I will remove last line with
"AND user_database.status_id = 'A'" -
- it's working OK.
But there are not a lot of conditions!
Do anybody know about this problem? If
Hi everybody!
Is this a bug?:
When I'm executing this (see below) query I have unexpected backend
closing. When I will remove last line with
"AND user_database.status_id = 'A'" -
- it's working OK.
But there are not a lot of conditions!
Do anybody know about this problem? If
Hi,
I read several mails here regarding to 7.0.3, but I can find 7.0.2 from
www.postgresql.org. Can anyone please tell me where I can get 7.0.3?
Thanx
--
Limin Liu
Hi,
In june, I had to migrate a web site using paradox tables on a winNT to
a Linux box. I had chosen first postgresql 7.0 for its solid-based
features.
But unfortunately, when I started to migrate my tables, a problem raised
: the implementation of blobs in Postgre. My tables stored lots of
The first and last notice are mine from stored procedures.
But what about second and third noticies. How can I debug where the error
occur???
What such error "Socket command type N unknown" is stand for???
Nov 14 17:07:18 empire logger: NOTICE: cost=0.0829333, interval=00:10:22
Nov 14 17:07:18
Hello.
I have a problem with a script creating database. I don't know where can be
error. Can you help me, please.
* Error:
Relation 'empleado' does not exist
* script:
-8--
create database multi;
\connect multi
I don't know how I did but ...
I loose my history in psql (I can't use the arrows anymore...)
Can somebody tell me how to recovert them ?
Do I have to recompile postgres or re ... initdb ?
Thanks for help
A beginner ...
I've never used PGSQL in a production environment, so forgive me if I'm
missing some of the common nuances assosciated with PGSQL. I have
burrowed through the dox, but havn't found anything which goes into the
detail I need.
I was trying to import a database into PGSQL, I have a file which
At 11:22 AM 11/13/00 -0500, Robert D. Nelson wrote:
Still...Regardless of what database they're running, either their
abstraction layer is shit or their queries really need optimized. Is that
perhaps why, even at 5 clients, the page views he shows never went
significantly above 10/sec?
They
At 11:38 PM 11/12/00 -0500, Michael Fork wrote:
Thought this may be of interest to some...
http://www.phpbuilder.com/columns/tim20001112.php3
I just submitted it to slashdot, what the heck :)
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
At 09:27 AM 11/15/00 -0800, Tom Samplonius wrote:
AOLServer isn't the only system that can pool database connections, so
can servlets/JSP, ColdFusion, ASP, etc. No doubt AOLServer would be more
widely accepted if it used something other than TCL.
There are two separate modules that support
This's great. I have tested Postgres and MySQL with the benchmark
shipped with mysql and (of course) MySQL out perform Postgres.
I wonder does anyone know where can we download the ANSI SQLbenchmark
(AN3AP) suite? I'd like to run this benchmark test myself, since
this is the only benchmark I
18 matches
Mail list logo