[GENERAL] OSX, ODBC and Office 2004

Hi, does this work in any way (PG 7.4.7 and OSX 10.3), so I can access postgres as data source from say excel? Konstantin -- Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185

[GENERAL] ERROR: Tuple is too big: size 15880, max size 8140

Hi, I have a table with just one column of type varchar which gives me from time to time (I guess when data is bigger then 8140 bytes) this message. select version() says: PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 Besides Upgrading to 7.1 somebody has an idea about

[GENERAL] Yet another Performance Question

Hi, I once read in Oracle Performance Tuning, that if one inserts or changes large amounts of data in a table, it might be better to drop indices before doing this and recreating them afterwards. Could someone give a hint on how this is in Postgres 7.1? Currently I am experiencing a massive

Re: [GENERAL] Yet another Performance Question

On Wed, Apr 18, 2001 at 07:18:40AM -0500, Len Morgan wrote: I once read in Oracle Performance Tuning, that if one inserts or changes large amounts of data in a table, it might be better to drop indices before doing this and recreating them afterwards. Could someone give a hint on how this is

Re: [GENERAL] Yet another Performance Question

before it inserts... Konstantin Regards, Patrik Kudo -- ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol Knns det oklart? Frga p! On Wed, 18 Apr 2001, Konstantinos Agouros wrote: Frankly what matters is the time it takes alltogether. I have a script that first

Re: [GENERAL] Yet another Performance Question

In [EMAIL PROTECTED] [EMAIL PROTECTED] writes: Have you tried running PostGres with the -F option so that disk flushes are not performed every time. Maybe this will make a difference to insert performance. In the DBI-connect I still have a -F in the options, but now I am running 7.1RC2 (didn't

[GENERAL] 7.1RC2-7.1 Final dump/restore needed?

Hi, I have one machine running 7.1RC2, that I now want to upgrade to 7.1final. I guess I don't need a dump restore then? Konstantin -- Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: [EMAIL PROTECTED] Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185

[GENERAL] Performance-Problem

Hi, I had the following problem: I have a table with around 5Mio entries. I joined this table with a table with about 50 entries. Doing a insert into another_table my select-statement. I am sure the select-statement might be optimized but after 6 days of running I had to reboot the machine for

[GENERAL] -F and perl again

Hi, in regards to my former question about using -F from perl, would the following be the correct line to do it? $dbh = DBI-connect("dbi:Pg:dbname=logs;options=-F"); -- Konstantin Agouros - NetAge Solutions, Dingolfinger Str. 6, 81673 Muenchen Tel.: 089 666584-0, Fax: 089 666584-11, Email:

[GENERAL] How to use postgres 7.0.3 with -F?

Hi, someone gave me the tip to use the -F-flag to improve performance. Since I can't run the postmaster with -F but just postgres how do I do it, if I want to import a big amount of data? Konstantin -- Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: [EMAIL PROTECTED] Otkerstr. 28,

Re: [GENERAL] How to use postgres 7.0.3 with -F?

In [EMAIL PROTECTED] [EMAIL PROTECTED] (Tom Lane) writes: [EMAIL PROTECTED] (Konstantinos Agouros) writes: someone gave me the tip to use the -F-flag to improve performance. Since I can't run the postmaster with -F but just postgres how do I do it, if I want to import a big amount of data

[GENERAL] Is Oracle really so much faster

Hi, today I did my first test with Oracle instead of PG (I had to really the boss wanted it \:). I have some perl-scripts using DBI, that insert a large amount of data, reduce it and then create some report. When I insert I do something like $dbh-{'AutoCommit'} = 0 and every 100,000 entries or

[GENERAL] Postgres-Book from addison-wesley?

Hi, when I looked at the database-section of my bookstore browsing for the Practi- cal SQL Handbook I found a book on postgres from Addison Wesley. Is that one any good (I didn't have the time to look into it). Konstantin -- Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: [EMAIL

[GENERAL] stupid select question...

Hi, my sql has gotten a little rusty, here's what I want to do: I have two tables both contain urls. How what I want are all the entries in table b where there is no matching url in table a. I do remember doing something like this with a select url from table1 where a.url not in select url