Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Sun, 16 Nov 2003, Joel Jacobson wrote:
>> oid | xmin| xmax| userid | balance | reservedbalance |
>> modificationdate
>> -+---+---+-+--+-+--
>> 2080463 | 248152344 |
Joel Jacobson wrote:
No, I have never run REINDEX on any table.
However, I have done many VACUUM FULL ANALYZE on the complete database.
Yes, once I had this also due to a vacuum:
http://archives.postgresql.org/pgsql-admin/2003-04/msg00407.php
I decreased the vacuum frequency :-(
Regards
Ga
On Sun, 16 Nov 2003, Joel Jacobson wrote:
> Hi Stephan,
>
> Thanks for a quick reply.
>
> pbs=# SELECT oid,xmin,xmax,* FROM UserBalances WHERE UserID = 1002024;
>oid | xmin| xmax| userid | balance | reservedbalance |
> modificationdate
> -+---+---+-
No, I have never run REINDEX on any table.
However, I have done many VACUUM FULL ANALYZE on the complete database.
Citerar Gaetano Mendola <[EMAIL PROTECTED]>:
> This happen a few time to me too and I solved not running anymore
> each night a REINDEX on the table. I posted this problem in the
> p
Joel Jacobson wrote:
Hi Stephan,
Thanks for a quick reply.
pbs=# SELECT oid,xmin,xmax,* FROM UserBalances WHERE UserID = 1002024;
oid | xmin| xmax| userid | balance | reservedbalance |
modificationdate
-+---+---+-+--+-+---
Hi Stephan,
Thanks for a quick reply.
pbs=# SELECT oid,xmin,xmax,* FROM UserBalances WHERE UserID = 1002024;
oid | xmin| xmax| userid | balance | reservedbalance |
modificationdate
-+---+---+-+--+-+--
2080
On Sun, 16 Nov 2003, Joel Jacobson wrote:
> Please enter a FULL description of your problem:
>
> I have simple table with a primary key.
> Somehow two records with the SAME primary key has managed to get into the
> table.
> This should as far as I k
Your name : Joel Jacobson
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : Intel(R) Pentium(R) III
Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.21
PostgreSQL versio
