From: Oleg Bartunov <oleg@sai.msu.su>
To: lucas@presserv.org
Cc: pgsql-sql@postgresql.org
Subject: Re: New record position
Date: Wed, 30 Mar 2005 18:12:37 +0400 (MSD)
Message-ID: <Pine.GSO.4.62.0503301809570.17555@ra.sai.msu.su> (raw)
In-Reply-To: <20050330105017.miuieky7u64gscgc@www.presserv.org>
References: <20050330105017.miuieky7u64gscgc@www.presserv.org>
This is a feature of relational databases, you should explicitly specify
ordering if you want persistent order.
btw, why do you bothering ?
Oleg
On Wed, 30 Mar 2005 lucas@presserv.org wrote:
> Hello,
> I am using Slackware Linux 10, Postgresql 8.0.1.
> My computer had a incorrectly power down (last week) and I have executed the
> vacuum command:
> VACCUM FULL ANALYZE VERBOSE;
> to recicle and verify my database.
> Before the power-down, all records had inserted into a table have displayed at
> LAST record. Like:
> SELECT * from tb1;
> f1 | f2
> ------|--------
> rec1 | vl1
>
> INSERT into tb1 values ('rec2','vl2');
> SELECT * from tb1;
> f1 | f2
> ------|--------
> rec1 | vl1
> rec2 | vl2
>
> But After the power-down and vacuum, the new records inserted have appeared in
> random location (FIRST, between other records, etc...). Ie:
>
> INSERT into tb1 values ('rec3','vl3');
> SELECT * from tb1;
> f1 | f2
> ------|--------
> rec1 | vl1
> rec3 | vl3 <<=====
> rec2 | vl2
>
> Why it? I can't undestand why the new record location was change. Shouldn't it
> apper at the LAST record???
> What need I do??
> Thank you.
> --------
> Lucas Vendramin
> Brazil
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
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-sql@postgresql.org
Cc: oleg@sai.msu.su, lucas@presserv.org
Subject: Re: New record position
In-Reply-To: <Pine.GSO.4.62.0503301809570.17555@ra.sai.msu.su>
* 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