pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Craig James <craig_james@emolecules.com>
To: pgsql-performance@postgresql.org
Subject: Re: Thousands of tables versus on table?
Date: Wed, 06 Jun 2007 10:32:13 -0700
Message-ID: <4666EF9D.90500@emolecules.com> (raw)
In-Reply-To: <4666E5A0.40604@g2switchworks.com>
References: <C289C6B1.A63%tandrews@soliantconsulting.com>
	<1180980943.31471.322.camel@archimedes>
	<46645DD9.7030805@soliantconsulting.com>
	<877iqjmro5.fsf@oxford.xeocode.com>
	<46647427.4030103@g2switchworks.com>
	<Pine.LNX.4.64.0706041631490.11737@asgard.lang.hm>
	<466593E5.1010904@g2switchworks.com>
	<87sl96z0wf.fsf@oxford.xeocode.com>
	<Pine.LNX.4.64.0706051325500.24361@asgard.lang.hm>
	<10525.1181080765@sss.pgh.pa.us>
	<Pine.LNX.4.64.0706051507120.24361@asgard.lang.hm>
	<4666DF99.3010809@emolecules.com>
	<4666E5A0.40604@g2switchworks.com>

Scott Marlowe wrote:
> OTOH, there are some things, like importing data, which are MUCH faster 
> in pgsql than in the big database.

An excellent point, I forgot about this. The COPY command is the best thing since the invention of a shirt pocket.  We have a database-per-customer design, and one of the mosterous advantages of Postgres is that we can easily do backups.  A pg_dump, then scp to a backup server, and in just a minute or two we have a full backup.  For recovery, pg_restore is equally fast and amazing.  Last time I checked, Oracle didn't have anything close to this.

Craig





view thread (36+ messages)  latest in thread

Message-ID: <4666EF9D.90500@emolecules.com>
Permalink:  ../4666EF9D.90500@emolecules.com/
Also on:    postgresql.org/message-id/4666EF9D.90500@emolecules.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: craig_james@emolecules.com
  Subject: Re: Thousands of tables versus on table?
  In-Reply-To: <4666EF9D.90500@emolecules.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox