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
crea
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 |
-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.
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
the
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
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 also.
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 fo
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 t
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
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, bu
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 overri
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 a
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 f
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:
http://www.postgresql.org/docs/8.1/interactive/performa
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 c
>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 seems
-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 pr
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 provocati
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
> 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:
> < 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
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 broadcast)--
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 pushin
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
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
afte
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 b
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 q
<
Do you mean that an EXPLAIN ANALYZE that runs longer than the actual query
is a symptom of time being lost to a function call?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/
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 u_id
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 cr
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 bet
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 t
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.
>>
>> Neithe
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 serve
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 wit
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 create
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 broadcast)-
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 p
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 datat
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 real
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 prevale
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
> tha
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 text
-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, a
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 slo
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 aro
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 'autov
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
c
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
"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
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 hug
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_ty
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 with
66 matches
Mail list logo