[GENERAL] vacuum error

res 7.4.2 What does that mean? Can it be fixed? How? TIA Ulrich -- Ulrich Wisser / System Developer RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769 _

[GENERAL] vacuum error "left link changed unexpectedly"

d: ERROR: left link changed unexpectedly Any ideas what is wrong? Or how to fix it? Ulrich -- Ulrich Wisser / System Developer RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden Direct (+46)86789755 || Cell (+46)704467893

Re: [GENERAL] vacuum error "left link changed unexpectedly"

ekend. Ulrich Ulrich Wisser <[EMAIL PROTECTED]> writes: vacuumdb: vacuuming of database "CLIX2" failed: ERROR: left link changed unexpectedly Hm, is this repeatable? When I wrote the code I thought it was a can't-happen case, which is why the error message is so terse

Re: [GENERAL] vacuum error "left link changed unexpectedly"

U 2.46s/6.06u sec elapsed 186.45 sec. ERROR: left link changed unexpectedly To me this looks as the index userclick_i01 is corrupted. I can not recompile PG, this is a production system. Is there anything else I could do to find out which file is affected? Ulrich Lane wrote: Ulrich Wisser &

Re: [GENERAL] vacuum error "left link changed unexpectedly"

rclick_i01 userclick_i02 userclick_i03 userclick_i04 userclick_i05 userclick_i06 userclick_i07 (7 rows) How do I proceed? How can I tell which files are involved? Regards, Ulrich -- Ulrich Wisser / System Developer RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden Direct (+4

[GENERAL] Fedora postgresql not starting

Hi, I installed the latest postgresql packages on my Fedora Core 3 box. PG will not start, even initdb on a new directory fails. Any ideas what could be wrong? Any ideas how to debug? Thanks Ulrich ---(end of broadcast)--- TIP 6: Have you searched o

[GENERAL] Can't start PostgreSQL on Fedora Core3

Hi, it seems selinix doesn't like postgres. Can I uninstall selinux from fedora savely? OR is there any way to make them both work together? Here is my error message: Mar 9 14:20:33 localhost kernel: audit(1110374433.961:0): avc: denied { read } for pid=9251 exe=/usr/bin/postgres name=PG_VER

Re: [GENERAL] Can't start PostgreSQL on Fedora Core3

- Hash: SHA1 Hi, Are you using the latest selinux_policy_targeted package? I mean, is your system up2date? Regards, On Wed, 9 Mar 2005, Ulrich Wisser wrote: Hi, it seems selinix doesn't like postgres. Can I uninstall selinux from fedora savely? OR is there any way to make them both work tog

Re: [GENERAL] Can't start PostgreSQL on Fedora Core3

Hi Tom, sudo /sbin/restorecon -R /var/lib/pgsql worked like a charm! Thank you very much! Ulrich -- Ulrich Wisser RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769

Re: [GENERAL] Can't start PostgreSQL on Fedora Core3

ecurity in general). I just went with the default install and here I am. Ulrich -- Ulrich Wisser RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769 ___

[GENERAL] type conversion date <-> timestamp

Hi, today I started to wonder about type conversion. I want to get all rows of a table dated between two given dates. Until now I use select * from mytable where to_date('20040115', 'MMDD') <= timestamp and timestamp <= to_date('20040215', MMDD') Does that query include the 15th January a

[GENERAL] How to know which queries are to be optimised?

Hello, my web application grows slower and slower over time. After some profiling I came to the conclusion that my SQL queries are the biggest time spenders (25 seconds). Obviously I need to optimise my queries and maybe introduce some new indexes. The problem is, that my application uses dynam

[GENERAL] REINDEX problem

Hello, the maintainance chapter in the docs gave me the impression that a reindex of some tables would be a good idea. Last night I took the database down, started up in single user mode and tried to reindex. The reindex of tables did work fine, but a reindex of the database did not. Please see

[GENERAL] heap errors - should I be worried?

Hello, yesterday I took our database down and started in single user mode. After reindexing of three tables I thought a vacuum would be a good idea. backend> VACUUM FULL VERBOSE ANALYZE WARNING: Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES (163) IS NOT THE SAME AS HEAP' (345).

Re: [GENERAL] heap errors - should I be worried?

Hi Tom, WARNING: Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES (163) IS NOT THE SAME AS HEAP' (345). Recreate the index. Should these errors worry me? Yeah, they should. A REINDEX will probably get you out of the immediate problem, but the more interesting question is how

[GENERAL] insert waiting

Hi, after some more debugging I found that my application does on average 3 inserts per second. Which is not very fast, but fast enough for now. But now and then the whole insert proces will be stalled and drop to 0.1 inserts per second. In the output of "ps aux Op" I see postgres in the state

Re: [GENERAL] Problems using count() with a join - trying to format

Hi Igor, wouldn't select g_name,count(*),sum(u_act) from g1 join users using(g_id) group by g_name do the job? /Ulrich Result can be obtained by: SELECT g1.g_name, (select count(*) from users u1 where g1.g_id = u1.g_id) as users_count, (select count(*) from users u2 where g1.g_id = u2.g_id and u_ac

Re: [GENERAL] insert waiting

are inserting two child records that reference the same parent (at the same time) one insert will block. John Sidney-Woollett Ulrich Wisser wrote: Hi, after some more debugging I found that my application does on average 3 inserts per second. Which is not very fast, but fast enough for now. But

[GENERAL] Adding missing FROM-clause entry for table "customer"

Hi, what does that line from my logfile mean? Adding missing FROM-clause entry for table "customer" Would pg change my SQL queries on the fly? TIA /Ulrich ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if y

[GENERAL] pg_dump in stand alone backend

Hi, I would like to stop the postmaster every night and run vacuum pg_dump reindex in the stand alone backend. Vacuum and reindex seem to be quite easy, as I can setup a small script with both commands. But what about pg_dump. That seems "somewhat" more complex. TIA Ulrich --

Re: [GENERAL] pg_dump in stand alone backend

Daniel Martini wrote: Hi, Citing Ulrich Wisser <[EMAIL PROTECTED]>: I would like to stop the postmaster every night and run vacuum pg_dump reindex in the stand alone backend. Vacuum and reindex seem to be quite easy, as I can setup a small script with both commands. But what about pg_dump

[GENERAL] stone-age maintenance procedures ;-)

Hi, lately I've been acused of "stone-age maintenance procedures". Hopefully I will find some help to develop from stone-age to roman empire. ;-) To optimize the performance and to minimize the maintainance needs I would like to ask you guys about some values in my postgresql.conf. select versi

Re: [GENERAL] Hebrew support -- please help !

Hi Elie, Now I got the right information from the DB in Hebrew and french. Still can't save value in Hebrew from client (browser) to server and in french if I save 'été' in a column varchar(3) I got a range over exception. you are working through the web. That makes the whole thing a lot more com

[GENERAL] Foreign key locks

Hi, yes, I have been hit by the, now also known to me, foreign key locking "feature". And yes I did read that I should use "defer" to solve the problem. Question is: Do I have to recreate my schema with all foreign keys set to "initially defered deferable"? Ulrich ---(e