using the OCI driver and point it to a PostgreSQL
database, that's not going to happen, as the communications protocols
are totally different.
-- Guy Rouillier
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Ragnar HafstaĆ° wrote:
> On Tue, 2005-03-08 at 16:30 -0600, Guy Rouillier wrote:
>> We use a dynamic statement in a pgsql stored function to insert rows
>> into a table determined at run time. After much debugging, I've
>> discovered that a null incoming argum
ery few dependencies. So you might want to consider that
alternative. You'll lose Gentoo's management of the PG installation,
but I don't find that a major issue.
--
Guy Rouillier
---(end of broadcast)---
TIP 1: subscribe an
check_null(inval) ||
' ) ';
execute sqlstmt;
return;
END;
$$ LANGUAGE plpgsql;
--
Guy Rouillier
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an app
t it says: it wants an NTFS logical partition to
install on. Apparently your XP Home uses a FAT32 partition, probably
because you upgraded from Win9x. You should have an accessory to
convert to NTFS.
--
Guy Rouillier
---(end of broadcast)---
TIP 3
your list of listen_addresses in postgresql.conf.
--
Guy Rouillier
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
cle exported dates like this: "9/14/2004 6:40:21 PM". PG took 'em
right in with no special instructions, and produced the correct
timestamp. Hats off to the PG developers! Thanks for all your work.
--
Guy Rouillier
---(end of broadcast)
Title: Message
The
RAISE statement requires a % marker for each variable you want to include in the
output text.
--Guy Rouillier
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Rick CaseySent: Thursday, February 24, 2005
5:51 PMTo: pgsql
ograms to talk with PostgreSQL? See section 27.15. Building libpq
Programs. Seems pretty clearly laid out there.
--
Guy Rouillier
---(end of broadcast)---
TIP 8: explain analyze is your friend
;> ^ ^^^
>> Those aren't going to help, are they?
>>
>> --
>>Richard Huxton
>>Archonet Ltd
>>
--
Guy Rouillier
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Tom and Stephan, thank you both for taking the time to reply. Further
comments inline.
Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
>> On Fri, 11 Feb 2005, Guy Rouillier wrote:
>>> Now I create a view like this:
>>> create or replace view v1 as s
ng
any n to n+1 union transition is also allowed.)
Is this intentional? It was certainly not predictable.
--
Guy Rouillier
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
d benchmark numbers, but AMD claims about a 15% general performance
improvement switching from 32-bit to 64-bit.
--
Guy Rouillier
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail com
discontinuing it.
--
Guy Rouillier
---(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
qual.
On AMD64, gcc produced: int 4 long 8 pointer 8
--
Guy Rouillier
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
e PG
dblink mechanism is pretty generic.
>
>
> And finally, do you know a good comparison chart or benchmark between
> these two databases? A Brazilian university teacher made one
> (http://www.ic.unicamp.br/~celio/livrobd/docs/benchmark.html) but I'd
> like to see other
u need to join the two tables, you can even do
that with the dblink add-on.
Finally, if you are using Java, ObjectWeb has a RAIDb driver that can
transparently distribute databases over a cluster of servers. See
http://c-jdbc.objectweb.org/.
--
Guy Rouillier
--
eiser, I gave up and
installed Gentoo.
--
Guy Rouillier
---(end of broadcast)---
TIP 8: explain analyze is your friend
ates).
Thanks, Tom. This app has very high insert activity. What's the best
way to minimize the effect of WAL given that we don't have separate
disks to put it on in our test environment?
--
Guy Rouillier
---(end of broadcast)
disks for WAL in our test environment,
I'd like to minimize the effect of WAL. I've read the sections in both
the tuning guide and the base documentation, and I'm still a little
unclear about fsync and wal_sync_method. If I set fsync FALSE, does
this disable WAL ent
rely,
> Doug Greer
We're getting about 64 million rows inserted in about 1.5 hrs into a
table with a multiple-column primary key - that's the only index.
That's seems pretty good to me - SQL Loader takes about 4 hrs to do the
same job.
--
Guy Rouillier
--
ly. Quick and easy, just turn on debug for the
connections. If you want something more customized, every connection
has a unique object reference; you can just print it out in the log.
--
Guy Rouillier
---(end of broadcast)---
TIP 8: explain analyze is your friend
ust authentication, but the
PostgreSQL documentation recommends against general use of trust
authentication (and I agree with that recommendation in a production
environment.)
As described in other messages in this thread, putting a scheduler in
the database would all
ordinate work by multiple systems.
--
Guy Rouillier
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
to get rows from it. For a non-destructive
operation (i.e., select), you may be better off just doing the select,
and watching for a "table does not exist" error.
--
Guy Rouillier
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
mming
languages and other DMBSs) I would certainly vote for allowing elseif.
This is my first encounter of "else" without the terminating "e", and
that would not be a natural omission for me.
--
Guy Rouillier
---(end of broadcast)---
ensome (lots
of triggers.)
--
Guy Rouillier
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
nning on host 127.0.0.1 and accepting TCP/IP
> connections on port 5432.
What operating system are you running? Are you running with the stock
postgresql.conf and pg_hba.conf files? How did you configure the
connection in PgAdmin III?
--
Guy Rouillier
--
s (80 MB)
provides little or no improvement. Where should we start?
(3) If we go with more disks, should we attempt to split tables and
indexes onto different drives (i.e., tablespaces), or just put all the
disks in hardware RAID5 and use a single tablespace?
I appreciate all suggestions.
--
Guy R
mas into separate DBs. Also, 8.0 has
an auto-vacuum daemon that is supposed to lighten the load incurred by
vacuum by checking frequently in the background.
--
Guy Rouillier
---(end of broadcast)---
TIP 6: Have you searched our list ar
ach connection was serviced by a single, non-threaded process.
Have I interpreted this incorrectly? Are you saying that the backend
process actually is multi-threaded? In the example you site, multiple
sorts could be accomplished serially in a non-threaded process.
--
Guy Rouillier
--
e_min_stats_200408; QUERY PLAN
>>
>> --------
>>
>> Time: 1284213.359 ms
--
Guy Rouillier
---(end of broadcast)---
TIP 2:
)
Sort Key: service_id
-> Seq Scan on five_min_stats_200408 (cost=0.00..1668170.12
rows=63309612 width=12) (actual time=0.061..80398.222 rows=63359396
loops=1)
Total runtime: 1284212.556 ms
(5 rows)
Time: 1284213.359 ms
--
Guy Rouillier
---(end of broadcast
ablespace name does not appear to be associated with
the table in the system catalog? Perhaps the tablespace name is not
recorded if it is the default TS?
--
Guy Rouillier
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unr
XXts to ", then (1)
works. Even then, \d+ and pg_class still show no tablespace for this
table. (1) and (2) look the same in the system catalog tables (and in
the views in PgAdmin III.)
--
Guy Rouillier
---(end of broadcast)---
Bruno Wolff III wrote:
> On Fri, Mar 26, 2004 at 11:53:47 -0600,
> Guy Rouillier <[EMAIL PROTECTED]> wrote:
>>
>> I saw in the referenced sequence of posts that PostgreSQL will close
>> a file for a table once it reaches 1 GB, and start a new file. So
>&g
n multiple files for a
single table. Is there any way for me to control that, so I can get
PostgreSQL to start a new file on the 1st of each month? Or is this
planned for tablespaces, which I also saw discussed.
Thanks.
--
Guy Rouillier
---(end of
201 - 237 of 237 matches
Mail list logo