t; Peter,
>
> > > I was discussing specifically the "Recognized Corporate Contributors"
> which
> > > is, AFAIK, strictly a PHB thing, no?
> >
> > No.
>
> Please explain.
--
Ryan Mahoney <[EMAIL PROTECTED]>
---(en
ern the files that one is supposed to download..
>
> Thanks in advance for your response.
>
> Carlos Oliva
> Senior Programmer/Analyst
> Positive Business Solutions, Inc.
> Cincinnati, OH 45240-1640
> (513) 772 - 2255 ext 129
> [EMAIL PROTECTED]
> Yahoo ID: ramboid_1997
--
Ryan Mahoney <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
>> Are you suggesting that I:
>> a. use a different datatype in plpgsql or
>> b. cast the values or
>> c. change the data type in the table
>
>Yes ;-). Presumably (b) would be the least painful route, but any of
>these would do the trick.
It turns out that the text and char(5) we
>Ryan Mahoney <[EMAIL PROTECTED]> writes:
>> Index Scan using pa_zipcode_proximity_pk on pa_zipcode_proximity (cost=
>> 0.00..13.53 rows=3 width=862)
>>Index Cond: ((zipcode = '11103'::bpchar) AND (proximity <= 100))
>> (183 rows)
>
>
teger. There is a primary key on zipcode and proximity. We are using
PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96. Any ideas?
We have recently done a vacuum full and analyze.
Any help is much appreciated!
-r
--
Ryan Mahoney
[EMAIL PROTECTED]
(718)721-8790
"Tom
teger. There is a primary key on zipcode and proximity. We are using
PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96. Any ideas?
We have recently done a vacuum full and analyze.
Any help is much appreciated!
-r
--
Ryan Mahoney
[EMAIL PROTECTED]
(718)721-8790
"Tom
all the mailing lists, there
would probably be less confusion. When I read the announcement I was
very impressed and went straight to www.postgresql.org. Once I got
there, I wondered if maybe the announcement had been sent by accident!
-r
--
Ryan Mahoney
[EMAIL PROTECTED
What version of postgres are you using? I am using PostgreSQL 7.3b1 on
i686-pc-linux-gnu, compiled by GCC 2.96 and when I execute the following
statement:
select '{124,567,66}'::int[] + 345;
I get the error:
ERROR: cache lookup failed for type 0
Any ideas?
Thanks for your help!
-r
---
] + '{345,1}'::int[];
>?column?
>
> {124,567,66,345,1}
> (1 row)
> select '{124,567,66}'::int[] - 567;
> ?column?
> --
> {124,66}
> (1 row)
> regression=# select '{124,567,66}'::int[] - '{567,66}
integer array?
I see the function in the documentation, but the actual statement syntax to
use is not clear to me.
Thanks for any help you can provide!
Ryan Mahoney
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
Haven't tried yet, but perhaps casting nummonths to an interval datatype
would do the trick.
-r
At 04:30 PM 9/26/01 -0400, Vince Vielhaber wrote:
>I'm trying to use an integer from a table to add/subtract time in months.
>IOW:
>
>create table foo(nummonths int);
>
>select now() - nummonths mo
Error codes would be excellent!
-r
>In our PHP app, we are also forced to parse error messages to get that kind
>of information. Register my vote for error codes (Tom Lane style...)
>
>Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
What is it? 8) is it middleware? Is it pre-built applications? I'm confused!
-r
At 11:34 PM 9/12/01 -0500, Haroldo Stenger wrote:
>Hi dear people,
>
>(My condolences to all afected by terrorist acts in US)
>
>As I have been telling for a while, GeneXus database rapid application
>developing
Write very optimized statements and run them infrequently ;)
I don't really think it's possible. You need to understand how your
application will be used, what the resource costs are, and plan
accordingly, (load balance, etc.)
-r
At 05:00 PM 6/18/01 +, gabriel wrote:
>Hello All.
>
>Ho
I think there is really something weird about the Zend site - I use the
current IE on an NT machine, and every page loads, but then I have to wait
about 10 additional seconds before IE "wakes up" and I can click any links
or go to a different page.
I think it may have something to do with the
This value can be dynamically changed by:
echo "new value here" > /proc/sys/kernel/shmmax
Glad I bought that expensive RedHat support contract!
-r
At 08:02 PM 5/24/01 +0200, Poul L. Christiansen wrote:
>I think you still need to set your shared memory size, because my Redhat
>7.1 gives me thi
>This is true. You can adjust the value in the /proc/sys/kernel/shmmax
>file. If you change the value it will be reset when you reboot, so you
>will need to write a start-up script to always change this value if you
>want it to be permanent.
>
>-r
>
>At 09:51 AM 5/24/01 -0700, you wrote:
>
>
Thanks to input Bruce M., figured out my performance problems - had to do
with a few QUERIES FROM HELL! After running EXPLAIN a few times I fine
tuned some of the worst ones, mostly over use of sub queries. Still
combing through my query log.
Getting there...
-r
---
Outgoing mail is certi
Here is some output from top...
9:20pm up 40 min, 1 user, load average: 3.77, 3.12, 3.74
41 processes: 36 sleeping, 5 running, 0 zombie, 0 stopped
CPU states: 99.2% user, 0.7% system, 0.0% nice, 0.0% idle
Mem: 515664K av, 303712K used, 211952K free, 37476K shrd, 39552K buff
Swap: 5
!! I haven't ran VACUUM ANALYZE since last night. Just ran it -
performance has improved significantly. I think I am going to have to run
it hourly during this high traffic time. Postmasters are still utilizing
about 100% of the CPU. Is this normal? I am considering increasing the
shmmax
I am running Postgresql 7.1 on a dedicated Redhat 7.0 box with 512meg ram
and an IDE hard drive.
All day long queries that usually seem to execute instantaneously have been
taking up to 10 second to run! I generally have about 6 postmasters
running, utilizing anywhere from 1% to 96% CPU utili
You probably already thought of this - but - why not just set up a
centralized server and have each office interact to the db via a web
interface. Let your application enforce security (apacheSSL, use db for
user auth) and to prevent two users from editing the same record
simultaneously.
-r
22 matches
Mail list logo
