[GENERAL] how to read all physical rows (visible or not) from a heap

I recall once there is a GUC allowing us - basically force a SnapshotAny - what's current trick now? I need this only for debugging reading heap pages. Thanks, Qingqing -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] What constitutes reproducible numbers from pgbench?

On Tue, Apr 21, 2015 at 7:21 AM, holger.friedrich-fa-triva...@it.nrw.de wrote: Hello list, Exactly what constitutes „reproducible“ values from pgbench? I keep getting a range between 340 tps and 440 tps or something like that using the same command line on the same machine. Is that

Re: [GENERAL] Waiting on ExclusiveLock on extension

On Fri, Apr 17, 2015 at 1:14 AM, Andres Freund and...@anarazel.de wrote: Hm. I'm not aware of related changes in 9.4? 9.5 should be a bit better, but I don't think 9.4 will make much of a difference. You are right. I mis-read the check-in log. I don't really agree that that's the most

Re: [GENERAL] fillfactor and cluster table vs ZFS copy-on-write

On Thu, Apr 16, 2015 at 5:09 AM, Geoff Speicher gspeic...@umtechx.com wrote: Therefore one might posit that PostgreSQL should be configured to use 100% fillfactor and avoid clustering on ZFS. Can anyone comment on this? Even with COW, I can see fillfactor 100% still have its virtues. For

Re: [GENERAL] Waiting on ExclusiveLock on extension

On Thu, Apr 16, 2015 at 1:24 PM, Andomar ando...@aule.net wrote: After upgrading our database from 9.3.5 to 9.4.1 last night, the server suffers from high CPU spikes. During these spikes, there are a lot of these messages in the logs: process X still waiting for ExclusiveLock on extension

Re: [GENERAL] Waiting on ExclusiveLock on extension

On Thu, Apr 16, 2015 at 2:39 PM, Andomar ando...@aule.net wrote: That post is about a server with huge shared_buffers, but ours is just 8GB. Total memory 48GB memory on a dedicated server. Checkpoints write around 2% of the buffers. Are you able to take some 'perf top' during high CPU spike and

Re: [GENERAL] Strange Behavior with Serializable Transcations

Tom Lane [EMAIL PROTECTED] wrote Right, the snapshot does not become set until you do a non-utility command (normally, SELECT/INSERT/UPDATE/DELETE). This is a feature, not a bug, because it lets the transaction take table locks before its snapshot becomes set. Hm, mostly I understand it

Re: [GENERAL] Strange Behavior with Serializable Transcations

Tom Lane [EMAIL PROTECTED] wrote It can, but there are cases where you want the lock to be taken before the snapshot is set. Otherwise, there could be committed changes in the database that you can't see in your snapshot. I think there are some examples in the manual, or check the

Re: [GENERAL] Out of memory error in 8.1.0 Win32

On Wed, 21 Jun 2006, Relyea, Mike wrote: ExecutorState: 550339936 total in 123 blocks; 195003544 free (740135 chunks); 355336392 used HashBatchContext: 293593176 total in 44 blocks; 3107384 free (80 chunks); 290485792 used TIDBitmap: 2088960 total in 8 blocks; 924720 free (27 chunks);

Re: [GENERAL] problem connecting to server

Trigve Siver [EMAIL PROTECTED] wrote Thank you for reply. No there isn't any panic message. Log contain only messages I have posted. Check out this thread (or search background writer process exited in list): http://archives.postgresql.org/pgsql-general/2006-05/msg01568.php Regards,

Re: [GENERAL] simple query terminated by signal 11

Thomas Chille [EMAIL PROTECTED] wrote I don't know how to post it, because the size is 1,5 MB?! I try to attch it as gzip. No ... I mean the bt result of the core dump. $gdb postgres_exe_path -c core_file_name bt . Program terminated with signal 11, Segmentation fault. #0 0x080753c2

Re: [GENERAL] simple query terminated by signal 11

Thomas Chille [EMAIL PROTECTED] wrote Hi List, i run in to an error while dumping a db. after investigating it, i found a possible corrupted table. but i am not sure. and i dont know how i can repair it? could it be a harddrive error? # now the error: SELECT * FROM hst_sales_report WHERE

