Not an expert, but I would try a temporary unlogged table.
Sent from my android device.
-Original Message-
From: Johannes
To: pgsql-general@postgresql.org
Sent: Mon, 08 Feb 2016 11:07
Subject: [GENERAL] execute same query only one time?
Hi,
is there a best practice to share data betwee
Wondering in their is an ETA on a dmg installer for the mac that does not fail
on Lion?
Best,
-Travis
mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2008 3:22 PM
To: Travis Smith; pgsql-general@postgresql.org
Subject: Re: [ADMIN] Query performance difference
What do you want to say?
Please give details. I got an explain from PGAdmin,
as follows
"GroupAggregate (cost=28927.37..35594.39 rows=1
It may be worth-wile to generate an explain plan
http://www.postgresql.org/docs/8.3/interactive/sql-explain.html
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of c k
Sent: Thursday, August 21, 2008 2:49 PM
To: pgsql-general@postgresql.org; [EMAIL PROTECTED]
Subject: [ADMIN] Quer
and Oaks, CA
>
> ---(end of broadcast)---
> TIP 4: Have you searched our list archives?
>
>http://archives.postgresql.org/
You could use "limit" to set the max returned result set allowed when
you put togeth
if that's necessarily what we want.thank you,Travis
I would like to use P* to store files. These files will probably
range from 500K to 2 MB in size and there will be thousands upon
thousands of them. I was wondering how P* stores blobs, if it is all
in one file, or if each blob is sored in it's own file. The reason
being, I know that windows has
They're used to be a sound bite on postgres.org on how to pronounce it
properly.. any idea where that went?
Travis
-Original Message-
From: Marc G. Fournier [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 7:46 PM
To: Craig O'Shannessy
Cc: Chris Stokes; John Wel
1) how can I tell which users are in my group?
2) I have granted all to a group but they can not alter my table.. is that correct?
I'm using 7.2
Travis
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
so.. what exactly are you trying to say here? ;)
I think this is the funniest post I've ever seen on this list!!!
Travis
-Original Message-
From: Nigel J. Andrews [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 5:47 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subjec
storage.. either via tape or another box with enough storage
space. Your best bet is to have geographical redundancy.
Travis
-Original Message-
From: Lincoln Yeoh [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 14, 2003 10:20 AM
To: Lamar Owen
Cc: PgSQL General ML
Subject: Re: need for in
about 5% of b are null.. any idea on how to word a query like what I'm
looking for? I have no idea in SQL how to use the results of one select
in another (I usually just do all of it in perl).
Travis
-Original Message-
From: Jeffrey Melloy [mailto:[EMAIL PROTECTED]
Sent: Friday, A
btw.. thanks for all the help.
Travis
-Original Message-
From: Jeffrey Melloy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 2003 12:32 AM
To: Williams, Travis L, NEO
Cc: Thomas A. Lowery; [EMAIL PROTECTED]
Subject: Re: [GENERAL] Join question
On Thursday, August 28, 2003, at 09:03
Performace wise would I be better off just doing 2 query's.. i.e. select
a,b from table1.. then in perl I can check if b is not null and if is
isn't then I do a second query?
Travis
-Original Message-
From: Jeffrey Melloy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 200
Yeah.. so that's why I didn't know if I could do it all in the same
statement.
Travis
-Original Message-
From: Thomas A. Lowery [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 28, 2003 8:54 PM
To: Williams, Travis L, NEO
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Join que
ct d from table2 where d like '%b%'" There is
nothing to join between table1 & table2 (unless you can join on likes ;)
).
but thanks for showing me unions.. (I just learned about joins).. more
knowledge to help me on my way!
Thanks,
Travis
-Original Message-
From: Tho
Sure.. if it works.. I'm just trying to not have to make multiple calls
to the DB.. I'll try it out..
Thanks,
Travis
-Original Message-
From: Thomas A. Lowery [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 28, 2003 8:06 PM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Joi
Didn't know if it would be any faster..
Travis
-Original Message-
From: Ron Johnson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 3:00 PM
To: PgSQL General ML
Subject: Re: [GENERAL] multiple insert into's (may be NEWBIE question)
On Tue, 2003-08-05 at 14:42, Ste
Thanks..
Travis
-Original Message-
From: scott.marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 2:16 PM
To: Williams, Travis L
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] multiple insert into's (may be NEWBIE question)
On Tue, 5 Aug 2003, Williams, Travis L,
I have a table (lets say a,text b,text) and I want to insert the data jim,jimmy and
trav,travis can I do this with 1 insert into statement instead of 2?
Travis
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
ve autocommit turned off? I appearantly have to send
both a "COMMIT" statement to the back end and then execute the
Connection's commit() method to get the transactions committed.
Why is that?
Thanks,
--
----
the 7.1 JDBC driver that would
occassionally produce the "InputStream as parameter not supported"
error?
Thanks
--
--------
Travis Bauer | CS Grad Student | I
ommands are included.
--
----
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
Hitesh Patel ([EMAIL PROTECTED]) wrote:
> I need to be able to execute SQL
akefile.PL script which would allow people to customize the
operation mask that plperl.so uses. I have to use the :base_math
mask because I need sqrt. When plperl is re-enabled in the
configure script, it should be added there too.
--
----
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
code which calls sqrt. Can someone tell me how to get around
this?
Thanks,
--
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
When you compiles php, did you ./configure with --with-pgsql? If you did
not compile php explicitly telling it to includ pgsql support, it probably
didn't.
Travis
Brian Edginton ([EMAIL PROTECTED]) wrote:
>
>
> I'm trying to use the php/postgresql interface via my apac
I'm using postgres through JDBC as the backend for my research so I have a
great interest in having a better driver. I'll pitch in.
--------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.ed
I'll second Bookpool for computer books. I've used them a couple of times
and they are good.
--------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
--
Tom,
Thanks. Running ipcclean fixed it right away.
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
On Mon, 9 Oct 2000, Tom Lane wrote:
> Tra
hanks,
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
;s web site for people
who wanted it.
----
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
On Thu, 28 Sep 2000, Keith L. Musser wrote:
> I know all of you
I sent this to PATCHES last week, but it did not show up on the list.
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
-- Forwarded message
nd why they didn't
show up in ps or ps -a.
Thanks,.
----
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
On Thu, 31 Aug 2000, Tom Lane wrote:
>
> Well, the /tmp files are for non-
Does the JDBC driver support the user of cursors in postgresql 7.0.2?
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
to have a password to log ont the
database, but allow the cron job to connect (through jdbc) without needing a
password? that way I would not have to put the password in plain text in
the script.
Thanks,
Travis
I have a problem with a _very_ slow query. I'm not sure how to understand
the explain output. Can anyone tell from the following where I might look
for a bottleneck in the system?
Thank,
Travis
psql:test.sql:1: NOTICE: QUERY PLAN:
Nested Loop (cost=3.03..240.90 rows=4 widt
Thanks,
Now that you mention it, I even remember reading it in the book!
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
On Wed, 12 Jul 2000, Ross
.
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
On Tue, 11 Jul 2000, Peter Eisentraut wrote:
>
> Is anyone else noticing this: Everytime this sort of thing come
.
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
On Mon, 10 Jul 2000, Thomas Krebs wrote:
> > >I am trying to get a start with Postgres 6.4 on Suse Linux 6.4.
> > I did that just 2 weeks ago.
>
select statement), you get a permission
denied error.
The workaround I did was to create a bunch of extra subview which user1
has access to. This works, but seems like the above scenerio shouldn't be
causes the permission violation.
-----
ermissions.
--------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
.
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
k you,
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
.
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
On Tue, 6 Jun 2000, Tom Lane wrote:
>
> Sounds like the jdbc driver also gets confused when it sees typmod -1
> for a numeric field.
>
driver
takes _forever_ to retrieve these fields into big decimal. 3. I really
don't want to reconfigure my database to use floating points :)
Thanks,
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
Ooops. I have to withdraw that comment. I spent hours the other day
beating my head against the wall over this. I was sure that it didn't
work . . .
Sorry,
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~tr
code?
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
On Tue, 23 May 2000, Chris Chan wrote:
>
> I'm pgsql newbie. I try to install the pgsql 7.0 on my Solaris 8 x86 server
> but fail. The fol
rks much better.
----
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
> Original Message
> Date: Fri, 19 May 2000 23:19:25 PDT
> From: "santosh behera" <[EMAIL PROTECTED]>
&
ction
can be quite frustrating.
--------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
configured properly on my machine. I'm using Mandrake 7.0, and the only
copy of libperl.so that I can find is in: /usr/lib/apache (thanks to the
mod-perl rpm).
How do I get libperl.so so I can compile plperl?
Thanks,
----
Travis
itten in C++. If there a performance cost to using
routines in shared libraries?
--------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
I have tr version 1.22 (GNU texutils). It is located in /usr/bin, and is
found by my login shell (cshrc).
How could I check the locale setting?
Thanks,
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
Thank you, I think that is what it is. I noticed that when the view
fails, it the values that are incorrect are sums of what should appear in
multiple records. Is there any obvious way around this problem?
Thanks,
Travis Bauer
help me a lot. If this doesn't work, my Java
application has to do a lot more work. I'm trying to pass off these
calculations to the database.
----
Travis Bauer | CS Grad Student | IU |www.cs.
,
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
55 matches
Mail list logo
