Re: [GENERAL] Maximum size of database

2006-10-18 Thread roopa perumalraja
Thanks for your reply.I have answered your questions below. 1 2) System: Microsoft Windows XP Professional Version 2002 Computer: Intel Pentium CPU 3.40GHz, 960MB of RAM3) shared_buffers = 2 autovaccum = on4) Yes, I am vacuuming analyzing the database once every day.5)

[GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Ilja Golshtein
Hello! One important use case in my libpq based application (PostgreSQL 8.1.4) is a sort of massive data loading. Currently it is implemented as a series of plain normal INSERTs (binary form of PQexecParams is used) and the problem here it is pretty slow. I've tried to play with batches and

Re: [GENERAL] Maximum size of database

2006-10-18 Thread louis gonzales
also, run EXPLAIN on any command, show the results of this. In particular, if you have some commands that are taking 'even longer?' roopa perumalraja wrote: Thanks for your reply. I have answered your questions below. 1 2) System: Microsoft Windows XP Professional Version

Re: [GENERAL] Maximum size of database

2006-10-18 Thread roopa perumalraja
HiThanks for your reply.explain select * from tk_20060403; QUERY PLAN --Seq Scan on tk_20060403 (cost=0.00..95561.30 rows=3609530 width=407)(1 row) will this help?louis gonzales [EMAIL PROTECTED] wrote: also,

[GENERAL] Cannot connect to Fedora Core 5 server from the network

2006-10-18 Thread dfx
Dear Sirs, I have some trouble to connect to PostgreSQL .8.0 running on Fedora Core 5 server with PgAdmin III v. 1.4.2 running on Windows 2000 Server on the same (local) network. The database server is accessible from PgAdmin ||| running on the same server (Linux) and itseems OK but is

Re: [HACKERS] [GENERAL] query log corrupted-looking entries

2006-10-18 Thread Albe Laurenz
Tom Lane wrote: I checked around with some kernel/glibc gurus in Red Hat, and the consensus seemed to be that we'd be better off to bypass fprintf() and just send message strings to stderr using write() --- ie, instead of elog.c doing fprintf(stderr, %s, buf.data); do

[GENERAL] Urgen help required

2006-10-18 Thread J S B
Hi,I have the following scenario:-1. There's a function in the postgres datbase that when executed calls a shared object (dynamically loaded).2. The shared object is a Client (made using socket library) which connects to a server (coded again using socket library) hosted on some other machine. 3.

Re: [GENERAL] help with sql query

2006-10-18 Thread Albe Laurenz
Richard Broersma Jr wrote: id id_1id_2 date_time 1101 10002006-07-04 11:25:43 I want to find all records have same id_1, but different id_2 and have difference in time less than 5 minutes. In this case this is record 1 and record 3. How can I do this ? I am sure that

[GENERAL] Moving postgres users accounts from one postgres 7.3 to postgres 8.0

2006-10-18 Thread Najib Abi Fadel
Hi,i need to move my postgres users with their passwords from one postgres version (7.3) to a newer one (8.1) . Is there an automatic way to do that without having to recreate the users with their passwords ??Thanks for any helpNajib.

Re: [GENERAL] Cannot connect to Fedora Core 5 server from the network

2006-10-18 Thread A. Kretschmer
am Wed, dem 18.10.2006, um 9:47:56 +0200 mailte dfx folgendes: The files pg_hba.conf and postgreql.conf are correctly configured (in my opinion...) Sure? You need an entry for your LAN in the pg_hba - file. Is there some special setting to 'see' the SQL server from the network for

Re: [GENERAL] Maximum size of database

2006-10-18 Thread louis gonzales
explain analyze verbose select * from tk_ ; roopa perumalraja wrote: Hi Thanks for your reply. explain select * from tk_20060403; QUERY PLAN -- Seq

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Shane Ambler
Ilja Golshtein wrote: Hello! One important use case in my libpq based application (PostgreSQL 8.1.4) is a sort of massive data loading. Currently it is implemented as a series of plain normal INSERTs (binary form of PQexecParams is used) and the problem here it is pretty slow. I've tried to

Re: [GENERAL] Maximum size of database

2006-10-18 Thread Matthias . Pitzl
Title: Nachricht What disk subsystem do you have? Single disks? Raid? Raid with battery buffered write cache? Last one can improve your performance massively. -- Matthias -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of roopa