Re: [GENERAL] problem connecting to server

Trigve Siver [EMAIL PROTECTED] wrote I have installed PostgreSQL 8.1 on windows XP with SP2 ... 2006-06-19 12:00:38 LOG: terminating any other active server processes 2006-06-19 12:00:38 LOG: all server processes terminated; reinitializing 2006-06-19 12:00:41 LOG: background writer

Re: [GENERAL] Out of memory error in 8.1.0 Win32

Qingqing Zhou [EMAIL PROTECTED] wrote ExecutorState: 550339936 total in 123 blocks; 195005920 free (740144 chunks); 355334016 used ... HashBatchContext: 293593176 total in 44 blocks; 3107384 free (80 chunks); 290485792 used TIDBitmap: 2088960 total in 8 blocks; 1012120 free (27 chunks

Re: [GENERAL] How to optimize PostgreSQL database size

Linux Portal [EMAIL PROTECTED] wrote The article on the subject can be read here: http://linux.inet.hr/optimize_postgresql_database_size.html After dump/restore the database size is 1685 MB and after vacuum-full/reindex is 1990 MB. Where we saved 305 MB? Regards, Qingqing

Re: [GENERAL] Out of memory error in 8.1.0 Win32

Relyea, Mike [EMAIL PROTECTED] wrote Is this what you're looking for? No. I mean per-context memory usage output like this in your log file: 2006-06-08 16:33:09 LOG: autovacuum: processing database ibox TopMemoryContext: 84400 total in 7 blocks; 12696 free (22 chunks); 71704 used Operator

Re: [GENERAL] Out of memory error in 8.1.0 Win32

Relyea, Mike [EMAIL PROTECTED] wrote I've just started receiving an out of memory error with my most complex query. Can you post the memory usage log after the error the server reports? Regards, Qingqing ---(end of broadcast)--- TIP 6:

Re: [GENERAL] Insert into partition table hangs

Nikola Ivanov [EMAIL PROTECTED] wrote Database is running on Windows 2003 Advanced Server and it is PostgreSQL 8.1.3. On 6/9/06, Tom Lane [EMAIL PROTECTED] wrote Buggy SysV semaphore support in the kernel, maybe? What platform is this exactly? Yes, there is a bug in 8.1.3 Win32 SYSV

Re: [GENERAL] Disk corruption detection

Florian Weimer [EMAIL PROTECTED] wrote Anyway, how would be the chances for PostgreSQL to detect such a corruption on a heap or index data file? It's typically hard to detect this at the application level, so I don't expect wonders. I'm just curious if using PostgreSQL would have helped to

Re: [GENERAL] Ever increasing OIDs - gonna run out soon?

John Sidney-Woollett [EMAIL PROTECTED] wrote It looks like the db is using them at the rate of 1.5 million per day. At what value will I hit a wraparound, and what options do I have to identify/fix the (impending) problem. The Oid will wraparound when it reaches the 32bits unsigned integer

Re: [GENERAL] Insert into partition table hangs

Nik [EMAIL PROTECTED] wrote I also noticed that I am having the similar issue with SELECT statements. Same SELECT statement will run fine 3-4 times in a row and then get stuck and run forever with no results. But if I reload the configuration like above, the query immediatelly returns with

Re: [GENERAL] Out of Memory Error on Postgresql 8.1.3. on win32

Harald Armin Massa [EMAIL PROTECTED] wrote today postgresql 8.1.3 on win32 died: 2006-06-08 16:33:12 ERROR: out of memory 2006-06-08 16:33:12 DETAIL: Failed on request of size 16777212. I didn't see any strange number in your log message and 16777212 is 16M, which is not a scary number ...

Re: [GENERAL] error 57014

Tom Lane [EMAIL PROTECTED] wrote Well, *something* sent that backend a SIGINT. Could something be the backend statement_timeout? I remember [but not sure] we don't differenciate timeout or explicite SIGINT in 7.4.x. Regards, Qingqing ---(end of

Re: [GENERAL] Restoring databases from a different installment on Windows

Berislav Lopac [EMAIL PROTECTED] wrote I have recently reinstalled my Windows mychine, including the PostgreSQL server, but (due to a system crash, unrelated to Postgres) I wasn't able to dump my databases to import them now. However, I have a full copy of the original system, including all

Re: [GENERAL] delete is extremely slow

Emi Lu [EMAIL PROTECTED] wrote Hello, Tried to run: delete from tableA where id 60; It is extremely slow. id is integer and also the primary key. tableA has around 9 records. (I do not want to run truncate since I have some foreign key constraint setup based on tableA. Besides

Re: [GENERAL] Insert into partition table hangs

Nik [EMAIL PROTECTED] wrote I have an application that executes an INSERT statement every second or two. In my old design this data was inserted into one table. However, I changed the design to have one table with multiple partitions. Now when I run the application it runs for some random

Re: [GENERAL] Postmaster cannot start

Chun Yit(Chronos) [EMAIL PROTECTED] wrote saw from the log file, it's possible that server crash during vacuum process... Question : 1) what happen to my database server? what the error meaning? It looks like index pg_class_relname_nsp_index (which is an index on pg_class) is corrupted.

Re: [GENERAL] Postmaster cannot start

Chun Yit(Chronos) [EMAIL PROTECTED] wrote postmaster give me error every time i try to start it LOG: redo starts at A/46315F50 PANIC: btree_delete_page_redo: uninitialized right sibling So the last resort I can think of is to use pg_resetxlog to pass the startup failure -- but no gaurantee

[GENERAL] How to have a blind-superuser

Is it possible to have a superuser who could do CHECKPOINT, BACKUP and whatever but could not see any user data? Regards, Qingqing ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] How to have a blind-superuser

Jim C. Nasby [EMAIL PROTECTED] wrote On Mon, Apr 24, 2006 at 06:16:30PM +0800, Qingqing Zhou wrote: Is it possible to have a superuser who could do CHECKPOINT, BACKUP and whatever but could not see any user data? Not for backup. It'd be rather tricky to allow backing up data without being

Re: [GENERAL] PANIC: heap_update_redo: no block

Alex bahdushka [EMAIL PROTECTED] wrote (@)2006-03-18 23:30:33.035 MST[3791]PANIC: heap_update_redo: no block According to the discussion in pgsql-hackers, to finish this case, did you turn off the full_page_writes parameter? I hope the answer is yes ... Regards, Qingqing

Re: [GENERAL] PANIC: heap_update_redo: no block

Alex bahdushka [EMAIL PROTECTED] wrote LOG: REDO @ D/19176610; LSN D/19176644: prev D/191765E8; xid 81148979: Heap - clean: rel 1663/16386/16559898; blk 0 LOG: REDO @ D/19176644; LSN D/191766A4: prev D/19176610; xid 81148979: Heap - move: rel 1663/16386/16559898; tid 1/1; new 0/10 PANIC:

Re: [GENERAL] PANIC: heap_update_redo: no block

Alex bahdushka [EMAIL PROTECTED] wrote (@)2006-03-25 20:54:17.528 MST[26571]LOG: REDO @ D/19176610; LSN D/19176644: prev D/191765E8; xid 81148979: Heap - clean: rel 1663/16386/16559898; b (@)2006-03-25 20:54:17.528 MST[26571]LOG: REDO @ D/19176644; LSN D/191766A4: prev D/19176610; xid

Re: [GENERAL] Advantages of PostgreSQL over MySQL 5.0

Merlin Moncure [EMAIL PROTECTED] wrote In postgresql, queries executed over the parameterized/prepared C api are particularly fast...as much as a 70% speed reduction over vanilla PQexec. Does it mean 70% time is spent on planning? I am a little bit interested in this number. Can you specify

Re: [GENERAL] How to release locks

Andrus [EMAIL PROTECTED] wrote insert command takes a long time. I terminated the client application from Windows XP client manager during insert command. At next re-run application and pgadmin both hang in DELETE FROM line I think I can reproduce this. Postgres server is in FreeBSD. I can

Re: [GENERAL] PANIC: heap_update_redo: no block

Alex bahdushka [EMAIL PROTECTED] wrote Hrm... well i obviously have restored the database by now (using pg_resetxlog; pg_dump; initdb; pg_restore). However i did make a backup of the broken directory before I created the new database. If anyone has any thing they would like me to try to

Re: [GENERAL] PANIC: heap_update_redo: no block

Tom Lane [EMAIL PROTECTED] wrote While at it, you should extend the error message to include the relation ID, so you have some idea which table is affected ... this is certainly not a very informative message ... Exactly. Please use the following version: - elog(PANIC, heap_update_redo: no

Re: [GENERAL] PANIC: heap_update_redo: no block

Tom Lane [EMAIL PROTECTED] wrote Qingqing Zhou [EMAIL PROTECTED] writes: BTW: I just realized that there is another (better) way to do so is to enable WAL_DEBUG in xlog.h and SET XLOG_DEBUG=true. And that's why we don't have much error message in xlog redo. That was probably Vadim's

Re: [GENERAL] How to release locks

Andrus [EMAIL PROTECTED] wrote After killing client from XP task manager command DELETE FROM mytable runs forever. This is probably because pgAdmin shows that there are some locks placed (see included picture). It is not because of the locks. There is only running transaction (and it

Re: [GENERAL] invalid page header

Jo De Haes [EMAIL PROTECTED] wrote CETERROR: XX001: invalid page header in block 22182 of relation dunn_main My main question is: why is this occuring? I suppose there is no system error happens during the period (like lost power). Can you attach the gdb at b bufmgr.c:257 and print the

Re: [GENERAL] PANIC: heap_update_redo: no block

Alex bahdushka [EMAIL PROTECTED] wrote After doing some more digging, it looks like that server was missing the appropriate Kpostgresql symlink in /etc/rc0.d/. So upon shutdown (shutdown -h now)... my guess is it got a sigterm (you know where it says Sending all processes a TERM signal or

Re: [GENERAL] Error in Postgresql after a Machine Crash

Paulo Henrique Oliveira [EMAIL PROTECTED] wrote I was using postgres 7.2.1 in a Debian Woody server (in prodution). The machine crashed and when I restart it the following error occurs a lot in log. 2006-03-14 14:35:23 [11858] ERROR: XLogFlush: request 102/7407C864 is not satisfied ---

Re: [GENERAL] \copy combine with SELECT

jia ding [EMAIL PROTECTED] wrote I tried: select id, name into table2 from table1; \copy table2 to filename.txt in order to export 2 columns from table1 to a file. But, I am thinking, if there is a command can combine these two command together? Notice that COPY command can be used

Re: [GENERAL] How do I use the backend APIs

Chad [EMAIL PROTECTED] wrote In Postgres, is there a C language API which would give me access to BTrees like Berkeley DB does? eg to seek to a particular key/value pair and iterate forward from there? AFAIK there is no such API for this purpose. The reason is that to access BTree, you have

Re: [GENERAL] Huge number of disk writes after migration to 8.1

On Tue, 17 Jan 2006, Marcin wrote: Playing with postgresql.conf I changed stats_command_string to off, reloaded config, and restarted connection from applications (the postgresql wasn't restarted). The write rate immediately drops down, and is now at 8000-9000 blocks per second (which is

Re: [GENERAL] Huge number of disk writes after migration to 8.1

Marcin [EMAIL PROTECTED] wrote I suffer from huge increase in number of disk writes after migration from 8.0.3 to 8.1.2. The average number of sectors written increased 10 times and transfer stays at 20MB of writes per second during work hours (with 20% cpu time wasted in iowait). The number

Re: [GENERAL] Error when inserting millions of records

Rudolph [EMAIL PROTECTED] wrote Me and a friend are testing some operations for a search application in PostgreSQL. In version 8.1 my friend tried to copy the result of a join into another table, about 45.000.000 (small) records. This is the result: testsearch= insert into t_documentword2

Re: [GENERAL] Plans for 8.2?

Tom Lane [EMAIL PROTECTED] wrote The key word there is safely. We don't have a lot of trust in SIGTERM'ing individual backends (as opposed to shutting down the whole cluster at once, which is a well-tested code path). See the archives. Maybe related question: is the code below in

Re: [GENERAL] extend sql?

xiapw [EMAIL PROTECTED] wrote Hello everyone,I want to konw how to extend the SQL. For example,Create table temp [sec_level],sec_level means the secure level of the table that you have created,how to do this? If you mean extend the SQL grammar, modify file backend/parser/gram.y. Regards,

Re: [GENERAL] index and MVCC

[EMAIL PROTECTED] wrote a table is created and an index is created on that table then one row is updated what happens to the index file? ( is the index to old row deleted?) Nothing happened to the index file. The index row is not deleted since there is no MVCC information associated with

Re: [GENERAL] xml export tool?

JJC [EMAIL PROTECTED] wrote I'm looking for an open-source tool that will allow me to extract data as XML. If you want to extract data from PostgreSQL, I think most XML export tool will do if they can connect to database via ODBC/JDBC. Regards, Qingqing ---(end

Re: [GENERAL] psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)

Ari Kahn [EMAIL PROTECTED] wrote I'm doing a query that really should be too taxing. But when I execute it I get the following error(s): psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3) Nested Loop (cost=89.36..6086.42 rows=273312 width=88) (actual

Re: [GENERAL] psql(18967) malloc: *** vm_allocate(size=8421376) failed (error

On Wed, 11 Jan 2006, Ari Kahn wrote: I have LOTS of memory (5GB). What is the appropriate way to add more memory slots? Or increase my VM file size? Hmm ... What OS are you using? Regards, Qingqing ---(end of broadcast)--- TIP 1: if

Re: [GENERAL] psql(18967) malloc: *** vm_allocate(size=8421376) failed (error

On Wed, 11 Jan 2006, Ari Kahn wrote: Mac OSX 10.4 Seems this is a known problem of Mac. Try to google vm_allocate failed. Regards, Qingqing ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] psql(18967) malloc: *** vm_allocate(size=8421376) failed (error

On Wed, 11 Jan 2006, Ari Kahn wrote: Could you be more specific. It seems that lots of people get this error message on many platforms. http://groups.google.ca/groups?hl=enq=vm_allocate%20failedsa=Ntab=wg I checked the first several pages. You will most of them point to Mac or NeXT.

Re: [GENERAL] contrib library in windows

SunWuKung [EMAIL PROTECTED] wrote Does the contrib library exist for Windows? If you are compiling from source tar ball, it is in pgsql\contrib. Regards, Qingqing ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore

Re: [GENERAL] More atomic online backup

On Fri, 6 Jan 2006, Bruno Almeida do Lago wrote: Hi, 1) I've a pg cluster with 5 databases here. I was wondering if it's possible to make an online backup of 1 database only, not the entire cluster. Check out tool pg_dump or the documents for other options. 2) Online backups at Oracle

Re: [GENERAL] pg_dump throws no buffer space available error

Vishal Dixit [EMAIL PROTECTED] wrote We are running postgres version 8.0 on windows server 2003. On doing a pg_dump of a large database the following error occurs: pg_dump: could not receive data from server: No buffer space available There is one table in the database containing bytea

Re: [GENERAL] Hardware recommendation for PostgreSQL on Windows?

Bj?rn T Johansen [EMAIL PROTECTED] wrote I an planning to make a small Windows application and need a nice database I am used to using PostgreSQL under Linux and I am thinking about using this under Windows but how much resources does it use under Windows? The server will be running on

Re: [GENERAL] build Postgresql on Solaris 64 bits

FERREIRA, William (GFI INFORMATIQUE) [EMAIL PROTECTED] wrote i'm trying to install Postgresql on Solaris. Looking at the generated code, i saw that it was in 32 bits. I would like to compile Postgresql in 64 bits but i didn't find any post in the archives about this. Check out this thread

Re: [GENERAL] pg_reload_conf() does not unset archive_command

Andrus Moor [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 1. Make sure that postgres.conf file contains in first line: archive_command = 'copy %p c:/arhiiv/%f' 2. Edit postgres.conf file by adding # before this line #archive_command = 'copy %p c:/arhiiv/%f' 3. Run SELECT

[GENERAL] SET SESSION TRANSACTION command

test=# SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE; SET test=# show transaction_isolation; transaction_isolation --- read committed (1 row) Is this a bug by any chance or we do it intentionally? Regards, Qingqing ---(end of

Re: [GENERAL] SET SESSION TRANSACTION command

On Sun, 1 Jan 2006, Tom Lane wrote: Qingqing Zhou [EMAIL PROTECTED] writes: test=# SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE; SESSION is taken as a noise word here. Possibly we should disallow this syntax altogether, since it isn't SQL-spec ... but I'm not sure it's worth

Re: [GENERAL] how to add a new column to system table

xiapw [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I wanted to add a new column to system table(pg_database),but failed at last. Who know how to do this and can you tell me ? A recent change to pg_database (adding a new column) happened on -- Sun Jul 31 17:19:21 2005 UTC (4

Re: [GENERAL] I want to know how to improve the security of postgresql

xiapw [EMAIL PROTECTED] wrote Hi guys,can you give me some advices about how to improve the security of postgresql? Now I major in the security of postgresql and the destination is create a database with security level of B1(TCSEC),what should I do now,what program language should I use?

Re: [GENERAL] newbie : setting access for users in a web enviroment

robert mena [EMAIL PROTECTED] wrote How can I specify that the user testadm can perform those actions to this database? Use GRANT command (the opposite is REVOKE). I suppose you are using 8.1: http://www.postgresql.org/docs/8.1/static/sql-grant.html Regards, Qingqing

Re: [GENERAL] Funky template1 problem?

Jerry LeVan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I have a bunch of small dbs (levan, pictures, and a couple of others). I have had these db's over many upgrades and I have just noticed that template1 seems to be a bit munged... testuser= \c template1 You are now

Re: [GENERAL] Funky template1 problem?

On Wed, 21 Dec 2005, Tom Lane wrote: Jerry LeVan [EMAIL PROTECTED] wrote in message I have had these db's over many upgrades and I have just noticed that template1 seems to be a bit munged... I'm sure they are. Oh right -- since CREATE DATABASE just copied the whole directory.

Re: [GENERAL] Migration tool from MS SQL server 7.0

dfx [EMAIL PROTECTED] wrote Dear Sirs, it exist some tool to convert a SQL script generated from MS SQL 7 to the syntax compatible with Postgresql v. 8.x.x? In general, I bet no - since some functionalities in SQL Server is different from ours, say TableSpace. Regards, Qingqing

Re: [GENERAL] keeping track of inserts (periodical) into a table

Assad Jarrahian [EMAIL PROTECTED] wrote Hi all, I have a design decission to make. I am using Lucene (Java Search API) and I need to update lucenes index from time to time. Is there a way one can keep track of all the inserts coming into a table (holding onto their Primary key's are

Re: [GENERAL] user_write_lock_oid questions

Marian Naghen [EMAIL PROTECTED] wrote 1. if a user set a write lock and then, for some reason (bad connections, app chashes, etc), disconect from server without releasing, what happened with the lock ? It will be still holding ? When the connection is lost, server will release all its

Re: [GENERAL] invalid page header in block 597621 of relation...error

Tom Lane [EMAIL PROTECTED] wrote At this point I think there's no question that your filesystem is dropping blocks :-(. It is very interesting to follow this thread. But at this point, can you explain more why there is no question is file system's fault? Thanks, Qingqing

Re: [GENERAL] Difference in indexes

A.j. Langereis [EMAIL PROTECTED] wrote What is happening here? What am I overlooking? The length does not seem to be the problem: 'FooFooFoo' also uses the index.. Also the fact whenever there are results or not does not seem to influence the planner.. Check out this thread:

Re: [GENERAL] Conditional delete

On Mon, 21 Nov 2005, Bartosz Jakubiak wrote: Hi. I'm new with PostgreSQL, but this thing doesn't allow me to sleep: I wonder if it is possible to execute SQL query which: 1. checks out if table exists, and if it is: 2. deletes it All of it at SQL query level, preferrably in one

Re: [GENERAL] Difference in indexes

A.j. Langereis [EMAIL PROTECTED] wrote Bitmap Heap Scan on hosts (cost=2.07..11.34 rows=21 width=59) (actual time=0.175..0.287 rows=21 loops=1) Recheck Cond: ((hostname)::text = 'Fabian'::text) - Bitmap Index Scan on hosts_hostname (cost=0.00..2.07 rows=21 width=0) (actual

[GENERAL] Win32 libpq and ecpg thread safety

Hi, Is there a paragraph in the document talking about this? I've tried to look into it, but can't find it. Can anybody point me to it? Thanks, Qingqing ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

Re: [GENERAL] Win32 libpq and ecpg thread safety

On Wed, 26 Oct 2005, Bruce Momjian wrote: If you are asking about Win32-specific threading, there is no documentation about it because it works just like Unix threading. At least, that is what I am told. So both libpq and ecpg are thread-safe in Win32? I look into the code, seems at

Re: [GENERAL] copy data between database

Scott Marlowe [EMAIL PROTECTED] wrote Under no circumstances should you do this with a database that has any data in it that you value. pg_dump / pg_restore / psql are the preferred way of doing this. Oh yeah, sorry for the miss leading information. My method is dangerous and can not

Re: [GENERAL] copy data between database

[EMAIL PROTECTED] wrote Hi, I have a table A in both database d1 and d2. I would like to copy data in A in d1 to A in d2. How can I do it? I do not want to copy all data, just some part of A, Here is a way if you feel want to try. The basic idea is that create a table (say OS file name of

Re: [GENERAL] could not send data to server: Operation not supported

ruben [EMAIL PROTECTED] wrote A PHP script that is running every 30 minutes for three years has crashed when updating a Postgres database table with this error message: pg_exec() query failed: could not send data to server: Operation not supported I just ran it again and it worked

Re: [GENERAL] [SQL] add column if doesn't exist (fwd)

Brandon Metcalf [EMAIL PROTECTED] wrote Is there a way to check for the existence of a column in a table other than, say, doing a SELECT on that column name and checking the output? Take a look at pg_attribute system table. http://www.postgresql.org/docs/8.0/static/catalog-pg-attribute.html

Re: [GENERAL] Can not get ODBC to log. Trace is not working.

Roy Souther [EMAIL PROTECTED] wrote I am trying to get the ODBC client to log but I just can't. I have included my odbc.ini and odbcinst.ini. Can anyone tell me why there is never a log file created? I connect to the database with isql and OpenOffice, run queries and get data but never do I ever

Re: [GENERAL] GiST access is not concurrent

John Surnow [EMAIL PROTECTED] wrote Does this mean that read access is not concurrent, or write access, or both? For old GiST, you can have several connections read-*only* at the same time, but write/write or read/write is unsafe. GiST in 8.1 is concurrent safe already. Regards, Qingqing

Re: [GENERAL] How to set an expiration date for a WHOLE user account

Tom Lane [EMAIL PROTECTED] writes: He's right, you're not: that check is only applied in the password-based authorization path. This has always seemed a bit bogus to me too --- would not object to a well-thought-out patch to change it. If we add a VALID UNTIL column in pg_hba.conf, then

Re: [GENERAL] PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps

Tom Lane [EMAIL PROTECTED] writes Evidently that's not often enough. Or it could be that your FSM settings aren't large enough? Setting various proper parameters of FSM is onerous for maintainence. Is there any plan to make FSM buffer-file-able, just like what clog does now? Regards,

Re: [GENERAL] (NONE)

jeremy ` [EMAIL PROTECTED] writes get some screenshots, and i got this message: Internal account lookup failure: No mappiong between account names and security IDs was done. This was recently asked. Search Internal account lookup failure in list. Regards, Qingqing

Re: [GENERAL] How to set an expiration date for a WHOLE user account

Együd Csaba [EMAIL PROTECTED] writes I'm wonder how I can disable a user (without droping of course). Is there a way to set an expiration date to prevent logins after that date? I know the VALID UNTIL clause of CREATE USER command, but it is about the password only. I think something

[GENERAL] Does SELECT INTO is affected by default_tablespace?

According to my test, it does not: test=# set default_tablespace = testsp; SET test=# create table a (i int); CREATE TABLE test=# select * into b from a; SELECT test=# \d+ b Table public.b Column | Type | Modifiers | Description +-+---+- i

Re: [GENERAL] getting lock information

Himanshu Baweja [EMAIL PROTECTED] writes I wanted to see which tables/transaction have acquired or are waiting for which locks as far as i know there are two ways to do it 1) pg_locks ::: need to write trigger... and have high overhead... select * from pg_locks has trivial impact on the

Re: [GENERAL] Database monitor (again)

Edson Vilhena de Carvalho [EMAIL PROTECTED] writes Sorry but perhaps it is a database monitorizer that makes the monitorization on the databases. It's my english Ok, don't worry about your English. Try to find out your questions in your language here: http://www.postgresql.org/docs/faq/

Re: [GENERAL] truncate/create slowness

Joe Maldonado [EMAIL PROTECTED] writes I suspect that pg_class has too many pages (49182 as below) and for some reason the above commands spend a lot of time updating it. vacuum/analyze on pg_class has not helped. Also, since the time taken for these commands is not consistently fast or slow,

Re: [GENERAL] Postgres Processing Help !!!!

Carlos Roberto Chamorro Mostac [EMAIL PROTECTED] writes Hello to all, I have a problem with the use of temporary tables to have if somebody has an idea. Handling an application that it requires to process 6,000 registries Parents and the processing of each one requires to process N

Re: [GENERAL] Triggers: using table's primary key value to update another field

Randall Perry [EMAIL PROTECTED] writes What I'm having trouble with is figuring out how to grab the primary key value of the current row. I tried tacking on a var with the pkey row name to NEW, but that doesn't work (didn't think it would). There is an example in PG docs.

Re: [GENERAL] Debugging deadlocks

Michael Fuhr [EMAIL PROTECTED] writes To make sure the referenced key can't change until the transaction completes and the referencing row becomes visible to other transactions (or is rolled back) -- otherwise other transactions could change or delete the referenced key and not know they'd be

Re: [GENERAL] Debugging deadlocks

Stephan Szabo [EMAIL PROTECTED] writes Well, that's not the foreign key necessarily. I don't have a machine to test on at the moment (machine currently dead), but I think the same happens without a foreign key constraint due to the unique/primary key constraint on a.i. I see. That's more

Re: [GENERAL] Parallel Query should be a top priority

Mike Mascari mascarm@mascari.com writes Consider parallel processing a single query should be moved out from under Miscellaneous on the TODO list and re-categorized as the formerly existent URGENT feature... Yes, inter/inner-operation of PQO could be an obvious winner in some situations. For

Re: [GENERAL] Measuring Query Performance

Ed L. [EMAIL PROTECTED] writes How are others handling this problem? Other ideas? In your client, you will measure the libpq/odbc/jdbc or whatever call's completion time and send the interesting parts to your log database. And just make sure the tested database and the log database are in

Re: [GENERAL] Measuring Query Performance

Qingqing Zhou [EMAIL PROTECTED] writes Ed L. [EMAIL PROTECTED] writes How are others handling this problem? Other ideas? Sorry, forget to mention this project: http://pqa.projects.postgresql.org/example.html Regards, Qingqing ---(end of broadcast

Re: [GENERAL] Tracking row updates

Alex Adriaanse [EMAIL PROTECTED] writes Applying this analogy to our database, wouldn't that require a table-level lock during a CVS-like commit (which would mean locking the table, getting the revision number, updating the row(s), and committing the transaction)? You may have a look at how

Re: [GENERAL] Tracking row updates

Alex Adriaanse [EMAIL PROTECTED] writes This seems to work, except there exists a race condition. Consider the following series of events (in chronological order): 1. Initially, in the codes table there's a row with id=1, revision=1, and a row with id=2, revision=2 2. Client A

  1   2   >