Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Yan Cheng CHEOK <yccheok(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Date: 2010-05-17 08:04:30
Message-ID: AANLkTinx7_LjldMYDuuWBvoXLVzqvKQPQCWQars8JqBL@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2010-05-17 08:35:59 Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Previous Message Catalin BOIE 2010-05-17 06:09:03 Re: PANIC: corrupted item pointer: 32766