| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: No flamefest please, MySQL vs. PostgreSQL AGAIN |
| Date: | 2003-05-14 17:48:59 |
| Message-ID: | 20030514174859.GS20729@libertyrms.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, May 13, 2003 at 12:32:14PM -0700, Michael A Nachbaur wrote:
>
> I tried rserv with a database that has over 1000 inserts per minute, and it
> would just sit there for days at the "Preparing snapshot" (on a
> Dual-Xeon/2GHz). I hadn't tried indexing the id column though.
You not only need an index on it; you need a unique index on it. (If
you have duplicates, replication breaks.)
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ericson Smith | 2003-05-14 17:57:06 | Trying to profile a function, but weird stuff happens |
| Previous Message | Andrew Sullivan | 2003-05-14 17:46:06 | Re: database running slow |