Re: [GENERAL] VACUUM and transactions in different databases

Hi Ragnar could not duplicate this. I also cannot reproduce the hanging VACUUM FULL. The problem remains thet the dead tuples cannot be vemoved. dummy1=# vacuum full; VACUUM dummy1=# SELECT relpages, reltuples FROM pg_class WHERE relname ='dummy1'; -[ RECORD 1 ]- relpages | 997 reltupl

Re: [GENERAL] VACUUM and transactions in different databases

Hi Sorry, i was out The first try was: create database dummy1; create table dummy ... and filled with 500 records create database dummy2; create table dummy ... and filled with 500 records connecting to dummy1, opening a transaction and issued an update begin; update dummy set f1='achterbah

Re: [GENERAL] VACUUM and transactions in different databases

Hi as soon as I committed the open transaction the hangig vacuum full completed and the table was vacuumed: regards Conni ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] VACUUM and transactions in different databases

Hi Bill > I don't believe that's the reason. AFAIK, activity in one database > will never block activity in another. This way I read the documentation. > I would suspect that you haven't vacuumed this database in a long time, I created both databases one hour ago for just testing this behavio

[GENERAL] VACUUM and transactions in different databases

Hi all If I have a running transaction in database1 and try to vacuum database2 but the dead tuples in database2 cannot be removed. INFO: vacuuming "public.dummy1" INFO: "dummy1": found 0 removable, 14 nonremovable row versions in 1341 pages DETAIL: 135000 dead row versions cannot be

Re: [GENERAL] zero values in statistic views

Hi Tom > But you didn't say what the ps output showed. ps aux | grep stats postgres 24979 0.0 0.0 24416 3780 ?SNov07 0:07 postgres: stats buffer process postgres 24980 0.0 0.0 24684 4024 ?SNov07 0:10 postgres: stats collector process Regards Conni ---

Re: [GENERAL] zero values in statistic views

Tom, thanks for the quick response. stats_row_level and stats_block_level are disabled in postgresql.conf. I used the SET command to activate them. > If it's not running, look in the postmaster log right after > restarting the postmaster; there may be a message there about why > not. I canno

[GENERAL] zero values in statistic views

Hi all I would like to see what is going on in a database using the statistic views. I am superuser, stats_start_collector = on stats_row_level = on stats_block_level = on select * from pg_stat_user_tables; select * from pg_stat_user_indexes; select * from pg_statio_user_tables select * from

Re: [GENERAL] Problem creating a function - solved

Hi Tom, Joe After compiling the C-source files # gcc -fpic -c bitvg.c # gcc -shared -o bitvg.so bitvg.o the pg_restore created the function. It is Suse 9.x and PG 8.1.4 Thanks Conni ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmast

Re: [GENERAL] Problem creating a function

Hi Tom > You should try "ldd" or local equivalent on bitvg.so to check > whether all its dependencies can be found. output: ldd /home/database/pgdata/cobis/bitvg/bitvg.so statically linked Regards Conni ---(end of broadcast)--- TIP 9: In

Re: [GENERAL] Problem creating a function

Hi Joe > Try: > su postgres > cd /home/database/pgdata/cobis/bitvg Succeeds, ls -la shows all files in that directory and can open them with less. Regards Conni ---(end of broadcast)--- TIP 4: Have you searched our list archives?

[GENERAL] Problem creating a function

Hi all Trying to create a function I get the following: codex=# CREATE FUNCTION "bitvg" (integer,integer) RETURNS integer AS '/home/database/pgdata/cobis/bitvg/bitvg.so', 'bitvg' LANGUAGE 'C'; ERROR: could not load library "/home/database/pgdata/cobis/bitvg/bitvg.so": /home/database/pgdata/c

[GENERAL] Question on output of VACUUM VERBOSE

Hi all I don't understand what these two lines exactly mean. INFO: free space map: 490 relations, 13541 pages stored; 34480 total pages needed DETAIL: Allocated FSM size: 1000 relations + 2 pages = 178 kB shared memory Thanks in advance Conni ---(end of broadcast)-

[GENERAL] Merry Christmas

Hi all, Merry Christmas and best wishes for the New Year. Conni ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Problem to connect to the Windows Port

Hi Magnus Thanks. > If you meant to match the entire subnet (192.168.*.*), instead put > host minitest postgres 192.168.0.0 255.255.0.0 password Ok. I changed the line in pg_hba.conf to host all all 192.168.0.0 255.255.0.0 password then rebooted the computer and tried again: C:\>psql -h 192.

Re: [GENERAL] Problem with date calculations

Hi Stephan Thank you > d1 + dur * interval '1 month' works ;-) Regards Conni ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] Problem with date calculations

Hi alltogether I have a table with two fields, d1 timestamp and dur smallint. d1 is the starting date and dur is the duration. From this two fields I want to generate future dates for the whole table. There is no problem with queries where a number for the duration is given. test=# select d1,dur,

Re: [GENERAL] Pgsql on Windows

Hi > When you have postgresql support compiled into PHP, then PHP connects > directly using native PostgreSQL calls (libpq), no ODBC layer to deal > with. Working with Windows you normally don't compile PHP but use the Win binaries. To connect to a PostgreSQL database you must uncomment the php_pg

[GENERAL] What values does PQstatus return

Hi all What values does PQstatus return in case of CONNECTION_OK and CONNECTION_BAD? Thanks Conni ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] Warning: PostgreSQL query failed

Hi Sreedhar Try it with ... catalogid) values ('KICKIN''BACK.SDS', 13803564 , ' OpenOffice.org 5.0 Chart ... Use a second ' to escape ' instead of a backslash. Greetings Conni ---(end of broadcast)--- TIP 6: Have you searched our list archives?

[GENERAL] converting PostgreSQ- timestamp to UNIX-timestamp ?

Hi everybody To convert PostgreSQL timestmp to UNIX timestamp I use select ((today::abstime)::int4) from table ... In the documentation there is a notice that abstime shouldn't be used. Is there another way to convert? Also I tried select timetz_hash(today) from table .. and got negative valu

Re: [GENERAL] Fatal error: Call to undefined function: pg_connect()

Hi did you configure php for PostgreSQL support ./configure --with-pgsql Regards Conni ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org