Re: Serious Crash last Friday

well, I don't work with transactions at all...

and I can't see no dupes...

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

----- Original Message -----
From: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Sent: Tuesday, June 18, 2002 1:25 AM
Subject: Re: [GENERAL] Serious Crash last Friday

> On Mon, Jun 17, 2002 at 05:28:23PM +0200, Henrik Steffen wrote:
> > yes, I was doing it on a living database... not good?
> >
> > I was not using -a
>
> It doesn't really matter if you're doing it on a live database, it just
> means that it won't see stuff that is in WAL that has not been committed
to
> the main storage.
>
> If you're not using -a then something else is going on. Do you have many
> uncomitted transactions? The program is not particularly intelligent about
> which rows are currently active, so you will probably see some duplicates.
> Look at the oids shown on the right of each tuple. Also, I've just
uploaded
> a new version which deals with dates and times much better.
>
> --
> Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> > There are 10 kinds of people in the world, those that can do binary
> > arithmetic and those that can't.