- 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]
was discussing specifically the Recognized Corporate Contributors
which
is, AFAIK, strictly a PHB thing, no?
No.
Please explain.
--
Ryan Mahoney [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your desire
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
?
{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}';
?column?
--
{124}
(1 row)
Ryan Mahoney wrote:
Hi Oleg (and pgsql hackers!),
Recently I
of an 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
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 months;
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 tool,
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.
How
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 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:
In 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 this:
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
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
!! 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
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:
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
17 matches
Mail list logo