Scott,
DB Schema: http://demo.moodle.org/db_schema.txt
SQL Query log: http://demo.moodle.org/querylog.txt
There are _much_ more queries than I anticipated :/
Jordan
On Mon, Feb 23, 2009 at 12:42 AM, Jordan Tomkinson jor...@moodle.com wrote:
On Mon, Feb 23, 2009 at 4:29 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
Oh yeah, what OS is this? Version and all that.
I should probably clarify that the high cpu only exists while the jmeter
tests are
On Mon, Feb 23, 2009 at 5:20 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Mon, Feb 23, 2009 at 12:42 AM, Jordan Tomkinson jor...@moodle.com
wrote:
On Mon, Feb 23, 2009 at 4:29 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
Oh yeah, what OS is this? Version and all that.
On Mon, Feb 23, 2009 at 7:55 AM, raf r...@raf.org wrote:
hi,
i've been getting nonsensical error messages all day with
postgres 8.3 on winxpsp3. i tried upgrading to 8.3.6
(enterprisedb) and fresh installs.
Please clarify what you have done. You cannot upgrade from PostgreSQL
to EnterpriseDB
We're very happy with pgpool-II for load-balancing and multi-master
usage of PostgreSQL (keep in mind to enable HA for pgpool-II itself to
avoid a SPOF, e.g. with heartbeat).
Thanks.
I am going to see which one has better documentation and try that one first.
Thanks all for the responses,
We're very happy with pgpool-II for load-balancing and multi-master
usage of PostgreSQL (keep in mind to enable HA for pgpool-II itself to
avoid a SPOF, e.g. with heartbeat).
I could not determine whether pgpool-II is suitable for what I want.
It does not seem to
Hi list,
We have a peculiar problem with a restore.
We have a database with many different schema's that all act as separate
databases.
The data is backed up from postgresql 8.1 with the following commands in cron:
28 12 * * * /usr/bin/pg_dump -a -F c --disable-triggers -f
2009/2/22 Gerd Koenig koe...@transporeon.com:
Hi Steve,
I know that EnterpriseDB offers 3 levels of certification.
Perhaps one of them suits your needs..?!?!
regards...:GERD:...
Pearson has 2 levels (gold and plate) [1]
Regards,
[1] http://www.vue.com/sra/
steve.gnuli...@gmail.com
Hi,
I just installed a program called moteview by crossbow technologies. It uses
postgreSQL 8.0.0-rc1 for its database. There is something wrong as when I
launched the program it automaticly gives me an error that the database is
not available. The postgreSQL database installation is bundled
In response to najmuddin hassan :
Hi,
I just installed a program called moteview by crossbow technologies. It uses
postgreSQL 8.0.0-rc1 for its database. There is something wrong as when I
launched the program it automaticly gives me an error that the database is not
available. The
El día 22 de febrero de 2009 17:46, Angelo Astorga
angeloasto...@gmail.com escribió:
Tenia Red Hat enterprise 3.0 con postgresql 7.4.3 y PHP 4.3.2, por necesidad
de hardware migre todo a Red Hat enterprise 5.3 con postgresql 8.1.11 y PHP
5.1.6 (default del sistema operativo), si bien puedo
Hello All:
I need guidance on how move some changes that I have made to my
production database.
On my development database I made changes to a table called DEPT. I
added a column, added
a couple of records and did some general data cleanup
What I did not do was change any of the
I've have AVG installed and I've remove it and I've turn off the windows
firewall.
When I go to PostgreSQL 8.3 Start
The command prompt window appears with text.
The PostgreSQL Database server 8.3 is starting
the dot will appear for sometime like something is running then the next msg
najmuddin hassan naji...@gmail.com writes:
I just installed a program called moteview by crossbow technologies. It uses
postgreSQL 8.0.0-rc1 for its database.
Egad. Based on that statement alone, I will tell you that crossbow is
a bunch of incompetent idiots and you should not trust their
On Mon, Feb 23, 2009 at 1:29 AM, Jordan Tomkinson jor...@moodle.com wrote:
On Mon, Feb 23, 2009 at 5:20 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Mon, Feb 23, 2009 at 12:42 AM, Jordan Tomkinson jor...@moodle.com
wrote:
On Mon, Feb 23, 2009 at 4:29 PM, Scott Marlowe
Antiguamente utiilizaba postgresql 7.4.3 donde se generaba un serverlog en
directorio .../data/serverlog, ahora con vers. 8.1.11 no encuentro el
serverlog... alguna ayuda al respecto !!!
Hi,
This is a simple function that returns a boolean ..
create or replace function check_value( newValue IN VARCHAR,
oldValue IN VARCHAR ) RETURN BOOLEAN
as
'
BEGIN
IF ( newValue != oldValue)
then return true;
else
return false;
END IF;
END;
'
Its a typo..it should be RETURNS BOOLEAN and not RETURN BOOLEAN
-Sharmila
--- On Mon, 2/23/09, SHARMILA JOTHIRAJAH sharmi...@yahoo.com wrote:
From: SHARMILA JOTHIRAJAH sharmi...@yahoo.com
Subject: Function that returns Boolean
To: General postgres mailing list pgsql-general@postgresql.org
SHARMILA JOTHIRAJAH sharmi...@yahoo.com writes:
create or replace function check_value( newValue IN VARCHAR,
oldValue IN VARCHAR ) RETURN BOOLEAN
Should be RETURNS BOOLEAN.
You might want to fix whatever client code you are using so that it
shows the error cursor, which
- SHARMILA JOTHIRAJAH sharmi...@yahoo.com wrote:
Hi,
This is a simple function that returns a boolean ..
create or replace function check_value( newValue IN VARCHAR,
oldValue IN VARCHAR ) RETURN BOOLEAN
^^ RETURNS
as
What would you do in this situation?
We are currently at PG 8.1 and are in the process of upgrading to 8.3.6. I
read on your development roadmap page that 8.4 is slated for release in Q1 of
this year, possibly on the 31st of March:
The next release of PostgreSQL is planned to be the 8.4
On Mon, Feb 23, 2009 at 9:39 AM, SHARMILA JOTHIRAJAH
sharmi...@yahoo.com wrote:
IF ( newValue != oldValue)
One good piece of advice that Tom Lane pointed out to me was:
IF ( newValue IS DISTINCT FROM oldValue )
is better due to (what may be) the unexpected results of equality
testing when
don't fix if it ain't broken ;)
no really, if the system is capable of working nearly flawlessly till 8.4 is
baked, then it is sound to wait till then, especially when upgrading to a
newer version is a *painful* as in time consuming task. i am assuming
downgrading (just incase things don't
On Mon, Feb 23, 2009 at 09:39:01AM -0800, SHARMILA JOTHIRAJAH wrote:
Hi,
This is a simple function that returns a boolean ..
This should be an SQL function, as it doesn't do anything you need (or
would even find convenient) for a more procedural language to do:
CREATE OR REPLACE FUNCTION
Keaton Adams kad...@mxlogic.com writes:
We are currently at PG 8.1 and are in the process of upgrading to 8.3.6. I
read on your development roadmap page that 8.4 is slated for release in Q1 of
this year, possibly on the 31st of March:
The next release of PostgreSQL is planned to be the 8.4
najmuddin hassan naji...@gmail.com schrieb:
I've have AVG installed and I've remove it and I've turn off the windows
firewall.
Maybe your AVG is the problem... don't know, i'm not familiar with
windoze and so on...
When I go to PostgreSQL 8.3 Start
The command prompt window appears
OK, well just to make sure I have the latest and greatest information on the
proposed in-place upgrade process.
If we go from 8.1 to 8.3.6 now using dump/restore we will need to do another
dump/restore to get to 8.4, correct?
And from 8.4 on we will be able to do in-place upgrades?
The idea of
Tom Lane t...@sss.pgh.pa.us wrote:
Keaton Adams kad...@mxlogic.com writes:
We are currently at PG 8.1 and are in the process of upgrading to 8.3.6. I
read on your development roadmap page that 8.4 is slated for release in Q1
of this year, possibly on the 31st of March:
The next
is it looking like the simple replication will make it into 8.4?
if so, are there any docs or notes I could peruse on how this will
work? what it will use to ship the WAL logs, etc ? I've poked around
the -hacker mail list archives and not found too much on it.
--
Sent via
Hi,
Scott Marlowe wrote:
Oh, what is an LMS?
A Learning Management System, not to be confused with a CMS, which might
also stand for a Course Management System ;-)
Regards
Markus Wanner
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
If you could publish a brief howto on this I would be most grateful. I bet
many others would too.
On Mon, Feb 23, 2009 at 2:56 PM, Bryan Murphy bmurphy1...@gmail.com wrote:
On Sun, Feb 22, 2009 at 7:30 PM, Tim Uckun timuc...@gmail.com wrote:
1. It's OK if we lose a few seconds (or even
2009/2/23 Marek Lewczuk ma...@lewczuk.com:
Hello,
I can't find SQL definition for OVERLAPS operator so I don't know
whether following expression's result (false) is appropriate
behaviour:
select ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps
('2007-12-01'::TimeStamp,
On Mon, Feb 23, 2009 at 1:03 PM, Keaton Adams kad...@mxlogic.com wrote:
OK, well just to make sure I have the latest and greatest information on the
proposed in-place upgrade process.
If we go from 8.1 to 8.3.6 now using dump/restore we will need to do another
dump/restore to get to 8.4,
Hi,
I have a view in which I want to randomly assign values if certain
conditions hold. I was getting surprising results. Here is a (very)
simplified version of the view, which seems to indicate the problem:
CREATE OR REPLACE VIEW test_view AS
SELECT
CASE
WHEN random()
Dave Page wrote:
On Mon, Feb 23, 2009 at 7:55 AM, raf r...@raf.org wrote:
hi,
i've been getting nonsensical error messages all day with
postgres 8.3 on winxpsp3. i tried upgrading to 8.3.6
(enterprisedb) and fresh installs.
Please clarify what you have done. You cannot upgrade from
On Feb 23, 2009, at 2:09 PM, Jessi Berkelhammer wrote:
Hi,
I have a view in which I want to randomly assign values if certain
conditions hold. I was getting surprising results. Here is a (very)
simplified version of the view, which seems to indicate the problem:
CREATE OR REPLACE VIEW
Jessi,
should the function not look like this???
CREATE OR REPLACE VIEW test_view AS
SELECT
CASE
WHEN random() .3 THEN '1'
WHEN random() .5 THEN '2'
ELSE '3'
END AS test_value
FROM client;
On Feb 23, 2009, at 5:09 PM,
ries van Twisk wrote:
Jessi,
should the function not look like this???
CREATE OR REPLACE VIEW test_view AS
SELECT
CASE
WHEN random() .3 THEN '1'
WHEN random() .5 THEN '2'
ELSE '3'
END AS test_value
FROM client;
actually, I'd think that should be
Or perhaps:
CREATE OR REPLACE VIEW test_view AS
SELECT (random()*3)::int as test_value;
At least in this case, that should give the same result.
in this case 1/3 should be 1, 1/3 = 2 1/3=3
in your case 1/3 = 1, 1/2 the remainder (1/2 * 2/3 = 1/3) = 2, remaining 1/3 = 3
Although I'm guessing
John R Pierce pie...@hogranch.com writes:
ries van Twisk wrote:
should the function not look like this???
CREATE OR REPLACE VIEW test_view AS
SELECT
CASE
WHEN random() .3 THEN '1'
WHEN random() .5 THEN '2'
ELSE '3'
END AS test_value
FROM client;
actually, I'd think that
Steve Atkins wrote:
On Feb 23, 2009, at 2:09 PM, Jessi Berkelhammer wrote:
Hi,
I have a view in which I want to randomly assign values if certain
conditions hold. I was getting surprising results. Here is a (very)
simplified version of the view, which seems to indicate the problem:
On Tue, Feb 24, 2009 at 12:35 AM, Scott Marlowe scott.marl...@gmail.comwrote:
On Mon, Feb 23, 2009 at 1:29 AM, Jordan Tomkinson jor...@moodle.com
wrote:
As per the spreadsheet
(http://spreadsheets.google.com/pub?key=pu_k0R6vNvOVP26TRZdtdYw) CPU
usage
is around 50% and starts climbing
Hi there,
I'm sorry for a stupid question but I'm really stuck.
A query:
SELECT COUNT(*) FROM lingq_card WHERE lingq_card.context_id = ...;
An hour ago it took 8 seconds, one minute ago the same query took just only
7 milliseconds.
Any ideas why the execution time varies so wildly?
Explain
On Mon, Feb 23, 2009 at 6:44 PM, Mike Ivanov m...@thelinguist.com wrote:
Hi there,
I'm sorry for a stupid question but I'm really stuck.
A query:
SELECT COUNT(*) FROM lingq_card WHERE lingq_card.context_id = ...;
An hour ago it took 8 seconds, one minute ago the same query took just only
On Mon, 23 Feb 2009, Scott Marlowe wrote:
well that's pretty normal as the indexes grow large enough to not fit in
cache, then not fit in memory, etc...
Right, the useful thing to do in this case is to take a look at how big
all the relations (tables, indexes) involved are at each of the
Dot Yet wrote:
don't fix if it ain't broken ;)
no really, if the system is capable of working nearly flawlessly till 8.4 is
baked, then it is sound to wait till then, especially when upgrading to a
newer version is a *painful* as in time consuming task. i am assuming
downgrading (just
On Mon, Feb 23, 2009 at 05:44:05PM -0800, Mike Ivanov wrote:
An hour ago it took 8 seconds, one minute ago the same query took just only
7 milliseconds.
Any ideas why the execution time varies so wildly?
Explain Analyze gives:
Aggregate (cost=2000.08..2000.09 rows=1 width=0) (actual
Hi Ho!
The plain query runs for about 8.28 minutes.
But, when the same query is put inside a function as follows:
--- 8 ---
create or replace function get_outgoing_transactions(
area char(3),
start_at timestamp with time zone,
end_at timestamp with time zone) returns setof record as
Hello all.
My javascript connects with postgres using php.
php responds with XML for my select request.
I wonder is there any way to access to postgres directly?
I mean like this.
new PGSQL.Request (
'postgres.server.com'
,{
,port: 5432
,sql : 'select
On Mon, Feb 23, 2009 at 5:16 PM, raf r...@raf.org wrote:
this looks like an attempt to understand the monty hall problem.
http://en.wikipedia.org/wiki/Monty_Hall_problem
except that there's no goat :(
And what database management system can be complete without a goat? :)
--
Sent via
On Tue, Feb 24, 2009 at 11:42 AM, Greg Smith gsm...@gregsmith.com wrote:
On Mon, 23 Feb 2009, Scott Marlowe wrote:
well that's pretty normal as the indexes grow large enough to not fit in
cache, then not fit in memory, etc...
Right, the useful thing to do in this case is to take a look at
野村 wrote:
Hello all.
My javascript connects with postgres using php.
php responds with XML for my select request.
I wonder is there any way to access to postgres directly?
Nothing stops you passing SQL snippets from JavaScript into your PHP
code, which then dispatches then to the server and
野村 wrote:
Hello all.
My javascript connects with postgres using php.
php responds with XML for my select request.
I wonder is there any way to access to postgres directly?
if you mean client side Javascript running on the end users web browser,
no, it should NOT be allowed to connect to
On Mon, Feb 23, 2009 at 11:54 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
野村 wrote:
Hello all.
My javascript connects with postgres using php.
php responds with XML for my select request.
I wonder is there any way to access to postgres directly?
Nothing stops you passing SQL
On Tue, Feb 24, 2009 at 11:42 AM, Greg Smith gsm...@gregsmith.com wrote:
Right, the useful thing to do in this case is to take a look at how big all
the relations (tables, indexes) involved are at each of the steps in the
process. The script at http://wiki.postgresql.org/wiki/Disk_Usage will
On Mon, Feb 23, 2009 at 6:54 PM, Sam Mason s...@samason.me.uk wrote:
Depending on where these are on disk and how fast your disks are this
could take up to 30 seconds.
This does not sound very inspiring :-)
Would throwing more hardware (memory, faster CPU) at the server improve the
situation?
56 matches
Mail list logo