Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Date
Msg-id AANLkTinx7_LjldMYDuuWBvoXLVzqvKQPQCWQars8JqBL@mail.gmail.com
Whole thread Raw
In response to Why Performance of SQL Query is *much* Slower in GUI PgAdmin  (Yan Cheng CHEOK <yccheok@yahoo.com>)
List pgsql-general
Here's a more useful test.

write a simple script that creates a 100 or so dbs.  Run it against
each database, and while it's running, pull the power plug.  Plug back
in, see if your database comes back up uncorrupted.

If pgsql is on proper db hardware (i.e. it obeys fsync, has battery
backed cache on a RAID controller, etc) it should come up no problems.
 Since the system catalogs are stored in the same transactional engine
/ table type as everything else.  On MySQL, maybe, maybe not, as the
system catalogs are always stored in MyISAM tables even if you dont'
use them for anything else.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Next
From: Thomas Kellerer
Date:
Subject: Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin