On Fri, 7 Sep 2007, Ron Johnson wrote:
Definitely a niche product.
Stonebraker's commentary was unfortunately spun by the ComputerWorld
columnist. I hope people followed the link to his actual blog entry at
http://www.databasecolumn.com/2007/09/one-size-fits-all.html where his
arguement
I'm confused as to the difference between dblink and dbi-link.
dblink is included in the contrib directory and dbi-link is available
from pgfoundry.
dblink seems like it creates a view of a remote DB and is static, which
means that it needs to be refreshed each time.
dbi-link seems like it
Hi,
The way postgres has the concept of host base authentication, is this a step
forward over other RDBMS like sql server and oracle?
I was wondering, what are some novel security features in postgres as
compared to other RDBMS.
Thanks,
Jas
On 07.09.2007 10:16, Denis Gasparin wrote:
What to do you think about this?
I think there is no need for this and it's the wrong place to implement it.
Why should PostgreSQL do something to work around broken application
design? An application that closes its database connection just to
2007/9/5, Raj A [EMAIL PROTECTED]:
correction:
The result I'm expecting for the above to be
notification_time| finished_time | actual
++-
2007-07-06 15:50:00+10 | 2007-07-09 07:10:00+10 | 01:20:00
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/07/07 02:49, Ow Mun Heng wrote:
On Fri, 2007-09-07 at 00:18 -0500, Ron Johnson wrote:
On 09/06/07 21:26, Ow Mun Heng wrote:
I've not arrived at any conclusion but merely
exploring my options on which way would be the best to thread. I'm
What is the best way to store clob data in postgresql?
Currently I store my clob data as a text. The data consists of large xml files.
When I access the text field using getString method in jdbc, the program is not
able to hold a huge string in memory .If I can stream this data to and from
On 9/7/07, Ron Johnson [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
On 09/06/07 20:53, Merlin Moncure wrote:
[snip]
arrays are interesting and have some useful problems. however, we
must first discuss the problems...first and foremost if you need to
read any particular
Usual text hasn't strict syntax rules, so parser tries to recognize most
probable token. Something with '.', '-' and alnum characters is often a
filename, but filename is very rare finished or started by dot.
RC Gobeille wrote:
Thanks and I didn't know about ts_debug, so thanks for that
Hi, All
I have following case insensitivity problem with regular expressions:
pgdb:~ # locale |grep LC_CTYPE
LC_CTYPE=ru_RU.UTF-8
pgdb:~ # /opt/PostgreSQL/bin/psql -d test -U postgres
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h
On 9/7/07, Ron Johnson [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/06/07 20:53, Merlin Moncure wrote:
[snip]
arrays are interesting and have some useful problems. however, we
must first discuss the problems...first and foremost if you need to
read any
Christian Schröder [EMAIL PROTECTED] writes:
...
- Seq Scan on table2 (cost=0.00..186.64 rows=2 width=4) (actual
time=0.052..2.259 rows=42 loops=1)
Filter: (c ~~ '1131%'::text)
...
- Seq Scan on table2 (cost=0.00..200.89 rows=14 width=4) (actual
time=0.084..3.419 rows=42 loops=1)
A. Kretschmer wrote:
am Fri, dem 07.09.2007, um 12:30:06 +0200 mailte Erwin Moller folgendes:
Hi group,
Does anybody know of an tutorial for EXPLAIN for idiots like me?
(I am fairly confortable with Postgres, but never used EXPLAIN before.)
I need to optimize a few slow running queries,
Could you please give me the correct syntax to create a basetype using
pl/pgsql functions instead of external functions?
Or is this impossible?
Thanks.
Martijn van Oosterhout schreef:
On Fri, Sep 07, 2007 at 11:36:23AM +0200, M. van Egmond wrote:
Hello everybody,
Im having troubles
On Fri, 07 Sep 2007 10:58:36 +0400, Marko Kreen [EMAIL PROTECTED] wrote:
The pgpool (I tried 3.1, 3.4 and pgpool-II 1.2) works fine but has the
following problem - after some time it
just hangs, and if I try to connect to it with psql it just hangs
indefinitely. After restart
it works fine
Hi, All
I have following case insensitivity problem with regular expressions:
pgdb:~ # locale |grep LC_CTYPE
LC_CTYPE=ru_RU.UTF-8
pgdb:~ # /opt/PostgreSQL/bin/psql -d test -U postgres
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h
Hi group,
Does anybody know of an tutorial for EXPLAIN for idiots like me?
(I am fairly confortable with Postgres, but never used EXPLAIN before.)
I need to optimize a few slow running queries, but I am not really
getting it when reading:
On Fri, Sep 07, 2007 at 11:36:23AM +0200, M. van Egmond wrote:
Hello everybody,
Im having troubles overriding postgresql's default behaviour of throwing
an error while trying to cast an empty string to int4. I would like to
cast empty strings to a null integer value. I've tried this by
Datahouse or data warehouse?
OLTP data warehouse.
Panagiotis Pediaditis wrote:
Greetings,
I am debugging a large application that is based on transactions
of long series of complex SQL queries. I was wondering, is there a way
to monitor tables changed by the transaction before the transaction
actually commits? Otherwise debugging
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/07/07 07:49, Merlin Moncure wrote:
On 9/7/07, Ron Johnson [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/06/07 20:53, Merlin Moncure wrote:
[snip]
arrays are interesting and have some useful problems.
Greetings,
I am debugging a large application that is based on transactions
of long series of complex SQL queries. I was wondering, is there a way
to monitor tables changed by the transaction before the transaction
actually commits? Otherwise debugging seems impossible.
Thank you,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/07/07 01:37, Greg Smith wrote:
On Fri, 7 Sep 2007, Ron Johnson wrote:
Definitely a niche product.
Stonebraker's commentary was unfortunately spun by the ComputerWorld
columnist.
Tech journalist morphing reality to make a provocative
In response to Jasbinder Singh Bali [EMAIL PROTECTED]:
Hi,
The way postgres has the concept of host base authentication, is this a step
forward over other RDBMS like sql server and oracle?
Host-based auth has been around a long time. It's just another layer.
Some folks even consider HBA
Relational database pioneer says technology is obsolete
The headline is grossly misleading; the article is only somewhat less
misleading. The actual blog entry:
- Does not claim that relational databases per se are obsolete;
- Claims that the idea of a single one size fits all implementation
It means that measuring alters the reality.
Heisenberg would agree!
---(end of broadcast)---
TIP 6: explain analyze is your friend
Carlo Stonebanks wrote:
Actually it's quite possible that
that extra overhead in nested loop is largely gettimeofday() calls for the
explain analyze. Does the query take less time run without explain analyze
than it does run with it?
Do you mean that an EXPLAIN ANALYZE that runs longer than
Im newbie with postgresql i want to know how to create a stored
procedure that retrieve records something like
SELECT * FROM TABLE1 WHERE TABLE1.ID = 'PARAMETER'
appreciate any help, links etc...
thanks
Germán Fonseca P.
---(end of
Zoltan Boszormenyi [EMAIL PROTECTED] writes:
Tom Lane =EDrta:
Zoltan Boszormenyi [EMAIL PROTECTED] writes:
At the end of the day, the behaviour is the same, isn't it?
No, there's a difference in terms of the priority for pushing this
column out to toast storage, versus pushing other columns
On Fri, Sep 07, 2007 at 12:30:06PM +0200, Erwin Moller wrote:
Any tips/sites?
check this:
http://www.postgresql.org/communityfiles/13.sxi
depesz
--
quicksil1er: postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV! :)
http://www.depesz.com/ - blog dla ciebie (i
Hi,
Denis Gasparin wrote:
Why not to implement a connection pooling server side as apache for
example does?
This has certainly been discussed before.
IIRC the real argument against that was, that fork() isn't the most
expensive thing to do anymore. And Postgres does lots of other stuff
You'll want to evaluate pgBouncer to see if it meets your needs. It
works very well for general proxying, connection pooling.
On 9/7/07, Denis Gasparin [EMAIL PROTECTED] wrote:
I'm looking for connection pooling solutions for our php/apache server.
I already checked pgpool and pgbouncer but
Hi list,
if you please have a look at the following query:
SELECT DISTINCT a FROM table1
INNER JOIN table2 USING (b)
INNER JOIN view1 USING (a)
WHERE c like '1131%'
AND d IS NOT NULL
AND e IS NOT NULL;
Unfortunately, I have not been able to construct a suitable test case,
so I had to take the
Actually it's quite possible that
that extra overhead in nested loop is largely gettimeofday() calls for the
explain analyze. Does the query take less time run without explain analyze
than it does run with it?
Do you mean that an EXPLAIN ANALYZE that runs longer than the actual query
is a
Hi Gurus,
I have two disjoint tables, for examples, of user lists.
Some users appear both tables. They may or may not have the same u_id.
Some users only appear one table.
I would like to merge tableB into tableA with the condition that each
user has a unique id.
Also I would like to keep
Hello everybody,
Im having troubles overriding postgresql's default behaviour of throwing
an error while trying to cast an empty string to int4. I would like to
cast empty strings to a null integer value. I've tried this by creating
my own domain:
CREATE DOMAIN my_int AS integer;
-- Then
On Fri, 2007-09-07 at 10:16 +0200, Albe Laurenz wrote:
Ow Mun Heng wrote:
True, you'll have to write some stuff that does something like:
- pull the data over from the other database
- replace the data in the local table
Already doing that currently for some data tables/
Since it is between
Andreas Tille wrote:
On Wed, 5 Sep 2007, Andreas Tille wrote:
On Mon, 4 Sep 2007, Albe Laurenz wrote:
The best list for this kind of thing is certainly the Npgsql
mailing list:
http://gborg.postgresql.org/mailman/listinfo/npgsql-general
Just subscribed.
Well, I looked at the archives of
Ow Mun Heng wrote:
In either of the above, I would like to know which one
is able to help me to like connect to a remote DB, use the
table there and join to a local table in PG so that I
don't have to use DBI to pull and insert those data into
the local PG database.
Neither. To the best of
I'm looking for connection pooling solutions for our php/apache server.
I already checked pgpool and pgbouncer but during the tests, I had the
following (mad) idea...
Why not to implement a connection pooling server side as apache for
example does?
I try to explain my idea...
The postgres
On Fri, 2007-09-07 at 00:18 -0500, Ron Johnson wrote:
On 09/06/07 21:26, Ow Mun Heng wrote:
I've not arrived at any conclusion but merely
exploring my options on which way would be the best to thread. I'm
asking the list because I'm new in PG and after reading all those
articles on
Zoltan Boszormenyi [EMAIL PROTECTED] writes:
At the end of the day, the behaviour is the same, isn't it?
No, there's a difference in terms of the priority for pushing this
column out to toast storage, versus pushing other columns of the row
out to toast. Normally we push the widest (remaining)
On 9/7/07, genesis [EMAIL PROTECTED] wrote:
appreciate any help, links etc...
See:
http://www.postgresql.org/docs/8.2/static/xfunc-sql.html#AEN36437
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On 9/7/07, Max Zorloff [EMAIL PROTECTED] wrote:
On Fri, 07 Sep 2007 10:58:36 +0400, Marko Kreen [EMAIL PROTECTED] wrote:
The pgpool (I tried 3.1, 3.4 and pgpool-II 1.2) works fine but has the
following problem - after some time it
just hangs, and if I try to connect to it with psql it just
On 9/7/07, Chansup Byun [EMAIL PROTECTED] wrote:
Can someone show me an example SQL statement?
I suppose you could add a constant, non-overlapping number to add to
the duplicate IDs, say 1000, and then this:
SELECT COALESCE(T1.U_USER, T2.U_USER) AS U_USER
, COALESCE(CASE
Hello everybody,
Im having troubles overriding postgresql's default behaviour of throwing
an error while trying to cast an empty string to int4. I would like to
cast empty strings to a null integer value. I've tried this by creating
my own domain:
CREATE DOMAIN my_int AS integer;
-- Then
Ow Mun Heng wrote:
Since it is between PostgreSQL databases,
actually, it'll be against SQL Servers
Oh, ok, then you will have to use DBI-Link.
dblink is not an option since it only connects to PostgreSQL databases.
Yours,
Laurenz Albe
---(end of
On Wed, 5 Sep 2007, Andreas Tille wrote:
On Mon, 4 Sep 2007, Albe Laurenz wrote:
The best list for this kind of thing is certainly the Npgsql
mailing list:
http://gborg.postgresql.org/mailman/listinfo/npgsql-general
Just subscribed.
Well, I looked at the archives of this list and also at
Tom Lane írta:
Zoltan Boszormenyi [EMAIL PROTECTED] writes:
At the end of the day, the behaviour is the same, isn't it?
No, there's a difference in terms of the priority for pushing this
column out to toast storage, versus pushing other columns of the row
out to toast. Normally we
On Fri, Sep 07, 2007 at 01:40:57PM +0200, M. van Egmond wrote:
Could you please give me the correct syntax to create a basetype using
pl/pgsql functions instead of external functions?
Or is this impossible?
It's not possible. You need to be able to deal with raw C strings and
internal
am Fri, dem 07.09.2007, um 12:30:06 +0200 mailte Erwin Moller folgendes:
Hi group,
Does anybody know of an tutorial for EXPLAIN for idiots like me?
(I am fairly confortable with Postgres, but never used EXPLAIN before.)
I need to optimize a few slow running queries, but I am not really
Greg Smith wrote:
the idea of one database approach always being right
just isn't true anyway.
Or one software development approach or one application runtime approach
or ... . One of the major contributions of the relational model
compared to the myriad network model implementations
Hi,
according to
http://www.postgresql.org/docs/8.2/interactive/storage-toast.html:
EXTENDED allows both compression and out-of-line storage.
This is the default for most TOAST-able data types.
Compression will be attempted first, then out-of-line storage if the row
is still too big.
MAIN
On 9/6/07, Max Zorloff [EMAIL PROTECTED] wrote:
Hello. I'm using Apache + PHP + Postgres for my project. I've tried the
two poolers people
usually recommend here - pgbouncer and pgpool.
I have a problem with pgbouncer - under the load the query execution
becomes ~10 times slower
than it
Ow Mun Heng wrote:
On Thu, 2007-09-06 at 20:19 -0700, Joe Conway wrote:
An alternative way to get the output below, would be to feed your
aggregate query above to the crosstab() function in contrib/tablefunc.
I just looked at it and seems like the
...
row_name and value must be of type
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/07/07 09:00, Ow Mun Heng wrote:
Datahouse or data warehouse?
OLTP data warehouse.
But OLTP DW are diametrically opposed in how you design,
structure, load and use them.
- --
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he
Rodrigo De León wrote:
On 9/7/07, Chansup Byun [EMAIL PROTECTED] wrote:
Can someone show me an example SQL statement?
I suppose you could add a constant, non-overlapping number to add to
the duplicate IDs, say 1000, and then this:
SELECT COALESCE(T1.U_USER, T2.U_USER) AS U_USER
Siah wrote:
fillfactor affects 'update' statements or also has affects for
'insert' and 'delete'?
I would say: fillfactor modifies the behaviour of INSERT and
has effects for UPDATE.
When you choose fillfactor less than the default 100, INSERT
will not fill the pages completely. This will slow
On 9/7/07, Chansup Byun [EMAIL PROTECTED] wrote:
One more question: Is there a way to make the T2.U_ID + 1000 number to be
incremental from a given number instead of adding 1000?
See here:
http://archives.postgresql.org/pgsql-sql/2007-05/msg00194.php
Then, say we want to start from 49:
Where is the definitive source for all things autovacuuming? I have
seen http://www.postgresql.org/docs/8.1/static/maintenance.html#AUTOVACUUM.
Ultimately the issue I am having is that the postgresql logs show each
of the databases being 'autovacuumed' (actually quite often), but when
I click
Collin Peters escribió:
Where is the definitive source for all things autovacuuming? I have
seen http://www.postgresql.org/docs/8.1/static/maintenance.html#AUTOVACUUM.
The source code ;-)
Ultimately the issue I am having is that the postgresql logs show each
of the databases being
I have a function that returns a set of a custom type...
trax=# \d client_search
Composite type public.client_search
Column | Type
+
clientno | bigint
client | character varying(100)
contactno | bigint
Here is a problem I'm having with a function I've created. It should be
returning a varchar value no matter what the input is but I'm getting a null
value back. Then it says in the error that I'm using nonstandard use of
escape in a string literal at character 9. What do you think this should be
On 9/7/07, Carlo Stonebanks [EMAIL PROTECTED] wrote:
It means that measuring alters the reality.
Heisenberg would agree!
I'm not entirely sure what Schrödinger would think about it.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Robert Fitzpatrick [EMAIL PROTECTED] writes:
Indexes:
tblsearch_selections_pkey PRIMARY KEY, btree (search_selection_id)
search_selection_unique_idx UNIQUE, btree (search_id, user_id,
selection_value, selection_type)
SELECT *
FROM client_search_id_func(62)
LEFT JOIN
On 9/7/07, SHARMILA JOTHIRAJAH [EMAIL PROTECTED] wrote:
What is the best way to store clob data in postgresql?
Currently I store my clob data as a text. The data consists of large xml
files. When I access the text field using getString method in jdbc, the
program is not able to hold a huge
Robert Fitzpatrick [EMAIL PROTECTED] writes:
trax=# explain analyze select * from client_search_id_func(62) left join
tblsearch_selections ON search_id = 62 and user_id = 'RF' and
((selected_value = clientno and selection_type = 'client') or (selected_value
= contactno and selection_type =
On 9/8/07, Scott Marlowe [EMAIL PROTECTED] wrote:
Heisenberg would agree!
I'm not entirely sure what Schrödinger would think about it.
He'd kill Heisenberg's cat?
---(end of broadcast)---
TIP 4: Have you searched our list archives?
I'm not entirely sure what Schrödinger would think about it.
I know what the cat thinks:
What do you mean 'no observer'? What the #*! am I??? LET ME OUT!
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi, a friend of mine on Windows, is attempting to convert to using
PostgreSQL (and of course, I'm helping him).
The installation gave an option to run as an application, rather than as
a service.
Turns out, my friends login account has Admin privs, and postgres.exe
will not run in an account
70 matches
Mail list logo