Re: [GENERAL] ERRORDATA_STACK_SIZE exceeded

2006-10-18 Thread Stefan Sassenberg
Tom Lane wrote: Stefan Sassenberg [EMAIL PROTECTED] writes: [EMAIL PROTECTED] is ISO-8859-15, if that helps. I changed the locale to en_US.UTF-8 and LC_CTYPE in the environment is set to that value too. Nevertheless show lc_ctype says [EMAIL PROTECTED], even after a postgresql restart. How

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Ilja Golshtein
Hello! Using COPY FROM STDIN is much faster than INSERT's (I am sure some out there have test times to compare, I don't have any on hand) Yes, I know it is much faster. The question is about possible pay for this quickness. What if COPY, say, locks index until end of transaction (it is just

[GENERAL] Information regarding currently locked tables

2006-10-18 Thread Nirmalya Lahiri
Hi all, I want a list of currently locked tables. How can I do that? I already found a list from pg_locks table. But how I know the name of the table against relation id of a relation? Nirmalya Lahiri(+91-94331-13536) Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small

Re: [GENERAL] Maximum size of database

2006-10-18 Thread Gregory S. Williamson
Roopa, I think that by defintion a SELECT * FROM sometable; will always take longer as the table increases in size (but if anyone who is more versed in theory of searches, sorts, etc. contradicts me I'll happily listen!). Note that the database could increase enormously with no direct effect

Re: [GENERAL] Fixed-point scalars?

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/17/06 22:14, Michael Glaesemann wrote: On Oct 18, 2006, at 9:46 AM, Ron Johnson wrote: SMALLINT(2) INTEGER(2) BIGINT(2) Are these data-types not in PG, or am I missing something?

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Shane Ambler
Ilja Golshtein wrote: Sounds like your working with an existing database - if you are starting from scratch (inserting data into an empty database) then there are other things that can help too. I am working with existing database, though I am interested what other things you mean.

Can't get ECPG to connect (was Re: [GENERAL] Urgen help required)

2006-10-18 Thread Bill Moran
In response to J S B [EMAIL PROTECTED]: Hi, I have the following scenario:- 1. There's a function in the postgres datbase that when executed calls a shared object (dynamically loaded). 2. The shared object is a Client (made using socket library) which connects to a server (coded again

Re: [GENERAL] Is Postgres good for large Applications

2006-10-18 Thread Berend Tober
Sandeep Kumar Jakkaraju wrote: Is Postgres good for large Applications ?? Yes. cf., e.g., http://www.computerworld.com.au/index.php?id=760310963; ... Vice president of operations at Afilias, Ram Mohan said the .ORG database will be based on a standard implementation of PostgreSQL version

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Ilja Golshtein
When starting a database from scratch it is much faster to import the data and then create the indexes. The time to create index on a full table is less than the extra time from each index update from the inserts. The more indexes to update the more time updating indexes takes. The problem

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Martijn van Oosterhout
On Wed, Oct 18, 2006 at 04:20:41PM +0400, Ilja Golshtein wrote: And my question remains. Is it Ok to use COPY BINARY FROM STDIN instead of multiple INSERTs? The reason why copy is faster is because it doesn't have to parse/plan/execute all the queries. In exchange you can't use expressions or

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Ilja Golshtein
The reason why copy is faster is because it doesn't have to parse/plan/execute all the queries. In exchange you can't use expressions or joins to fill the table, only raw data. In other words, COPY has no hidden catches, and I should go with it and don't worry. Correct interpretation? ;)

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Merlin Moncure
On 10/18/06, Martijn van Oosterhout kleptog@svana.org wrote: Binary may be slightly faster because the datum parsing can be partially skipped, but that's hardly much benefit over a text copy. I tested binary quite a bit and only found it to be a win if moving blobs in and out of the database.

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Merlin Moncure
On 10/18/06, Ilja Golshtein [EMAIL PROTECTED] wrote: I've tried to play with batches and with peculiar constructions like INSERT (SELECT .. UNION ALL SELECT ..) to improve performance, but not satisfied with the result I've got. postgresql 8.2 (beta) supports the 'multiple insert' syntax, so

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Shane Ambler
Ilja Golshtein wrote: And my question remains. Is it Ok to use COPY BINARY FROM STDIN instead of multiple INSERTs? If it does what you want then it is OK to use it. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of

[GENERAL] increasing LIMIT with ORDER BY changes queryplan (7.4)

2006-10-18 Thread Jan Harders
Hi everyone, I'm new to postgre so please don't take anything implied but rather throw questions when something's unclear. Here's my problem or rather my question: I have a table with a category (four different values here), some data-fields I need and a few timestampfields indicating when which

Re: [GENERAL] increasing LIMIT with ORDER BY changes queryplan (7.4)

2006-10-18 Thread Merlin Moncure
On 10/18/06, Jan Harders [EMAIL PROTECTED] wrote: and, as guessed, takes forever. tried to ANALYZE the table but no change. Anyone got any ideas? I just don't understand why it's sorting the values while the index should already be sorted... Oh, btw, I'm on 7.4 (sarge stable version). Could

Re: [GENERAL] Moving postgres users accounts from one postgres 7.3 to postgres 8.0

2006-10-18 Thread Merlin Moncure
On 10/18/06, Najib Abi Fadel [EMAIL PROTECTED] wrote: Hi, i need to move my postgres users with their passwords from one postgres version (7.3) to a newer one (8.1) . Is there an automatic way to do that without having to recreate the users with their passwords ?? did you try pg_dumpall?

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 08:03, Merlin Moncure wrote: On 10/18/06, Martijn van Oosterhout kleptog@svana.org wrote: Binary may be slightly faster because the datum parsing can be partially skipped, but that's hardly much benefit over a text copy. I tested

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Merlin Moncure
On 10/18/06, Ron Johnson [EMAIL PROTECTED] wrote: I tested binary quite a bit and only found it to be a win if moving blobs in and out of the database. On 'normal' tables of mixed fields types of small size, it can actually be slower. Binary is a bit faster for native types and bytea, and

[GENERAL] Stats Collector Won't Start

2006-10-18 Thread Brad Nicholson
Can someone please provide a bit of information where the following error is coming from? This is PG 8.1.3 on AIX 5.3 LOG: could not bind socket for statistics collector: Permission denied LOG: disabling statistics collector for lack of working socket What exactly does the PG user not have

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 09:47, Merlin Moncure wrote: On 10/18/06, Ron Johnson [EMAIL PROTECTED] wrote: I tested binary quite a bit and only found it to be a win if moving blobs in and out of the database. On 'normal' tables of mixed fields types of small

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Alvaro Herrera
Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 09:47, Merlin Moncure wrote: On 10/18/06, Ron Johnson [EMAIL PROTECTED] wrote: I tested binary quite a bit and only found it to be a win if moving blobs in and out of the database. On 'normal' tables of

Re: [GENERAL] Connection Pooling for Postgres

2006-10-18 Thread Philip Hallstrom
Is there any inbuilt facility in postgres for connection pooling .. ?? Not built in, but... http://pgpool.projects.postgresql.org/ Never used it myself... ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Merlin Moncure
On 10/18/06, Ron Johnson [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 09:47, Merlin Moncure wrote: On 10/18/06, Ron Johnson [EMAIL PROTECTED] wrote: I tested binary quite a bit and only found it to be a win if moving blobs in and out of the database.

Re: [GENERAL] Stats Collector Won't Start

2006-10-18 Thread Tom Lane
Brad Nicholson [EMAIL PROTECTED] writes: Can someone please provide a bit of information where the following error is coming from? This is PG 8.1.3 on AIX 5.3 LOG: could not bind socket for statistics collector: Permission denied That's bizarre. What error conditions does your man page for

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Casey Duncan
On Oct 18, 2006, at 5:20 AM, Ilja Golshtein wrote: When starting a database from scratch it is much faster to import the data and then create the indexes. The time to create index on a full table is less than the extra time from each index update from the inserts. The more indexes to update

Re: [GENERAL] ERRORDATA_STACK_SIZE exceeded

2006-10-18 Thread Tom Lane
Stefan Sassenberg [EMAIL PROTECTED] writes: Is it a necessary restriction that the db encoding must match the lc_ctype? If you set the LC_ variables to C you can get away with using different encodings, but I wouldn't recommend it for any other locale setting. Aside from the message

Re: [GENERAL] Maximum size of database

2006-10-18 Thread Jeff Davis
On Wed, 2006-10-18 at 00:41 -0700, roopa perumalraja wrote: Hi Thanks for your reply. explain select * from tk_20060403; QUERY PLAN -- Seq Scan on

Re: [GENERAL] Stats Collector Won't Start

2006-10-18 Thread Brad Nicholson
On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote: Brad Nicholson [EMAIL PROTECTED] writes: Can someone please provide a bit of information where the following error is coming from? This is PG 8.1.3 on AIX 5.3 LOG: could not bind socket for statistics collector: Permission denied

Re: [GENERAL] Stats Collector Won't Start

2006-10-18 Thread Ben
I just had this problem last night my local firewall was blocking connections on the loopback interface. On Wed, 18 Oct 2006, Brad Nicholson wrote: Can someone please provide a bit of information where the following error is coming from? This is PG 8.1.3 on AIX 5.3 LOG: could not bind

Re: [GENERAL] Stats Collector Won't Start

2006-10-18 Thread Tom Lane
Brad Nicholson [EMAIL PROTECTED] writes: On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote: That's bizarre. What error conditions does your man page for bind(2) document as yielding EACCES? The only one mentioned on my systems is protected address, but we aren't requesting a reserved port

Re: [HACKERS] [GENERAL] query log corrupted-looking entries

2006-10-18 Thread Magnus Hagander
Hmm. If the messages are less than PIPE_BUF bytes long (4096 bytes on Linux) then the writes are supposed to be atomic. Some of them involve long messages (4K), but there are many that do not (like the ones I had posted at the start of this thread). I checked around with some

Re: [HACKERS] [GENERAL] query log corrupted-looking entries

2006-10-18 Thread Tom Lane
Magnus Hagander [EMAIL PROTECTED] writes: Should work fine on Windows. fileno() is deprecated however, with the following comment: C:\Program Files\Microsoft Visual Studio 8\VC\INCLUDE\stdio.h(688) : see declaration of 'fileno' Message: 'The POSIX name for this item is

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Ilja Golshtein
Is it Ok to use COPY BINARY FROM STDIN instead of multiple INSERTs? I don't think I would use BINARY, it seems likely to be susceptible to changes in the underlying data type storage. From the docs: To determine the appropriate binary format for the actual tuple data you should consult the

Re: [GENERAL] division by zero error in a request

2006-10-18 Thread Karen Hill
Bernard Grosperrin wrote: I wants to make a view giving me some statistics. I am not sure to understand why something like this SELECT location_id, (sold_parts_amount_dly + sold_labor_amount_dly) / (sold_parts_amount_dly + sold_labor_amount_dly) from sales give me a division by zero

[GENERAL] Drop All the Databases

2006-10-18 Thread Abu_Kamruzzaman
Is there any command to drop all the database at once drop database dbname drops the individual database. I am using ver8.1 thanks,

Re: [GENERAL] Stats Collector Won't Start

2006-10-18 Thread Brad Nicholson
On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote: Brad Nicholson [EMAIL PROTECTED] writes: On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote: That's bizarre. What error conditions does your man page for bind(2) document as yielding EACCES? The only one mentioned on my systems is

[GENERAL] column refernce question

2006-10-18 Thread Hugo
Hi, how can I know all the foreign key constrainst that references a particular pk ?this is on postgres 8.1.4 on susethanks for any adviceHugo

Re: [GENERAL] Stats Collector Won't Start

2006-10-18 Thread Tom Lane
Brad Nicholson [EMAIL PROTECTED] writes: On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote: Would you try strace'ing postmaster start to see what gets passed to the socket() and bind() calls just before this message comes out? Here is the relative output from truss. socket(2, 2, 0)

Re: [GENERAL] Stats Collector Won't Start

2006-10-18 Thread Brad Nicholson
On Wed, 2006-10-18 at 15:59 -0400, Tom Lane wrote: Brad Nicholson [EMAIL PROTECTED] writes: On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote: Would you try strace'ing postmaster start to see what gets passed to the socket() and bind() calls just before this message comes out? Here is

Re: [GENERAL] column refernce question

2006-10-18 Thread Jonathan Hedstrom
Hugo wrote: Hi, how can I know all the foreign key constrainst that references a particular pk ? You can try this: SELECT c_from.relname AS table, (SELECT attname FROM pg_catalog.pg_attribute a WHERE a.attrelid=c_from.oid AND attnum = array_to_string(conkey,',')) AS column FROM

Re: [GENERAL] Drop All the Databases

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 14:08, [EMAIL PROTECTED] wrote: Is there any command to drop all the database at once drop database dbname drops the individual database. I am using ver8.1 thanks, DROP DATABASE db_name; - -- Ron Johnson, Jr. Jefferson LA USA Is

Re: [GENERAL] uuid c function contrib

2006-10-18 Thread Ron Peterson
On Tue, Oct 17, 2006 at 09:07:08PM -0400, Ron Peterson wrote: On Tue, Oct 17, 2006 at 03:25:05PM -0400, Ron Peterson wrote: I've written some PostgreSQL C functions which expose the functionality of Theodore Ts'o's UUID library. % select y_uuid_time( y_uuid_generate_time() );

Re: [GENERAL] Stats Collector Won't Start

2006-10-18 Thread Chris Browne
[EMAIL PROTECTED] (Tom Lane) writes: Brad Nicholson [EMAIL PROTECTED] writes: On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote: Would you try strace'ing postmaster start to see what gets passed to the socket() and bind() calls just before this message comes out? Here is the relative output

Re: [GENERAL] uuid c function contrib

2006-10-18 Thread Ron Peterson
On Wed, Oct 18, 2006 at 04:31:57PM -0400, Ron Peterson wrote: I'm having a hard time finding any examples of functions returning timestamps I can study to see how they are handled internally. I'm sure it's only a line or two of code. ...I just found date.c -- Ron Peterson

Re: [GENERAL] Stats Collector Won't Start

2006-10-18 Thread Tom Lane
Brad Nicholson [EMAIL PROTECTED] writes: On Wed, 2006-10-18 at 15:59 -0400, Tom Lane wrote: Also, do regular connections to this postmaster work across TCP/IP? If getaddrinfo() is broken I'd expect there to be problems binding to the postmaster's listen socket too ... Yes, TCP/IP connections

Re: [GENERAL] Drop All the Databases

2006-10-18 Thread Tom Lane
[EMAIL PROTECTED] writes: Is there any command to drop all the database at once shutdown postmaster, rm -rf $PGDATA, initdb, start postmaster ... regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our list

Re: [GENERAL] Stats Collector Won't Start

2006-10-18 Thread Tom Lane
Chris Browne [EMAIL PROTECTED] writes: (gdb) print addr-ai_addr-sa_data $18 = \000\001\177\000\000\001\000\000\000\000\000\000\000 Hmm, that looks a bit odd --- what's the full declaration of structs sockaddr and sockaddr_in on that machine? regards, tom lane

Re: [GENERAL] Fast backup/restore

2006-10-18 Thread Jim C. Nasby
On Tue, Oct 17, 2006 at 02:43:28PM -0400, Vivek Khera wrote: On Oct 17, 2006, at 2:35 PM, Steve Poe wrote: Vivek, What methods of backup do you recommend for medium to large databases? In our example, we have a 20GB database and it takes 2 hrs to load from a pg_dump file. my

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Jim C. Nasby
On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote: Hi everybody! I ask you for your help on a problem I have. I have a postgresql 7.4 running on a dual 4 GB RAM server, but I have some VERY memory intense queries, that put processor up to 40%. I see Note that you're likely to see

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 16:08, Jim C. Nasby wrote: On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote: Hi everybody! I ask you for your help on a problem I have. I have a postgresql 7.4 running on a dual 4 GB RAM server, but I have some VERY

Re: [GENERAL] Strange behavior on non-existent field in subselect?

2006-10-18 Thread Ken Tanzer
Thanks for the response Ragnar. I would have expected this query to fail, since the sub-query doesn't work by itself: SELECT foo_field FROM foo WHERE foo_field IN (SELECT foo_field FROM par); But it obviously doesn't. So does that subselect implicitly read as: IN (SELECT foo_field FROM

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Jim C. Nasby
On Wed, Oct 18, 2006 at 04:27:21PM -0500, Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 16:08, Jim C. Nasby wrote: On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote: Hi everybody! I ask you for your help on a problem I have. I have a

Re: [HACKERS] [GENERAL] query log corrupted-looking entries

2006-10-18 Thread Alvaro Herrera
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: Should work fine on Windows. fileno() is deprecated however, with the following comment: C:\Program Files\Microsoft Visual Studio 8\VC\INCLUDE\stdio.h(688) : see declaration of 'fileno' Message: 'The POSIX name

Re: [HACKERS] [GENERAL] query log corrupted-looking entries

2006-10-18 Thread Magnus Hagander
Should work fine on Windows. fileno() is deprecated however, with the following comment: C:\Program Files\Microsoft Visual Studio 8\VC\INCLUDE\stdio.h(688) : see declaration of 'fileno' Message: 'The POSIX name for this item is deprecated. Instead, use the

[GENERAL] UDF and cache

2006-10-18 Thread jungmin shin
Hello all, I read a paper, which is Query optimization in the presence of Foreign Functions. And the paper , there is a paragraph like below. In order to reduce the number of invocations, caching the results of invocation was suggested in Postgres. I'd like to know in detail about how postgres

Re: [GENERAL] [HACKERS] UDF and cache

2006-10-18 Thread Jim C. Nasby
On Wed, Oct 18, 2006 at 05:15:13PM -0400, jungmin shin wrote: Hello all, I read a paper, which is Query optimization in the presence of Foreign Functions. And the paper , there is a paragraph like below. In order to reduce the number of invocations, caching the results of invocation

Re: [GENERAL] UDF and cache

2006-10-18 Thread Jim C. Nasby
And PLEASE do not post something to 3 lists; it's a lot of extra traffic for no reason. Moving to -hackers. On Wed, Oct 18, 2006 at 05:15:13PM -0400, jungmin shin wrote: Hello all, I read a paper, which is Query optimization in the presence of Foreign Functions. And the paper , there is a

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 17:22, Jim C. Nasby wrote: On Wed, Oct 18, 2006 at 04:27:21PM -0500, Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 16:08, Jim C. Nasby wrote: On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu

[GENERAL] Link error: LNK2019: unresolved external symbol _pg_detoast_datum

2006-10-18 Thread Ale Raza
Hi, I want to add a user defined function using Version-1 Calling Conventions but getting a link error. I am using MS Visual C++ .NET (V 7.1.3) on Win XP SP 2. PostgreSQL 8.1.3. Am I missing some lib or some other file? I saw earlier thread building and linking C user defined

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Jim C. Nasby
On Wed, Oct 18, 2006 at 05:42:22PM -0500, Ron Johnson wrote: In any case, you'll be much, much happier if you do this project on at least 8.1.x, as 7.4 is pretty long in the tooth. Due to Red Hat's support requirements it will probably remain supported for a few more years by Tom/the

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 17:56, Jim C. Nasby wrote: On Wed, Oct 18, 2006 at 05:42:22PM -0500, Ron Johnson wrote: In any case, you'll be much, much happier if you do this project on at least 8.1.x, as 7.4 is pretty long in the tooth. Due to Red Hat's support

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Tom Lane
Ron Johnson [EMAIL PROTECTED] writes: We'll be using RHES4, I guess, so if it uses 7.4, then I'll have to convince the SysAdmin to install 8.1 or 8.2. plug Red Hat is now selling an Application Stack addon for RHEL4 that provides Postgres 8.1.x, as well as more modern versions of some other

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 18:08, Tom Lane wrote: Ron Johnson [EMAIL PROTECTED] writes: We'll be using RHES4, I guess, so if it uses 7.4, then I'll have to convince the SysAdmin to install 8.1 or 8.2. plug Red Hat is now selling an Application Stack addon for

Re: [GENERAL] Link error: LNK2019: unresolved external symbol _pg_detoast_datum

2006-10-18 Thread Taras Kopets
Hi! You can compile it with MinGW - www.mingw.org. My test function was just a simple one for writing text to file:=== FILE =#include "postgres.h"#include string.h#include "fmgr.h"#include "utils/builtins.h"#include "storage/fd.h"

[GENERAL] hardware failure - data recovery

2006-10-18 Thread Rick Gigger
To make a long story short lets just say that I had a bit of a hardware failure recently. If I got an error like this when trying to dump a db from the mangled data directory is it safe to say it's totally hosed or is there some chance of recovery? pg_dump: ERROR: could not open

Re: [GENERAL] hardware failure - data recovery

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 19:57, Rick Gigger wrote: To make a long story short lets just say that I had a bit of a hardware failure recently. If I got an error like this when trying to dump a db from the mangled data directory is it safe to say it's totally

[GENERAL] Newbie needs help with ERROR: could not write to file base/16390/2682: No space left on device

2006-10-18 Thread andrew plata
I am trying to following the instructions at URL below to try to create a database called web_database required for phpPgAdmin. When I try to do this I get the following error:template1=# create database web_database owner web_user; ERROR: could not write to file base/16390/2682: No space left on

Re: [GENERAL] Newbie needs help with ERROR: could not write to file

2006-10-18 Thread Chris
andrew plata wrote: I am trying to following the instructions at URL below to try to create a database called web_database required for phpPgAdmin. When I try to do this I get the following error: template1=# create database web_database owner web_user; ERROR: could not write to file

Re: [GENERAL] Newbie needs help with ERROR: could not write to file

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 20:41, andrew plata wrote: I am trying to following the instructions at URL below to try to create a database called web_database required for phpPgAdmin. When I try to do this I get the following error: template1=# create database

Re: [GENERAL] Is Postgres good for large Applications

2006-10-18 Thread Robert Treat
On Wednesday 18 October 2006 01:47, louis gonzales wrote: Is your server capable? Does it have enough resources to handle many connections? many = ??? 100, 200, 1,000,000,000 are they concurrent users? 'good for large applications' = ??? I'd say, how large your application is

Re: [GENERAL] Any documatation about porting from Oracle to PostgreSQL

2006-10-18 Thread Robert Treat
On Tuesday 17 October 2006 05:36, A. Kretschmer wrote: am Tue, dem 17.10.2006, um 10:44:52 +0200 mailte Thomas Kellerer folgendes: On 17.10.2006 10:36 Andreas Kretschmer wrote: http://techdocs.postgresql.org/#convertfrom I just noticed that the link Porting from Oracle PL/SQL still

Re: [GENERAL] Is Postgres good for large Applications

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 20:47, Robert Treat wrote: On Wednesday 18 October 2006 01:47, louis gonzales wrote: Is your server capable? Does it have enough resources to handle many connections? many = ??? 100, 200, 1,000,000,000 are they concurrent

Re: [GENERAL] hardware failure - data recovery

2006-10-18 Thread Rick Gigger
Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 19:57, Rick Gigger wrote: To make a long story short lets just say that I had a bit of a hardware failure recently. If I got an error like this when trying to dump a db from the mangled data directory is it safe to

Re: [GENERAL] hardware failure - data recovery

2006-10-18 Thread Rick Gigger
Rick Gigger wrote: Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 19:57, Rick Gigger wrote: To make a long story short lets just say that I had a bit of a hardware failure recently. If I got an error like this when trying to dump a db from the mangled data

[GENERAL] Is it possible to port from Postgres to Versant

2006-10-18 Thread Sandeep Kumar Jakkaraju
Is it possible to port from Postgres tables to Versant - sandeep

Re: [GENERAL] hardware failure - data recovery

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 23:52, Rick Gigger wrote: Rick Gigger wrote: Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 19:57, Rick Gigger wrote: To make a long story short lets just say that I had a bit of a hardware failure

Re: [GENERAL] Is it possible to port from Postgres to Versant

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 23:58, Sandeep Kumar Jakkaraju wrote: Is it possible to port from Postgres tables to Versant Anything is possible, given enough time, money. Your design skills plus the complexity of the objects and current schema design will determine

Re: [GENERAL] hardware failure - data recovery

2006-10-18 Thread Rick Gigger
Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 23:52, Rick Gigger wrote: Rick Gigger wrote: Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 19:57, Rick Gigger wrote: To make a long story short lets just say that I had a bit of a

Re: [GENERAL] hardware failure - data recovery

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/19/06 00:46, Rick Gigger wrote: Ron Johnson wrote: On 10/18/06 23:52, Rick Gigger wrote: Rick Gigger wrote: Ron Johnson wrote: On 10/18/06 19:57, Rick Gigger wrote: [snip] Not much that is useful. I think this is a little beyond that