On Tue, 23 May 2006, Joel Alejandro Espinosa Carra wrote:
I searched at google and did not find any answer. I have an older JDCB driver
in my java web application, if I update the driver to the 7.4 build 216
version some of the querys like the next show no results in the ResultSet
object:
no partial (or other) index affecting these results. just a trigger the
outcome of which was affected by the value of that particular boolean.
sorry, should have looked more carefully...
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 23, 2006 4:00 PM
"Tony Wasson" <[EMAIL PROTECTED]> writes:
> $.02 about lots of schemas.
> I worked with an application that had 500 schemas and that worked very
> well. However, as the number of schemas exceeeded 8000 the query speed
> started to degrade. Running \d with a single schema in your search
> path took
Hi!
As I said in other messages, I'm planning with a partner of mine to use
inheritance and schemas to separate access and data from several sources
(companies) for a client we have (accounting office).
The idea is:
- 1 base schema with all table definitions plus functions plus views
Em Terça 23 Maio 2006 20:26, Jim C. Nasby escreveu:
> Moving to -general, where it's more likely that others will have input.
Thanks Jim. This wasn't clear to me when I subscribed to the other mailing
list.
> One issue is that you'll probably be breaking new ground here a bit; I
> suspect ther
Em Terça 23 Maio 2006 21:54, Tony Wasson escreveu:
>
> $.02 about lots of schemas.
>
> I worked with an application that had 500 schemas and that worked very
> well. However, as the number of schemas exceeeded 8000 the query speed
> started to degrade. Running \d with a single schema in your search
On 5/23/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> Is this a good idea? Would this be too bad, performance-wise, if I had
> thousands of schemas to use like that? Any advice on better approaches? Any
> expected problems?
One issue is that you'll probably be breaking new ground here a bit;
- Original Message
>From: Jim C. Nasby <[EMAIL PROTECTED]>
>To: Shelby Cain <[EMAIL PROTECTED]>
>Cc: Csaba Nagy <[EMAIL PROTECTED]>; [EMAIL PROTECTED]; Postgres >general
>mailing list ; [EMAIL PROTECTED]
>Sent: Tuesday, May 23, 2006 5:19:58 PM
>Subject: Re: [GENERAL] allow LIMIT in UPDATE
On Tue, May 23, 2006 at 05:00:13PM -0600, Ed L. wrote:
> On Tuesday May 23 2006 4:55 pm, Jim C. Nasby wrote:
> > Well, I did find one reason not to go ape with this: the
> > number of pages analyzed scales with the number of buckets, so
> > doubling the statistics target will roughly double the ANA
Moving to -general, where it's more likely that others will have input.
On Tue, May 23, 2006 at 05:16:54PM -0300, Jorge Godoy wrote:
> I'm modelling an application that will have data -- financial data, human
> resources, etc. -- for several hundred (even thousands) of companies. This
> is for
On Tuesday May 23 2006 4:55 pm, Jim C. Nasby wrote:
> Well, I did find one reason not to go ape with this: the
> number of pages analyzed scales with the number of buckets, so
> doubling the statistics target will roughly double the ANALYZE
> time for any table over 6000 pages (though the effect is
On Thu, May 11, 2006 at 09:39:59AM -0500, Tony Caduto wrote:
> Tom Lane wrote:
> >
> >We have actually removed the "at character N" bit from the default message
> >format in CVS
> >
> Tom,
> What will the error format be for 8.2? Since the char number has been
> removed, what will it show?
>
"George Pavlov" <[EMAIL PROTECTED]> writes:
> Here is something that seems anomalous to me: when I set a boolean field
> to FALSE performance is much better than when I set it to TRUE. Any
> reason for FALSE to be favored over TRUE?
It isn't. You're measuring something else than you think you're
On Tue, May 23, 2006 at 06:18:07PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Mon, May 22, 2006 at 06:43:22PM -0400, Tom Lane wrote:
> >> It would be nice to have some *evidence*, not unsupported handwaving.
>
> > If someone has an idea on how to actually get that e
On Tue, May 23, 2006 at 02:55:03PM -0700, George Pavlov wrote:
> Here is something that seems anomalous to me: when I set a boolean field
> to FALSE performance is much better than when I set it to TRUE. Any
> reason for FALSE to be favored over TRUE?
>
> Some details:
>
> vacuum analyze my_table
Rafal Pietrak wrote:
On Tue, 2006-05-23 at 15:56 +, Chris Browne wrote:
The use that I have for this at the moment, and I can think of many
other uses, is that I want to populate a statistics table each time
that a table is updated. But the code to populate the table takes 10
seconds to run.
On Tue, May 23, 2006 at 06:10:49PM +0200, Frederic Massot wrote:
> Jim C. Nasby wrote:
> >On Tue, May 23, 2006 at 01:03:16PM +0200, Frederic Massot wrote:
> >
> >>Hi,
> >>
> >>We have an old waiter Postgresql 6.5.3 which regularly had problem and
> >>which crashed.
> >
> >
> >6.5?! Holy cow, you wi
On Tue, May 23, 2006 at 09:27:41AM +0200, Petr Bouda wrote:
> Hi all
>
> I'am facing strang problem while using pgAdmin III to browse DB running on
> the same machine (localhost) - it is very very slow. Coonect is quite quict,
> but listing all schemas takes tens of seconds, listing tables in sche
On Tue, May 23, 2006 at 12:16:01AM -0700, everest_sun wrote:
> I have define a type arc,but i do not define the +(arc,arc)
> operator,instead of +(arc,cstring)when i delete the +(arc,cstring),the
> pgadmin3 tells me a error:
> ERROR:operator does not exist:arc+arc
Please provide a test case using
On Mon, May 22, 2006 at 03:49:01PM -0700, Shelby Cain wrote:
> My experience with job queues comes from clients that mostly use Oracle as
> the backend. However, even with Oracle a queue table should be storing
> information about a job and not have records unnecessarily locked simply
> becaus
Sim Zacks wrote:
Is there any way to write a statement trigger that runs in the
background? In my testing, when I have an After Insert For Each
Statement trigger, the function call does not end until the trigger is
finished processing.
What I would like to do, and please let me know if there
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Mon, May 22, 2006 at 06:43:22PM -0400, Tom Lane wrote:
>> It would be nice to have some *evidence*, not unsupported handwaving.
> If someone has an idea on how to actually get that evidence, I'm all
> ears.
Well, for example, actually measuring the
That being said, 10 is fairly small and I often find myself setting the
value to at least 250 just to keep it out of my way.
And ditto (though I normally go for 100).
Have you ever run into problems from setting this too high?
No. Except that it does increase the time it takes to analyze wh
Martijn van Oosterhout wrote:
On Mon, May 22, 2006 at 12:52:33PM -0400, Greg Stark wrote:
"Rafael Martinez, Guerrero" <[EMAIL PROTECTED]> writes:
Why do you think 'intr' is a bad thing, from man pages:
" If an NFS file operation has a major timeout and it is
hard mounted, then allo
Jim C. Nasby wrote:
> On Tue, May 23, 2006 at 10:19:25AM +0200, Csaba Nagy wrote:
> > On Mon, 2006-05-22 at 23:55, Jim C. Nasby wrote:
> > > BTW, there's a bug/issue with CLUSTER that makes it not entirely
> > > transaction safe.
> >
> > For God's sake, don't fix that one ! I rely on it... now ser
On Tue, May 23, 2006 at 10:19:25AM +0200, Csaba Nagy wrote:
> On Mon, 2006-05-22 at 23:55, Jim C. Nasby wrote:
> > BTW, there's a bug/issue with CLUSTER that makes it not entirely
> > transaction safe.
>
> For God's sake, don't fix that one ! I rely on it... now seriously,
> until there's a way to
On Tue, May 23, 2006 at 10:30:35AM +0200, Csaba Nagy wrote:
> On Tue, 2006-05-23 at 00:04, Jim C. Nasby wrote:
> > I can't imagine how bad this would be if the database actually had
> > hour-long reports that had to run... and luckily the system is quiet at
> > night when pg_dump runs.
>
> BTW, pg
Kenneth Downs wrote:
I've gotten a chance to upgrade wxGTK to 2.6.3.2. I can no longer
deliberately reproduce the freezeup caused by a double-click on selected
text in the query analyzer.
Anyone caring about a non-freezable pgadmin in their distro should notify
the vendor of the distro, or th
On Mon, May 22, 2006 at 02:07:50PM -0700, Joshua D. Drake wrote:
> Jim C. Nasby wrote:
> >On Thu, May 18, 2006 at 07:25:09AM +0200, Florian Weimer wrote:
> >>* Joshua D. Drake:
> >>
> >Sounds great! But why GPL? Are you looking to sell licenses?
> GPL is to spread it as far and wide as poss
On Mon, May 22, 2006 at 05:55:16PM -0700, Joshua D. Drake wrote:
>
> >The reason the default is currently 10 is just conservatism: it was
> >already an order of magnitude better than what it replaced (a *single*
> >representative value) and I didn't feel I had the evidence to justify
> >higher val
On Mon, May 22, 2006 at 06:43:22PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Wed, May 17, 2006 at 10:29:14PM -0400, Tom Lane wrote:
> >> The reason the default is currently 10 is just conservatism: it was
> >> already an order of magnitude better than what it replac
On Mon, May 22, 2006 at 01:38:20PM -0700, Nik wrote:
> CREATE TABLE schemaname.partition_table
> (
> CHECK("start" >= '05-01-2006 00:00:00' AND "start" <= '05-31-2006
> 23:59:59'),
What about 5-31-2006 23:59:59.3?
What you really want is:
CHECK("start" >= '05-01-2006' AND "start" < '06-01-20
Here is something that seems anomalous to me: when I set a boolean field
to FALSE performance is much better than when I set it to TRUE. Any
reason for FALSE to be favored over TRUE?
Some details:
vacuum analyze my_table;
update my_table set is_foo=FALSE where some_id = 47;
--142 rows affected, 8
Hi all.
I searched at google and did not find any answer. I have an older JDCB
driver in my java web application, if I update the driver to the 7.4
build 216 version some of the querys like the next show no results in
the ResultSet object:
SELECT a.reg_users_id_user AS id, a.first_name AS fn
On 5/23/06, Rafal Pietrak <[EMAIL PROTECTED]> wrote:
On Tue, 2006-05-23 at 15:56 +, Chris Browne wrote:
> > The use that I have for this at the moment, and I can think of many
> > other uses, is that I want to populate a statistics table each time
> > that a table is updated. But the code to
Yonatan Ben-Nes <[EMAIL PROTECTED]> writes:
> I can't figure out how I can update the box column using the values at
> the nleft & nright columns.
Use the provided constructor functions:
regression=# select box(point(1,2),point(3,4));
box
-
(3,4),(1,2)
(1 row)
As a general rul
On Tue, May 23, 2006 at 07:13:08PM +0200, Yonatan Ben-Nes wrote:
> UPDATE treecategory SET box =
> '('||"nleft"||','||"nright"||'),('||"nleft"||','||"nright"||')';
> ERROR: column "box" is of type box but expression is of type text
> HINT: You will need to rewrite or cast the expression.
>
> An
Rafal Pietrak wrote:
So if I may re-phrase the question: "is there a way to have a trigger,
that, when launched, can check if it's already running in backgroung for
some other INSERT, return imediately if so, but turn into background for
a long-lasting job if not".
Rafal, I'm wondering why y
Thanks Tony
I installed PostgresDAC and it cleared up the problem.
Bob
- Original Message -
From: "Tony Caduto" <[EMAIL PROTECTED]>
To: "Jim C. Nasby" <[EMAIL PROTECTED]>
Cc: "Bob Pawley" <[EMAIL PROTECTED]>; "Postgresql"
Sent: Monday, May 22, 2006 1:54 PM
Subject: Re: [GENERAL] I
On Tue, 2006-05-23 at 15:56 +, Chris Browne wrote:
> > The use that I have for this at the moment, and I can think of many
> > other uses, is that I want to populate a statistics table each time
> > that a table is updated. But the code to populate the table takes 10
> > seconds to run. I don't
Hi all,
I got the following table:
CREATE TABLE treecategory (
nleft INT4 NOT NULL,
nright INT4 NOT NULL,
box BOX NOT NULL
);
I can't figure out how I can update the box column using the values at
the nleft & nright columns.
For example if I try:
UPDATE treecategory SET box =
'('||"nleft"||
Allen Fair <[EMAIL PROTECTED]> writes:
> Hi! I have a table with a character column (called match_regex)
> containing a POSIX regular expression, hoping to have Postgres use it
> while evaluating the "where" predicate. The following error occurs:
> SELECT *
> from patterns
> where 'blah blah bla
Jim C. Nasby wrote:
On Tue, May 23, 2006 at 01:03:16PM +0200, Frederic Massot wrote:
Hi,
We have an old waiter Postgresql 6.5.3 which regularly had problem and
which crashed.
6.5?! Holy cow, you win the prize for oldest version I've seen.
We have of another server with Postgresql 7.4. :
Hi! I have a table with a character column (called match_regex)
containing a POSIX regular expression, hoping to have Postgres use it
while evaluating the "where" predicate. The following error occurs:
SELECT *
from patterns
where 'blah blah blah' ~ match_regex;
ERROR: invalid regular express
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] ("Jim C. Nasby")
belched out:
> On Tue, May 23, 2006 at 01:03:16PM +0200, Frederic Massot wrote:
>> Hi,
>>
>> We have an old waiter Postgresql 6.5.3 which regularly had problem and
>> which crashed.
>
> 6.5?! Holy cow, you win the prize
Sim Zacks <[EMAIL PROTECTED]> writes:
> Is there any way to write a statement trigger that runs in the
> background? In my testing, when I have an After Insert For Each
> Statement trigger, the function call does not end until the trigger is
> finished processing.
>
> What I would like to do, and p
Has anyone ever seen a database spontaneously change character sets? I
could have sworn that all databases in my replication slave database
cluster were set up as SQL_ASCII. Now they are all UNICODE, and slony
is failing to replicate, due to invalid byte sequences.
Now I can't really *swear* tha
On Tue, May 23, 2006 at 05:03:14PM +0200, venu Vempati wrote:
> Hi group,
> thanks for your previous response about the DB storage in postgres.
>
> now, I have a question for a password related issue.As you can see I have
> problems with my pwd.
> Either I forgot or misconfigured while installing
On Tue, May 23, 2006 at 04:19:56PM +0200, Sim Zacks wrote:
> I am trying to figure out some issues with my functions and I was hoping
> someone could help me.
> My understanding is that the plan is made when the function is run the
> first time. That means that running analyze on a table after a
On Tue, May 23, 2006 at 01:03:16PM +0200, Frederic Massot wrote:
> Hi,
>
> We have an old waiter Postgresql 6.5.3 which regularly had problem and
> which crashed.
6.5?! Holy cow, you win the prize for oldest version I've seen.
I don't know if even Tom Lane has experience with that old a version,
On Tue, 23 May 2006 17:03:14 +0200
"venu Vempati" <[EMAIL PROTECTED]> wrote:
> Hi group,
> thanks for your previous response about the DB storage in postgres.
>
> now, I have a question for a password related issue.As you can see I have
> problems with my pwd.
> Either I forgot or misconfigured w
I do not run the INSERTs concurrently. They are being executed as the
data comes in sequentially. I attempted to create a stand-alone example
to reproduce the issue, but I was not successful. I will post the
example anyway. This example ran fine, and did not hang at any point,
but it might give a g
Hi allI'am facing strang problem while using pgAdmin III to browse DB running on the same machine (localhost) - it is very very slow. Coonect is quite quict, but listing all schemas takes tens of seconds, listing tables in schema takes other tens of seconds, refresing table details takes other seoc
I have define a type arc,but i do not define the +(arc,arc)
operator,instead of +(arc,cstring)when i delete the +(arc,cstring),the
pgadmin3 tells me a error:
ERROR:operator does not exist:arc+arc
---(end of broadcast)---
TIP 4: Have you searched ou
On Monday May 22 2006 4:43 pm, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Wed, May 17, 2006 at 10:29:14PM -0400, Tom Lane wrote:
> >> The reason the default is currently 10 is just
> >> conservatism: it was already an order of magnitude better
> >> than what it replaced (a
Hi group,thanks for your previous response about the DB storage in postgres.now, I have a question for a password related issue.As you can see I have problems with my pwd.Either I forgot or misconfigured while installing the
DB.I have loged in to XP as the user "vgopal" and it's the Admin account
On Tuesday 23 May 2006 11:19 am, Sim Zacks <[EMAIL PROTECTED]> thus
communicated:
--> Is there any way to write a statement trigger that runs in the
--> background? In my testing, when I have an After Insert For Each
--> Statement trigger, the function call does not end until the trigger is
--> fi
Is there any way to write a statement trigger that runs in the
background? In my testing, when I have an After Insert For Each
Statement trigger, the function call does not end until the trigger is
finished processing.
What I would like to do, and please let me know if there is a better way
t
Truncate won't work for me because I don't completely empty the table, I
just empty it for that user.
Each user has the table populated with his data, basically to work like
a temporary table. When the user runs a function it repopulates his
working table and then until he runs the function agai
Sim Zacks <[EMAIL PROTECTED]> writes:
> I have a table that I populate, select and delete the data each time the
> function is run. Each time I run the function it takes longer to get the
> data. In these tests, the data is the exact same every time.
> I tried putting vacuum inside the function,
Rafal Pietrak <[EMAIL PROTECTED]> writes:
> CREATE FUNCTION new_user (text,text) RETURNS SETOF people AS $$
> CREATE ROLE $1 PASSWORD $2;
> SELECT CASE WHEN $2 is not null THEN ROW($1, null, null, null)::people
> ELSE null::ludzie END
> $$ language sql;
> "ERROR: function returning
I am trying to figure out some issues with my functions and I was hoping
someone could help me.
My understanding is that the plan is made when the function is run the
first time. That means that running analyze on a table after a function
is run once won't change the plan.
I have a table that
I agree that the best situation would be to fix the temp tables so they
get replanned each time and therefore don't get converted to an oid.
However, now they are not fixed and I need my application to work. I was
hoping the table variables already existed, not as a request for an
additional fe
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave
PageSent: 23 May 2006 13:15To: Penchalaiah
P.Cc: pgsql-general@postgresql.orgSubject: Re: [GENERAL]
[SQL] some error when executing query in pgAdmin tool
[please keep replies onlist]
Bah, wrong o
[please keep replies onlist]
From: Penchalaiah P.
[mailto:[EMAIL PROTECTED] Sent: 23 May 2006
13:21To: Dave PageSubject: RE: [SQL] some error when
executing query in pgAdmin tool
Hi
sir..
I tried like that
also … same error again
What is the result of:
Hi Greg:
The installer in win32, create a user named "postgres", yes this user is not
an administrator.
And this is ok, security reasons.
Alejandro Michelin Salomon
Porto Alegre
Brasil
-->-Mensagem original-
-->De: [EMAIL PROTECTED]
-->[mailto:[EMAIL PROTECTED] Em nome de Greg
-->Enviad
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Kenneth Downs
Sent: 23 May 2006 12:24
To: pgsql general
Subject: [GENERAL] More confirmation: pgadmin3 freezeup fixed
by wxgtk 2.6.3
I've gotten a chance to upgrade wxG
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Greg
> Sent: 23 May 2006 12:46
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Installing PostGreSQL automatically
>
>
> Ok, I have installed PostGreSQL as a service with pg_ctl.
>
> B
Just a simple "logon as service" User with no administrative
privileges, in no administrator group or similiar whatsoever.
BTW... that "logon as service" is one of the challenging parts; be
carefull with Group Policies.
Harald
On 5/23/06, Greg <[EMAIL PROTECTED]> wrote:
Ok, I have installed P
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Kenneth Downs
> Sent: 23 May 2006 12:24
> To: pgsql general
> Subject: [GENERAL] More confirmation: pgadmin3 freezeup fixed
> by wxgtk 2.6.3
>
> I've gotten a chance to upgrade wxGTK to 2.6.3.2. I
Ok, I have installed PostGreSQL as a service with pg_ctl.
But when I try to start the service using pg_ctl start, I am told I have to
run the service under a non-administrator account. Which account is
used/created by the standard PostGreSQL MSI installer?
-Original Message-
From: Harald
Hi All,
The original reason I tied FUNCTIONS is that I need to extend ROLE
definition as stored within pg_authid system table, with some (more or
less arbitrary) user preferencies profile.
At this point, the task comes down to the point where I can imagine
having an additional table PEOPLE(rolena
I've gotten a chance to upgrade wxGTK to 2.6.3.2. I can no longer
deliberately reproduce the freezeup caused by a double-click on selected
text in the query analyzer.
This btw is using pgadmin3 1.2.
begin:vcard
fn:Kenneth Downs
n:Downs;Kenneth
email;internet:[EMAIL PROTECTED]
tel;work:631-
Hi,
We have an old waiter Postgresql 6.5.3 which regularly had problem and
which crashed.
I recovered a large part of the data saved with pg_dump, except that
which were corrupted.
In the directory "/var/lib/postgres/data/base", I found the files which
correspond to the tables corrupted. With a
Tom Lane wrote:
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
Is the only downside to a large value planning speed? It seems it would
be hard to bloat that too much, except in cases where people are
striving for millisecond response times, and those folks had better know
enough about tuning to be
On Tue, 2006-05-23 at 00:04, Jim C. Nasby wrote:
> I can't imagine how bad this would be if the database actually had
> hour-long reports that had to run... and luckily the system is quiet at
> night when pg_dump runs.
BTW, pg_dump is the only thing that stays in my way with the CLUSTER
strategy a
On Mon, 2006-05-22 at 23:55, Jim C. Nasby wrote:
> BTW, there's a bug/issue with CLUSTER that makes it not entirely
> transaction safe.
For God's sake, don't fix that one ! I rely on it... now seriously,
until there's a way to tell the DB that an exclusive lock is enough to
vacuum all dead rows, e
77 matches
Mail list logo
